Push data from a CSV file to SAP Analytics Cloud (SAC) using Integration Suite

[tbellil]

Hello everyone,

I would like to know if it’s possible to push data from a CSV file into SAP Analytics Cloud (SAC) using SAP Integration Suite.

 My goal:
Automate the data load process from an external source (CSV format) into SAC, ideally into a planning model or a dataset.

 What I’ve done so far:

• CSV file is available and accessible via SFTP.

• I’ve set up a basic iFlow in Integration Suite to read the file.

• I’m now trying to understand how to push that data into SAC—what endpoint or API to use? What format is expected by SAC?

• Any sample iFlow, blog post, or documentation to guide the process?

Thanks in advance for your help!

[Muniyappan]

You could create sap incident ticket under SAC and ask for api details.

[felipe_correa]

Hello, Yes, it's definitely possible to automate loading data from a CSV file into SAP Analytics Cloud (SAC) using SAP Integration Suite. This is a common integration scenario. Here are the key steps and considerations:

• SAC API: The primary API you'll need is the Data Import Service. This service handles importing fact and master data into SAC models or datasets. You can find details about this and other relevant SAC APIs on the SAP Business Accelerator Hub: SAP Analytics Cloud REST APIs.

• Integration Flow (iFlow) Trigger: Start your iFlow in SAP Integration Suite with an SFTP sender adapter to pick up the CSV file from your source.

• Data Transformation in iFlow: You'll need to convert the CSV data into the format expected by the SAC API. This typically involves using a CSV to XML/JSON converter followed by a Message Mapping step. The mapping ensures your CSV columns correctly align with the dimensions and measures in your target SAC model or dataset, structuring the output as the required JSON payload for the API.

• API Call from iFlow: Use an HTTP or OData receiver adapter to call the specific endpoint of the SAC Data Import Service.

• Authentication: Configure the receiver adapter with the appropriate authentication method for SAC APIs. This is usually OAuth 2.0, which requires setting up an OAuth client in SAC and configuring the corresponding security artifact (credentials) in Integration Suite.

• Target in SAC: Ensure your target model (planning or analytical) or dataset is correctly set up in SAC to receive the data structure you are sending from the iFlow.

By exploring the Data Import Service documentation via the provided link, you'll find the specific endpoints, expected payload structure (JSON), and authentication details needed. Searching for blog posts on "SAP Integration Suite SAC data import" might also provide practical examples.

Hope this helps you get started!
F

SAP Integration Suite 

[tbellil]

Hello, Thank you for your response. We were able to find those APIs, but unfortunately, we cannot use them because, in our environment, we are not able to select eu10.analytics.cloud.sap. Would you happen to have any other solutions, please?