9_Export_to_DWC

9 - Export to DWC

We now want to export the generated plan data from SAP Analytics Cloud to SAP Data Warehouse Cloud. The plan data could be used for downstream processing and combined plan vs. ACT reporting there.

9.1 - OAuth Client in SAP Analytics Cloud

An OAuth Client has already been set up in SAP Analytics Cloud. You need its credentials and the SAC system's token URL. Since you are not authorized to go to System - Administration - App Integration (where you would usually find this), please use the following credentials and URLs:

If your SAP Analytics Cloud URL includes EU10 (e.g. https://academy-t-sac.eu10.hcs.cloud.sap/):
OAuth Client ID: sb-25518ec4-4cc5-444f-883b-97ce341a9e18!b130365|client!b3650
Secret: cccfdbbc-9a90-4bc8-9c4e-2b8d50102bf6$xzsl5LGQNwvZIst2jqotcNOd-CEq7d8reWDWFeFebQY=
Token URL: https://academy-t-sac.authentication.eu10.hana.ondemand.com/oauth/token

If your SAP Analytics Cloud URL includes US10 (e.g. https://academy-t-sac.us10.hcs.cloud.sap/):
OAuth Client ID: sb-72eb83b7-acdf-484f-97c0-8a4a3a0ba2cf!b65597|client!b655
Secret: 475525ab-c4fa-4ed6-840f-c9c713c92f2f$M1oifsB8eb4UgUi_B3IoGX24RWARZIMjdsNYZ0ZmL0w=
Token URL: https://academy-t-sac.authentication.us10.hana.ondemand.com/oauth/token

If your SAP Analytics Cloud URL includes AP11 (e.g. https://academy-t-sac.ap11.hcs.cloud.sap/):
OAuth Client ID: sb-70e53f44-cd8b-44e3-878a-139a91d1fbaf!b852|client!b23
Secret: 61348c6c-40f6-43dc-a093-feff154e6e3d$YmsWVbmrBNQ4XDlmmOpmyyq1FsV-YkwKChTf90oLGq0=
Token URL: https://academy-t-sac.authentication.ap11.hana.ondemand.com/oauth/token

1. In SAP Data Warehouse Cloud, go to Connections and click 'Create'.
   

2. Choose connection type 'Cloud Data Integration'.
   

3. Under connection details, enter the URL for the Data Export Service. In our case that is either
   https://academy-t-sac.eu10.hcs.cloud.sap/api/v1/dataexport/administration or
   https://academy-t-sac.us10.hcs.cloud.sap/api/v1/dataexport/administration or
   https://academy-t-sac.ap11.hcs.cloud.sap/api/v1/dataexport/administration
   Also, add the OAuth token endpoint URL that you get from the beginning of this page.
   

4. Enter the OAuth Client ID and its secret.
   

5. In the next step, provide a name for the connection (e.g. SAC_DWC_TechEd_DA280) and create it.
   

6. Now, navigate to the Data Builder (you remember that from our first exercises) and create a new Data Flow.
   

7. In the panel on the left hand side, go to sources and open the newly created connection. Navigate to the SAC namespace.
   

8. You receive a list of all available models on the connected SAP Analytics Cloud tenant. Go back to your model in SAP Analytics Cloud and copy the model ID from its URL.
   

9. You can search for the model back in the Data Flow and then drag the fact data on to the canvas.
   

10. The Data Flow must write the data into a table. Add a table.
    

11. Give the table a name and click 'Create and Deploy Table'
    

12. Afterwards, name the Data Flow and Deploy it. Afterwards, click 'Save'.
    
    

13. Now you can run the Data Flow. Once you run it, you can jump to the Data Integration Monitor.
    

14. Refreh the status ocassionaly in the monitor until the Data Flow run is completed after a few moments.
    

15. Go back to the Data Flow, mark the table and toggle the data preview.
    

Congratulations! You have completed all exercises! Thanks so much!

In a real scenario, you could now use this data to feed it into your corporate plan vs. actual reporting, you could use it to feed other planning processes etc.

Please note, that when using a Data Provisioning agent and remote tables, you could also enable delta replication for the extraction of SAP Analytics Cloud data to SAP Data Warehouse Cloud!