BAS on BTP to replace Informatica..

[ashutosh_shrivastava4]

Hi Experts,

We have requirement to replace Informatica from below flow -

This is high level solution architecture.

So here I will talk about only SAP flow. S/4 Hana data is extracted using SDI to BTP and further logic and Transformations are written on Informatica to push the data to Teradata.

Teradata is a global storage where data is coming from all other sources (Oracle/BPCS/SAP). Dashboards (Cognos / Tableau) are created on top of Teradata to consume data from all data sources and regions (US/EMEA/APAC).

Now, We SAP team is planning to replace Informatica. One possible solution would be, create a calculation view on BTP using BAS (replicate logic and transformation from Informatica).

Please suggest what could be the other approach to look into this scenario.

Thanks,

Ashutosh

[MustafaBensan]

Hi ashutosh.shrivastava4,

To enable a more targeted response from the community, it would be helpful if you could provide more context for your requirement by answering the following questions:

1) When you say "S/4 Hana data is extracted using SDI to BTP", I assume you are currently replicating the data into an SAP HANA Cloud database and then applying logic and transformations before pushing this data to Teradata via Informatica. Is that right?

2) What is the reason for staging the data in BTP (SAP HANA Cloud) first before sending to Teradata? Have you thought about solutions for extracting from S/4HANA directly into Teradata?

3) What is the reason for wanting to replace Informatica as the data orchestration middleware?

4) Do you currently have either SAP Integration Suite or SAP Data Intelligence in your landscape?

5) Your proposed approach of creating a calculation view on SAP BTP (presumably in SAP HANA Cloud) may address the business logic and transformation requirement. Are you asking if this approach is used, what a recommended data middleware would be to consume the calculation view and transfer the data to Teradata?

Regards,

Mustafa.

[ashutosh_shrivastava4]

Hi,

So, All ERP's data extracted by Informatica respective to their project flow.

Example--

User can create reports based upon his choice of ERP's field (May be master data and transaction data are from different ERP). So, all ERP's fields mapping is done in such a way at Teradata.

Thanks,

[MustafaBensan]

I thought the SAP S/4HANA data goes into SAP HANA Cloud first?