Connection between SAP Data Warehouse Cloud and SAP Data Intelligence Cloud
this blog and any advice that comes with it is not part of an official product of SAP. I am hoping you will find this information useful and create your own connection between Data Warehouse Cloud and Data Intelligence without any problems.
I used SAP Data Warehouse Cloud (Version 2020.16.51) and SAP Data Intelligence Cloud (Version 2006.1.8).
Create Open SQL Schema in DWC
First of all, you need to create Open SQL Schema in SAP DWC. Here you will find the details how to do this. Then you must add DI IP address to DWC IP Allowlist. How to find your DI IP address you will find here.
Create connection in DI
On the DI side go to Connection Management. Click on Create Connection and choose HANA_DB as a type of the connection. You must provide information such as host, port, user and password of your Open SQL Schema in DWC. Before closing this window, test your connection. You should see “Test Connection Status: OK”. If you will see any errors, you should check your Open SQL Schema in DWC.
Next go to ML Scenario Management and create your scenario for this use case. In your ML Scenario go to pipelines and click on create. In this blog we will create the pipelines for two options:
- The source system is Data Intelligence Cloud and the target system is Data Warehouse Cloud
- The source system is Data Warehouse Cloud and the target system is Data Intelligence Cloud
Import data from SAP DI into SAP DWC
The two necessary operators are Structured File Consumer and Table Producer. The first one you need to define a file for importing into DWC and the second operator defines a target table in your Open SQL Schema.
For the operator Structured File Consumer choose a file that you want to import.
For the operator Table Producer choose the existing table or give a new name for the target table. I am going to create a new target table with the name “DI_TEST”.
Save and run this pipeline. Then go to your space in SAP DWC, select Data Builder and you will see the table that was imported from Data Intelligence:
Import data from SAP DWC into SAP DI
In the configuration for Table Consumer Operator choose a table that you want to import from DWC into DI. For Structured File Producer select where you want to storage the table. Then save and run the new pipeline. I want to save the table local, so I selected local as a storage type.
In order to find your table, go to System Management and the Files:
I hope you could follow along and can now use your connection between SAP Data Intelligence Cloud and SAP Data Warehouse Cloud.
Thank you, Laima Laka, for giving me advice about DI.