3304951 - Checkpoints: Data Integration Between SAP Analytics Cloud (SAC) Data and SAP Datasphere (DS)

1. This article includes a summary of critical steps for data integration between SAP Analytics Cloud (SAC) and SAP Datasphere (DS).

2. A user has one of the following issues when loading (importing / exporting) data between SAC and DS:
   
   1. DS: Cannot get remote source objects: Could not get tables, Code: 403, SQL State: HY000 
   2. DS: getChildrenFailed
   3. SAC: Please contact your administrator 
   4. SAC: https://.../api/v1/dataexport/administration/$metadata URL gives HTTP error 404
   5. DS: internal error: Error occurred when reading data from entitySet 
   6. DS: API Provider cannot be identified or user
   7. DS: OAuth Client is not allowed to interact 

• SAP Analytics Cloud (Enterprise)
• SAP Datasphere

1. SAP Analytics Cloud (SAC) online help documentation and community resources:
   1. SAP Analytics Cloud
   2. https://community.sap.com/topics/cloud-analytics
       
2. SAP Datasphere (DS) online help documentation and community resources:
   1. SAP Datasphere
   2. https://community.sap.com/topics/datasphere
       
3. Import data from DS into SAC:
   1. SAC: OData Service connection
      1. Prerequisites for Consuming Data from SAP Datasphere in SAP Analytics Cloud via the OData Services Connection.
      2. Data Service URL: https://<your-dwc-tenant-url>/api/v1/dwc/consumption/relational/<space-id>/<asset-id>/
      3. Authentication Type: OAuth 2.0 Authorization Code.
      4. OAuth Client ID, Secret, Token URL and Authentication URL.
         1. one OData Service connection is required per SAP Datasphere view.
             
   2. DS:
      1. Consume Data in SAP Analytics Cloud via an ODATA Service
      2. Transfer Data from SAP Datasphere to SAP Analytics Cloud
          
4. Export data from SAC to DS:
   1. SAC Side: 
      1. SAP Analytics Cloud Data Export Service (DES)
         1. REST API: api/v1/dataexport
         2. Data Service URL Sample: https://<your-SAC-tenant-url>/api/v1/dataexport/administration/Namespaces(NamespaceID='sac')/Providers 
            1. single quote ' not double quote "
      2. SAC Model:
         1. Manage API Subscriptions for Data Exports
              
   2. SAP Datasphere Side:
      
      1. Transfer Planning Data into SAP Datasphere
      2. Cloud Connector
      3. Cloud Data Integration
          
   3. DS: Data Flow Scenario:
      1. Data Flow
          
   4. DS: Verify the connection status
      1. Check the connection ID assigned in remote table
      2. Validate the connection ID in the connection page
      3. "adapterName"
      4. "remoteSourceName" 
          
5. SAC Live Data Connections to SAP Datasphere
    
6. Troubleshooting for api/v1/dataexport:
   1. SAC Help document: Error Codes & Troubleshooting
   2. https://XXX(replace withSAC tenant)/api/v1/dataexport/providers/sac/XXX(replace with modelID)/FactData
   3. https://XXX(replace withSAC tenant)/api/v1/dataexport/administration
       
7. Data Provisioning Agent
   
   1. DP Agent: Always use latest version:
      1. SAP for Me Software Center 
         → Support Packages & Patches tab 
         → By Alphabetical Index (A-Z) 
         → H 
         → SAP HANA SDI
         → SAP HANA SDI <version_number> 
         → Comprised Software Component Versions 
         → HANA DP AGENT 2.0
   2. DP Agent Log
      1. Enable Access to Data Provisioning Agent Logs
      2. 2461391 - Where to find Data Provisioning Agent Log Files
   3. DP Agent Version:
      1. 2563103 - How to check the Data Provisioning Agent version
      2. Quick Win: Upgrade: DP Agent to latest version 
   4. Trouble Shooting:
      1. 2938870 - Errors when connecting DP Agent with SAP Datasphere
      2. 3324075 - DP agent shows disconnected status in SAP Datasphere
   5. Related Error Code:
      1. CDI based connectivity issue: getChildrenFailed
         1. 3202766 - Error getChildrenFailed when expanding folders in SAP Datasphere 
             
8.  Performance
   1. 3298660 - How does the SAP Analytics Cloud (SAC) data export service (DES) API work with larger volumes of data?
   2. Page size 
   3. Memory size
       
9. To submit a SAC/DS issue

1. 1. SAC side: 
      
      1. SAC tenant link
      2. SAC model link
      3. SAC story link 
      4. OAuth Entry ID
      5. Connection ID to DS
      6. Enable SAC support user by System > Administration > System Configuration page > Turn on Allow SAP support user creation
          
   2. DS side: 
      
      1. DS tenant link
      2. DS data flow ID or remote table ID
      3. DS Space ID
      4. DS View ID
      5. Connection ID (under ...dwaas-ui/index.html#/connections)
      6. Enable DS support user by 2891554 - How to create a Support User in SAP Datasphere
             
   3. Select component in Launchpad:
      1. SAC component: Data Export Service: LOD-ANA-ML-DI
      2. DS component:
         1. DS-DI-CON Connections
         2. DS-DI-RT Remote Table
         3. DS-DI-DF Data Flow
      3. DP Agent component:
         1. HAN-DP-SDI  SAP HANA smart data integration (SDI)

• Blogs tagged SAP Analytics Cloud data export service  
• Introducing the Bi-Directional Integration of SAP Data Warehouse Cloud and SAP Analytics Cloud for Planning
• Realtime (delta) Data Replication from SAP Analytics Cloud to BW/4 HANA | SAP Blog
• Leverage the SAP Analytics Cloud Data Export Service to extract your planning data to SAP HANA, SAP Business Warehouse and SAP S/4HANA
• 2854764 - Guidelines for SAP Datasphere Incidents
• 2891554 - How to create a Support User in SAP Datasphere

Data Export Service API; service; SAC; OData; API; DWC; live planning, ETL, DP Agent; CDI；Bi-Directional Integration of SAP Data Warehouse Cloud and SAP Analytics Cloud for Planning.  smart data integration, Datasphere, ds, api/v1/dataexport  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 epm, business intelligence, dwc data warehouse cloud, adapterName, CloudDataIntegrationAdapter, remoteSourceName, /api/v1/dataexport/providers/sac/, /api/v1/dataexport/administration, factdata , KBA , LOD-ANA-ML-DI , Data Integration, Data Export API, Data Import API , DS-DI-CON , Connections , HAN-DP-SDI , SAP HANA smart data integration (SDI) , Problem