Technology Blogs by SAP
Learn how to extend and personalize SAP applications. Follow the SAP technology blog for insights into SAP BTP, ABAP, SAP Analytics Cloud, SAP HANA, and more.
Showing results for 
Search instead for 
Did you mean: 
Product and Topic Expert
Product and Topic Expert
SAP Analytics Cloud (SAC) offers a comprehensive solution to leverage the power of data, with features like Live/Import/Export Data Connections. In this blog, we will explore SAC connection capabilities and how experts from SAP's Center of Expertise (CoE) for Analytics, Planning, and Consolidation provide a professional connection experience.

Importance of Data Source in SAC

SAP Analytics Cloud supports wide types of data integration including on-premise or cloud-based systems, SAP or non-SAP systems. Such as SAP HANA, SAP Datasphere, SharePoint Online, Salesforce, and SQL Database. (There are even more connections you can explore at the end of this blog!)

With Live Data Connections, organizations can connect directly to their data sources in real-time. It enables decision-makers to access the most up-to-date information. In addition, Import Data Connections allow bringing in data from various sources. SAC supports combining data sets from both connection types into a unified view. Lastly, Export Data Connections enable businesses to export and store data in other platforms.

Configure Connections Between Data Sources and SAC

Setting up connections between data sources and SAC might sound a bit technical, but it's not so bad. It's like putting together puzzle pieces. First, CoE experts make sure your data source is compatible. If it is, they set up the right parameters in the data source system. Then, gather all the connection details and establish connections in SAC.

Sometimes, we might install special software like Cloud Connector, Data Provisioning Agent, Java Connector, etc. It depends on the type of connection and where the data comes from. It's a bit like getting the right tools for the job!

Getting data connections right in SAP Analytics Cloud is crucial, but it can be a bit tricky. If things aren't set up properly, it's like a chain reaction of problems – data mistakes, system downtime, and even security issues. It can slow things down, make decisions take longer, and end up costing more to fix.

Unlock Potential with SAP's CoE💡

To tackle any issues you might face with connections, think of the SAP CoE as your friendly team of experts here to help you navigate SAC smoothly. They're like your personal guides, making sure your data connection in SAC is strong and efficient, just the way you need it.

Expertise in Connectivity: SAP's CoE is your go-to team for configuring all types of supported connections for SAC. They've been doing it for years and have the experience to configure connections for clients worldwide.

Troubleshooting Excellence:  If you encounter issues with SAC connection or Single Sign-On (SSO), CoE team is on standby. They're ready to solve problems quickly so your business keeps running smoothly.

Quality Deliverables: Trust is key in business. CoE team makes sure your SAC configurations are leading to dependable and lasting results. What's more, we provide hands-on guidance for setting up connectivity and even give you a personalized configuration document afterward.

We can support but not limited to:

    • Set up Live Connections for SAP and non-SAP data sources

    • Set up Import Connections for SAP and non-SAP data sources

    • Set up Single-Sign-on for SAC and SAP data sources

    • Set up Scheduling Publication for Live Connections

    • Set up SAC Mobile SSO connections

    • Troubleshooting connection issues

    • Troubleshooting SAML SSO issues

    • ....

Success Stories from SAP's CoE Team🏆

A telecommunications company integrated data from SharePoint Online into SAC. Then the outcome was empowering SAC users with more data sources for reporting and data visualizations. This success story shows tangible benefits from the SAP CoE resources. Below is the real feedback:

Here's another story about a company that deals with chemicals and materials. They had a problem with SAML attributes mapping between 3r party IdP and SAC for about a month. But CoE experts figured out the issue in just two days and gave helpful advice on how to avoid the issues. This shows how awesome our team is at solving problems fast and making sure things work smoothly. Here's their feedback:

With SAP's CoE for Analytics, Planning, and Consolidation, you're not just getting technical support; you're getting a friendly and reliable team dedicated to making your SAP Analytics Cloud experience the best it can be.

Supported Data Source in SAC🔗

Live Data Connections
SAP Datasphere, SAP HANA, SAP S/4HANA, SAP BW and SAP BW/4HANA, SAP BPC Embedded, SAP Universes and Web Intelligence Documents, APOS Live Data Gateway

Import Data Connections
SAP BPC System, SAP HANA, SAP S/4HANA, SAP BW or SAP BW/4HANA System, SAP Fieldglass, SAP Universe, SAP SuccessFactors, SAP SuccessFactors Workforce Analytics, SAP Integrated Business Planning, SAP Cloud for Customer, SAP Concur, SAP ERP System, SAP Business ByDesign Analytics, Google BigQuery System, Google Drive, OData Services, Salesforce, Qualtrics, SQL Database (also including Azure Synpase and etc.), SAP Integration Suite Open Connectors

Exporting Data

Exporting a Model to a File, Exporting data to SAP BPC / OData Services (BW & BW/4HANA) / SAP S/4HANA / SAP Integrated Business Planning / Data Export API


Explore More What else CoE team Supports

  1. SAC, S/4 Embedded Analytics, Business Objects and Planning

  2. SAP Premium Engagement: Analytics Strategy Workshop

  3. Volume Test Optimization Service for SAP Analytics Cloud

  4. Go-Live Support Service for SAP Analytics Cloud

  5. SAP Analytics Cloud: Re-platforming from Lumira

  6. SAP Analytics Cloud: The Power of UX and Accessibility

  7. More topics are upcoming...