12

BAS on BTP to replace Informatica..

 1 year ago
source link: https://answers.sap.com/questions/13894775/bas-on-btp-to-replace-informatica.html
Go to the source link to view the article. You can view the picture content, updated content and better typesetting reading experience. If the link is broken, please click the button below to view the snapshot at that time.
neoserver,ios ssh client
16 hours ago

BAS on BTP to replace Informatica..

34 Views Last edit 15 hours ago 2 rev

Hi Experts,

We have requirement to replace Informatica from below flow -

This is high level solution architecture.

gbr.jpg

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

Attachments
gbr.jpg (32.3 kB)
1 comment
18 minutes ago

Hi ASHUTOSH SHRIVASTAVA,

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.


report

Recommend

About Joyk


Aggregate valuable and interesting links.
Joyk means Joy of geeK