{"id":41610,"date":"2022-09-27T08:04:58","date_gmt":"2022-09-27T06:04:58","guid":{"rendered":"http:\/\/54.194.80.134.nip.io\/training-video-enabling-data-exchange-data-warehouse-cloud-and-sap-analytics-cloud\/"},"modified":"2023-11-11T15:25:00","modified_gmt":"2023-11-11T14:25:00","slug":"training-video-enabling-data-exchange-data-warehouse-cloud-and-sap-analytics-cloud","status":"publish","type":"post","link":"https:\/\/www.cubeserv.com\/en\/training-video-enabling-data-exchange-data-warehouse-cloud-and-sap-analytics-cloud\/","title":{"rendered":"Activate data exchange Data Warehouse Cloud and SAP Analytics Cloud"},"content":{"rendered":"\t\t
\n\t\t\t\t\t\t
\n\t\t\t\t\t\t
\n\t\t\t\t\t
\n\t\t\t
\n\t\t\t\t\t\t
\n\t\t\t\t
\n\t\t\t\t\t\t\t\t\t

SAP has created a new option for data exchange between Data Warehouse Cloud<\/a> (DWC) and SAP Analytics Cloud<\/a> (SAC): OData API. This allows you to use another useful SAP function – especially for planning applications.<\/p>\n

OData (Open Data Protocol) is a standardized protocol for data exchange between different systems and is mainly used for cloud data sources. The interface offers a practical integration of DWC and SAC. It is also a way of saving the data recorded in SAC in DWC.<\/p>\n

The following video shows in detail how to activate the interface:<\/p>\n\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t

\n\t\t\t\t\t\t
\n\t\t\t\t\t
\n\t\t\t
\n\t\t\t\t\t\t
\n\t\t\t\t
\n\t\t\t\t\t\t\t
\n\t\t\t\t\t
\n\t\t\t\t\t\t
\n\t\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t
\n\t\t\t\t\t\t
\n\t\t\t\t\t
\n\t\t\t
\n\t\t\t\t\t\t
\n\t\t\t\t
\n\t\t\t\t\t\t\t
\n\t\t\t
<\/div>\n\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t
\n\t\t\t\t\t\t
\n\t\t\t\t\t
\n\t\t\t
\n\t\t\t\t\t\t
\n\t\t\t\t
\n\t\t\t\t\t\t\t\t\t

A few steps to the interface<\/h3>\n
    \n
  1. Look up the redirect URL in SAC<\/strong>
    \nIdentify the redirect URL for the connection to DWC in SAC.<\/li>\n<\/ol>\n
      \n
    1. Create an OAuth client in DWC<\/strong>
      \nCreate a new OAuth client in DWC with the redirect URL.<\/li>\n<\/ol>\n
        \n
      1. Identify OData connection parameters in DWC
        \n<\/strong>Data Service URL
        \nOAuth Client ID
        \nSecret
        \nToken URL
        \nAuthorization URL<\/li>\n<\/ol>\n
          \n
        1. Identify OData source in DWC (Data Service URL)<\/strong>
          \nSearch the available Spaces in DWC with a URL and verify the assets contained therein. Identify the dataset and copy the Asset Relational Data URL required for the SAC OData connection.<\/li>\n<\/ol>\n
            \n
          1. Create OData connection in SAC
            \n<\/strong>Create the OData connection in SAC. Use the DWC connection parameters.<\/li>\n<\/ol>\n

            Once the connection has been successfully created, you can import the data from the OData connection into SAC.<\/p>\n\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t

            \n\t\t\t
            \n\t\t\t\t\t\t
            \n\t\t\t\t
            \n\t\t\t\t\t\t\t\t\t

            Prerequisites<\/h3>\r\nThe following requirements must be met before you can use the interface:\r\n