2358097 - SAP Analytics Cloud connecting to on-premise data *** Master KBA ***

SAP Knowledge Base Article - Public

2358097 - SAP Analytics Cloud connecting to on-premise data *** Master KBA ***

Symptom

  • You are using SAP Analytics Cloud and want to connect to data stored in your own network: SAP Business Warehouse (BW), Universes, SQL Server databases etc.
  • You are getting error messages when connecting to datasources such as MySQL database or BPC.
  • You are trying to connect to a file stored in a file server.
  • How to import data from local data sources to your SAP Analytics Cloud tenant?

Environment

SAP Analytics Cloud

Local data sources: BW, ERP, SQL Server, OData etc.

Cause

SAP Analytics Cloud requires the SAP Analytics Cloud Agent installed in your network to access resources / servers located in your network.

Resolution

General

The steps indicated in this article are related to importing data into SAP Analytics Cloud. For Live connections, please refer to the article 2589761 and the product documentation: Live Data Connection.

To install the SAP Analytics Cloud Agent, follow these steps:

  1. Installation and configuration of the SAP Cloud Platform Cloud Connector.
  2. Deploying the SAP Analytics Cloud Agent.
  3. If you are planning to connect to SAP BW and ERP systems, deploy the SAP JCO connectors.
  4. Configure Access Control in the SAP Cloud Platform Cloud Connector.
  5. Configure the SAP Analytics Cloud Agent in your SAP Analytics Cloud tenant.

For the most up-to-date documentation, see your specific Connections on the product's documentation.

For step-by-step instructions to perform each of the above requirements read this Blog in the SAP Analytics Cloud Community:

*NEW* You can also find step-by-step guides on different data sources at: ***

https://www.sapanalytics.cloud/resources/data-connections

Troubleshooting

If you experience problems, follow this guide to troubleshoot each of the different elements required:

Additional Information

Below are additional articles, guides and known issues for each component to install.

SAP Analytics Cloud Tenant

  • 2288285 - What data sources are supported with SAP BusinessObjects Cloud?
  • 2353843 - Cannot refresh on premise data in SAP BusinessObjects Cloud after tenant updated

SAP Analytics Cloud Agent

  • 2531819 - Troubleshooting errors importing SAP Universe (UNX) in SAP Analytics Cloud
  • 2319141 - FWM 20030 when importing data from a Universe into SAP Analytics Cloud
  • 2322466 - Error HTTP Status 500 when testing the installation of the SAP Analytics Cloud Agent
  • 2361117 - SAP Analytics Cloud gives "Failed to call SAP Analytics Cloud agent"
  • 2367385 - SAP Analytics Cloud Agent logs show "Connect to SAP gateway failed"

SAP HANA Cloud Connector (SCC / HCC)

SAP Operations Configuration Required

  • 2397165 - How do I configure SAP HANA Cloud Connector (HCC) and Agent with SAP Analytics Cloud?
  • 2328435 - SERVER_ERROR_500 /deploymentInfo error message appears in BusinessObjects Cloud when creating Import Data Connection
  • 2330862 - SERVER_ERROR_500 "Failed to call remote system on /service/api/epm/proxy..." while creating new Import Data Connection in BusinessObjects Cloud
  • 2354809 - SAP BusinessObjects Cloud gives "Failed to call SAP BusinessObjects Cloud agent"
  • 2417769 - You can't find the SAP ANALYTICS CLOUD AGENT (C4A_AGENT.war) in the download area of SAP Support Portal

See Also

Your feedback is important to help us improve our knowledge base.
Please rate how useful you found this article by using the star rating feature at the beginning of this article.
Thank you.

Keywords

acquire, acquisition, import, importing, datasource, onpremise, sql, unx, EPM-ODS, Cloud for Analytics, C4P, Cloud 4 Planning, HCP, C4A, BOC, SAP BusinessObjects Cloud, bobj , SAP Analytics Cloud, SCC, HCC, SAC, SAP CP CC, SCPCC , KBA , epm, sap cloud for planning, sc4p, c4p, , c4a_agent , onpremise , boc agent , businessobjects cloud , cloud agent , acquire , import , odestdata is undefined , LOD-ANA , SAP Analytics Cloud , LOD-ANA-BI , SAP Analytics Cloud - Business Intelligence (BOC) , LOD-ANA-BR , SAP Analytics Cloud - Digital Boardroom , LOD-ANA-PL , SAP Analytics Cloud – Planning (BOC) , LOD-ANA-PR , SAP Analytics Cloud – Predictive (BOC) , Problem

Product

SAP Analytics Cloud 1.0