Import Data Connection

You can create connections to data source systems to allow data acquisition by SAP Analytics Cloud. Data is imported (copied) to SAP Analytics Cloud, and changes made to the data in the source system don't affect the imported data.

Setup is required when creating an import data connection to the following system types:

  • SAP Business Planning and Consolidation (BPC) (available only with a planning license)
  • SAP Business ByDesign Analytics
  • SAP Business Warehouse (BW)
  • SAP Cloud for Customer
  • SAP Cloud for Customer Analytics
  • SAP Concur
  • SAP Enterprise Resource Planning (ERP)
  • SAP Fieldglass
  • SAP SuccessFactors
  • SAP SuccessFactors Workforce Analytics
  • SAP Universe
  • SAP Integrated Business Planning (IBP)
  • SAP Cloud Platform Open Connectors
  • Google Drive
  • Google BigQuery
  • OData Services
  • Salesforce
  • Dow Jones
  • SQL
  • Qualtrics
  • File Server
You can also import data from your local file system, but no connection setup is required.
For an overview of connection types and guidelines for system administrators, see the SAP Analytics Cloud Connection Guide.
Workflow Overview
You must first install servers and components required by your connections using one of the following options:
Some connection types do not require the installation or configuration of the cloud connector or the SAP Analytics Cloud agent. Check the connection prerequisites to see which components are required.
  1. Using the SAP Analytics Cloud Agent Simple Deployment Kit: Choose this option if you want to get started with basic import data connections quickly. The deployment kit does not provide full customization options.

    For more information, see SAP Analytics Cloud Agent Simple Deployment Kit.

  2. Performing a manual install of all required components: Choose this option if you already have an existing Tomcat server installation you want to use, have an existing SAPCP Cloud Connector set up, or you want full customization options.

    1. Install the SAPCP Cloud Connector. For more information, see Installing the SAPCP Cloud Connector.
    2. Install the SAP Analytics Cloud agent. For more information, see Configuring SAP Analytics Cloud Agent.
    3. For SAP BW and SAP ERP: Install the SAP Java Cloud Connector (JCo). For more information, see Installing the SAP Java Connector (JCo).
    4. Configure the SAPCP cloud connector. For more information, see Configuring the SAPCP Cloud Connector
    5. Configure the SAP Analytics Cloud agent. For more information, see Configuring SAP Analytics Cloud Agent

It is recommended that the SAPCP cloud connector, SAP Analytics Cloud agent, and the SAP Java Connector (JCo) are installed together on a dedicated server, and not a personal computer. This helps to ensure that multiple users can use an import data connection without experiencing slowness or downtime.

Other deployment considerations:
  1. For SAP Analytics Cloud to connect to on-premise backend systems using the cloud connector, it is not necessary to create inbound holes in your firewalls. The cloud connector doesn't need to be deployed in your DMZ.
  2. Placing the cloud connector and agent in the DMZ may cause connectivity issues, because there are network filters on the DMZ’s inner firewall.
  3. The cloud connector and agent should be deployed in a network segment that allows outgoing connections to the Internet, and direct (unblocked) connections to on-premise backend systems. Such a network segment may exist in your corporate network instead of the DMZ.
  4. If you choose to deploy the cloud connector and agent on separate servers, connections from the cloud connector to the agent's Tomcat port must be allowed.

Once you have set up the required components, you must configure each connection type in SAP Analytics Cloud: