3368160 - How to import data to the SAC planning model using the Data Import Service (DIS) API in SAP Analytics Cloud (SAC)

The expectation is to import fact data to the SAC planning model using the Data Import Service (DIS) API in SAP Analytics Cloud (SAC).

On the online help api/v1/dataimport, it lists all the endpoints available. However, it is not clear how to use these endpoints to actually import data to the SAC.

• SAP Analytics Cloud (Enterprise) 2023.Q2 and higher

There are 2 approaches.

• Step-by-step approach (for huge planning models where a big number of rows is to be imported)
  1. /models/modelID/factData: Create a factData job. The system allocates a staging area (temporary storage) for this job.
  2. /jobs/jobID (POST): Add data to the staging area. The SAC model is untouched.
  3. /jobs/jobID/validate: Validate the job. The rejected rows and the reason for failure can be fetched using the endpoint /jobs/jobID/invalidRows.
  4. /jobs/jobID/run: The actual run to import the data into the SAC model. The job is executed in background asynchronously and the status can be fetched using the endpoint /jobs/jobID/status. 
     
     
• One-click approach (recommended when a small amount of rows is to be imported)
  1. /import/modelID/factData: The job is executed in the synchronous mode

• SAP Analytics Cloud REST API online help for the Data Import Service API
• SAP Analytics Cloud REST API online help for the Data Export Service API
• KBA 3340354 - Data is missing in the SAP Analytics Cloud (SAC) model when you load data with the Data Import Service API
• KBA 3491183 - Current modelID reached limit or maximum number of active jobs [1007] - Troubleshooting Guidelines

SAP Cloud for Planning, sc4p, c4p, cforp, cloudforplanning, Cloud for Analytics, Cloud4Analytics, CloudforAnalytics, Cloud 4 Planning, BOC, SAPBusinessObjectsCloud, BusinessObjectsCloud, BOBJcloud, BOCloud., SAC, SAP AC, Cloud-Analytics, CloudAnalytics, SAPCloudAnalytics,Error, Issue, System, Data, User, Unable, Access, Sac, Acquisition, Model, Connect, Story, Tenant, Import, Failed, Using, Working, SAP Cloud for Planning, sc4p, c4p, cforp, cloudforplanning, Cloud for Analytics, Cloud4Analytics, CloudforAnalytics, Cloud 4 Planning, BOC, SAPBusinessObjectsCloud, BusinessObjectsCloud, BOBJcloud, BOCloud., SAC, SAP AC, Cloud-Analytics, CloudAnalytics, SAPCloudAnalytics,Error, Issue, System, Data, User, Unable, Access, Connection, Sac, Connector, Live, Acquisition, Up, Set, setup, Model, BW, Connect, Story, Tenant, Import, Failed, Using, Working, SAML, SSO, sapanalyticscloud, sap analytical cloud, sap analytical cloud, SAC, sap analyst cloud, connected, failure, stopped, sap analyst cloud, https://hcs.cloud.sap, https://hanacloudservices.cloud.sap, https://cloudanalytics.accounts.ondemand.com, https://hanacloudservices-us.accounts.ondemand.com, https://www.sap.com, https://help.sap.com, predictive analytics (analysis), data analysis (analytics) tools, analytics tools, sap analytics cloud, data literacy, advanced analytics, data democratization, analytics software, real time analytics, self service analytics, advanced data analytics, analytics as a service, analytics cloud / cloud analytics, saas analytics, cloud bi, enterprise planning, cloud data analytics, cloud based analytics, analytics cloud platform, modern analytics, real time analysis, cloud analytics solution(s), what is sap analytics cloud, cloud analytics tools, analytics in the cloud, cloud analytics software, import data API, import data service API, load the transaction data , KBA , LOD-ANA-ML-DI , Data Integration, Data Export API, Data Import API , How To