Table of Contents

Search

  1. Preface
  2. Part 1: Introduction to SAP Connector
  3. Part 2: SAP Connector administration
  4. Part 3: Connections
  5. Part 4: Data integration using BAPI/RFC functions
  6. Part 5: Data integration using IDocs
  7. Part 6: SAP BW data extraction
  8. Part 7: Data integration for SAP ADSO
  9. Appendix A: SAP data type reference

SAP Connector

SAP Connector

Creating an SAP BW Reader connection

Creating an SAP BW Reader connection

  1. Click
    Administrator
    Connections
    , and then click
    New Connection
    to create a connection.
    The
    New Connection
    page appears.
  2. Enter a name for the SAP BW Reader connection.
    Connection names are not case sensitive. Connection names can contain alphanumeric characters, spaces, and the following special characters:
    _ . + -
  3. Enter a description for the connection.
    The description can have a maximum length of 255 characters.
  4. Select
    SAP BW Connector
    as the connection type.
    The
    SAP BW Connector Connection Properties
    section appears.
  5. Select the name of the runtime environment where you want to run the tasks.
  6. Enter an SAP user name with the appropriate user authorization.
  7. Enter the SAP password.
  8. Select one of the following connection types:
    • Application. Create an application connection if you want to connect to a specific SAP BW server.
    • Load balancing. Create a load balancing connection if you want SAP to connect to the BW server with the least load at run time.
  9. Enter the host name or IP address of the SAP BW server that you want to connect to.
  10. Enter the SAP system number.
  11. Enter the host name of the SAP message server.
  12. Enter the SAP system name.
  13. Enter the group name of the SAP BW server.
  14. Enter the SAP client number.
  15. Enter the language code that corresponds to the language used in the SAP system.
  16. Enable the trace option to track the JCo calls that the SAP system makes.
    You can enter one of the following values:
    • 0. Off
    • 1. Full
    Default is 0.
    SAP stores information about the JCo calls in a trace file.
    You can access the trace files from the following directories:
    • Design-time information:
      <Informatica Secure Agent installation directory>\apps\Data_Integration_Server\<Latest version>\ICS\main\tomcat
    • Run-time information:
      <Informatica Secure Agent installation directory>\apps\Data_Integration_Server\<Latest version>\ICS\main\bin\rdtm
  17. Enter any SAP additional connection parameters that you want to use.
  18. Enter the HTTP port range that the Secure Agent must use to read data from the SAP BW server in streaming mode.
    Enter the minimum and maximum port numbers with a hyphen as the separator. The minimum and maximum port number can range between 10000 and 65535. When a range is outside the default range, the connection uses the default range. Ensure that you specify valid numbers to prevent connection errors.
    Default is 10000-65535.
  19. Select the
    Use HTTPS
    option to enable https streaming.
    1. Enter the absolute path to the JKS keystore file.
    2. Enter the password for the .JKS file.
    3. Enter the export password for the .P12 file.
  20. Click
    Test Connection
    to determine if the connection to the SAP BW system is successful.
  21. Click
    Save
    to save the connection.

0 COMMENTS

We’d like to hear from you!