IntroductionIn this article I will share work experiences of using a custom CDS view on Joining BKPF and BSEG table in S4HANA and consuming it in SAP Datasphere for delta enabled replication (Change Data Capture) to Azure Data Lake Storage Gen2.Creat...
This blog post outlines the creation of a real-time pipeline in SAP Data Intelligence (DI) for continuous file replication from one storage location to another. For example, when a file is uploaded or generated in your source storage location, such a...
While data is a critical asset for modern businesses, the ability of technology to scale has resulted in a flood of big data. Data management and storage has evolved into a necessary component for modern operational processes.
Snowflake, a cloud dat...
Hi,
We have a requirement to load the data into Snowflake target tables. We have table producer operators in SAP DI 3.2 but it support only Hana DB , not any other relational databases.
Just wanted to know if there is any way to load the data int...
Hi,
We have to execute ML model in DI Graph which involves libraries like xgboost,fbprophet,sklearn,statsmodels etc.
We have successfully created two docker files using below code:
1. Installing xgboost/fbprophet as tag "fbprophet-xgboost"
FR...
Hi Alessandro,One of the option can be to connect oracle DB from DI Cloud is using a python library i.e. CX_ORACLE.Need to create custom python operator and import CX_ORACLE library . Also, it provides inbuilt function to fetch records from database....
Hi Rajesh,As per your requirement, below can be the design of your DI pipeline :Requirement is read hana column table (table1) and then map & call an external API and get the API response and eventually map & send the API response to Hana table(table...
Hi Michael,You can export data preparation file to DI_DATA_LAKE /Database table.While running preparation you can mention target connection and container. Once preparation is completed a file /Table will get generated at the target location.Thanks,An...
Hi Armaan, Regarding Delta Handling using Gen2 operator , Below is one of custom solution approach :1.In Order to pause/resume graph automatically we have to use SAP Data Intelligence API available in API business hub. Please check below discussion o...
Hi Shubha,Below is a graph snippet to load data into the HANA table:You have to mention the table name and columns in the Hana client operator. Also this sample graph is available under scenario templates in Modeler.Thanks,Ankit