How to load data from Azure Synapse SQL DW to SAP Analytics Cloud Planning
SAP Analytics Cloud planning with its xP&A concept is becoming more popular and gain high market interest as xP&A is becoming a crucial part of a finance transformation and a modern finance platform. In a multi-vendor system landscape, it is quite common that the Financial data warehouses will come from other software vendors than SAP, for example Azure and Azure Synapse.
Can Azure Synapse be a source to SAP Analytics Cloud Planning?
How easy is it to integrate and load reference data from Azure Synapse to SAP Analytics Cloud to be used as starting point in planning?
This blog will guide you how you connect to SAP Analytics Cloud and load data for planning.
How is this done?
A prerequisite is that SAP Analytics Cloud has a SAC agent configured. This agent must have MS SQL server drivers installed. For information on how to install and configure SAP Analytics Cloud agent, please see official help.sap.com
Once those prerequisites are met it is quite straight forward to connect Azure Synapse SQL DW to SAP Analytics Cloud.
First step is to create a connection. This is done in the section for Connection in the menu.
You can use any of the other MS SQL server drivers. In this example I am using MS SQL server 2008.
Once the connection is established you are good to go. Below, I will take through step by step on how to load data from an Azure Synapse SQL DW.
Loading data from Azure Synapse SQL DW is like loading from any other source. For is one example where I create a planning model from a Azure Synapse SQL DW source:
Step 1: Go to modeler in the menu. Choose model from data source
Step 2: SQL databases
Step 3: Choose connection
Step 4: Build an import query by choosing a table or a view from Azure Synapse SQL DW
Rest of the steps are standard create model steps and are not covered by this blog.
Why it this important?
As many SAP customers have multi-vendor system landscape, this integration flow will become more and more common, hence the ability to load from Azure components and Azure Synapse is essential. SAP official documentation does not include Azure Synapse SQL DW as source, but the blog shows that it is fully supported and easy to configure.
Summary & Conclusion
SAP Analytics Cloud is an open platform for BI, analytics, planning and predictive. As customer move towards a multi-vendor system landscape, connectivity to other sources than SAP is crucial.
This blog is an examples on how open and agile SAP Analytics Cloud is and how easy it is to set up a connection to Azure Synapse SQL DW and load into SAP Analytics Cloud.
Yes, SAP Analytics Cloud can load data from Azure Synapse SQL DW and it is easy to make it work.