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:
Note

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

Procedure

  1. From the side navigation, choose Start of the navigation path Connections Next navigation step  (Add Connection)End of the navigation path.
    The Select a data source dialog will appear.
  2. Expand Acquired Data and select SAP ERP.
  3. Under Connection Details, select the Location of your Cloud Connector from the list.
  4. 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.
  5. Enter your SAP ERP system information, and log on credentials.
  6. Choose Create.
    The new connection is added to the list of connections on the Connections screen.
  7. If you want to create a model based on this connection, see Import Data to Your Model.