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 Mustafa,

Thanks for your reply. SDI is already implemented (to extract S/4 data to Hana cloud platform) in existing project flow.

Teradata contains more than 5 ERP at this point of time.

My question is how to replace Informatica from the flow? Can BAS on BTP (Cloud foundry) a possible solution? or suggest other approaches.

Thanks in advance,

Ashutosh

[MustafaBensan]

Are the 5 ERP systems you are referring to S/4HANA systems for which the data is provisioned in SAP HANA Cloud using SDI?