Configuring a Web Services Transformation in Informatica Cloud Data Integration to Read Data from an SAP BW BEx Query

Back Next

Step 1. Configure an SAP BEx Query Connection

Create an SAP BW BEx Query connection to connect to SAP BW BEx Query. You can create the connection from the

Connections

page.

Click

Administrator

Connections

, and then click

New Connection

to create a connection.

The

New Connection

page appears.

Enter a name for the SAP BW BEx Query connection.

Connection names are not case sensitive. Connection names can contain alphanumeric characters, spaces, and the following special characters:

_ . + -

Enter a description for the connection.

The description can have a maximum length of 255 characters.

Select

SAP BW BEx Query

as the connection type.

The

SAP BW BEx Query Connection Properties

section appears.

Select the name of the runtime environment where you want to run the tasks.

Select

SAP

as the authentication method.

Enter an SAP user name with the appropriate user authorization.

Enter the SAP password.

Select the

Application

connection type to read data from SAP BEx queries.

Enter the host name or IP address of the SAP BW server that you want to connect to.

Enter the SAP system number.

Enter the SAP client number.

Enter the language code that corresponds to the language used in the SAP system.

The following image shows the configured SAP BW BEx Query connection:

Click

Test Connection

to test the connection.

Click

Save

to save the connection.

Configuring a Web Services Transformation in Informatica Cloud Data Integration to Read Data from an SAP BW BEx Query

Rename Saved Search

Table of Contents

Configuring a Web Services Transformation in Informatica Cloud Data Integration to Read Data from an SAP BW BEx Query

Configuring a Web Services Transformation in Informatica Cloud Data Integration to Read Data from an SAP BW BEx Query

Step 1. Configure an SAP BEx Query Connection

Step 1. Configure an SAP BEx Query Connection