Technical Articles
SAP Data Intelligence: How to push data from SAP DI to SAC
Here we can find out how to create Dataset using CSV file in SAP Data Intelligence with the help of Data preparation. By using Modeler, we can understand process to push data from DI to SAC under the governance of IT.
Scenario
In this exercise we will take sample sales data per quarter and upload from desktop and use Factsheet to make profiling
System Preparation
For implementing this scenario, you require:
- Access to SAP Data Intelligence
- A Cloud storage to which SAP Data Intelligence can connect
- Data preparation
- Create dataset
By using Data preparation, we can achieve all these functionalities.in CSV file e.g. like replace, remove and formatting CSV data based on our requirement
Step 1: Click Browse Connections
Select CLOUD_STORAGE
Click upload CSV Company Sales data and view fact sheet to preview the data
Select data Fact Sheet and data preview
Click Data preparation and we can remove duplicate data and replace and the data and then click Actions
While Clicking Run Preparation here system created DATASET as mentioned name and with the same name DATASET should be created in SAC
Data Pipeline point of view we need to use SAP DI Modeler to make required Pipeline to transfer data from SADI to SAC
Go to Modeler and search push SAC Analytical Cloud we can find as show below
We need to open each step Configuration and required information to be added as shown below
Read File
SAP Analytical Cloud configuration below
SAC Analytical Cloud Config steps
After that we have to save and Run the Pipe line
After successfully run we can see as below
Once you login in SAC Tenant the DATASET created with the same name given SAP DI system as shown below
while opening DATASET in SAC we can see same data as in SAP DI.
data preview in SAC
Thank you so much!!
Ramesh Talari
Nice blog which give me a fair idea on data pushing to DI
cheers
Kishore Madireddy
Hi,
will it be possible to send the data directly to a model and update accordingly ?
We understand at the moment only datasets can be created in SAC.
Regards
Marcus