Import Data Connection to an SAP ERP System

You can create a connection that allows you to import data from an SAP ERP system.

Prerequisites

You use a supported version of SAP ERP Central Component. For information on supported versions, see System Requirements and Technical Prerequisites.

If you are connecting to a Message Server, the SAP GUI must be installed.

You have completed ONE of the following setup options:

Performed setup using the SAP Analytics Cloud Agent Simple Deployment Kit. For more information, see SAP Analytics Cloud Agent Simple Deployment Kit.
Note
The SAP Java Connector (JCo) must be installed using the instructions in the Post-Setup Guide included in the kit.
Performed a manual setup of the following required components:
1. The cloud connector is installed. For more information, see Installing the SAPCP Cloud Connector.
2. The SAP Analytics Cloud agent is installed. For more information, see Installing SAP Analytics Cloud Agent.
3. The SAP JCo is installed. For more information, seeInstalling the SAP Java Connector (JCo).
4. The cloud connector is configured. For more information, see Configuring the SAPCP Cloud Connector.
5. The SAP Analytics Cloud agent is configured in SAP Analytics Cloud. For more information, see Configuring SAP Analytics Cloud Agent.

Note

Only connectivity to classic SAP InfoSet queries or SAP Queries is supported.

Procedure

Go to (Main Menu) Connection Connections (Add Connection).
The Select a data source dialog will appear.
Expand Acquired Data and select SAP ERP.
Under Connection Details, select the Location of your cloud connector from the list.
Select the Server Type.
If you're connecting to a Message Server, the “services” file on the computer where your SAP Analytics Cloud agent is deployed may need to be configured. The machine that runs Tomcat must have SAP GUI installed and corresponding connection entries must be created in SAP GUI. Have your IT department perform the following steps:
1. Contact your SAP BASIS Administrator for the port number of the Message Server you are connecting to. If you are the SAP BASIS Administrator, you can find the Message Server name and port number by logging into the SAP system, and using transaction SMMS. In the Message Server Monitor, the Message Servers and their port numbers are shown. For example: Message (3601).
2. Edit the “services” file, located in the following directory:
  C:\Windows\system32\drivers\etc\services
3. Add this Message Server entry:
  sapms<SID> <Port Number>/tcp #SAP System Message Server Port
  
  For example, if the SAP Message Server <SID> is R79, and the port number is 3601, the entry to add to the services file is:
  
  sapmsR79 3601/tcp #SAP System Message Server Port
  
  If the Message Server entry has already been added, confirm that the port number is correct.
4. Save the file.
Enter your SAP ERP system information, and log on credentials.
Choose Create.
The new connection is added to the list of connections on the Connections screen.
If you want to create a model based on this connection, see Importing SAP ERP Data to a New or Existing Model.