Creating an SAP BW Reader Connection

1. Click Configure > Connections.
The Connections page appears.
2. Click New.
The New Connection page appears.
3. 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:
_ . + -
4. Enter a description for the connection.
The description can have a maximum length of 255 characters.
5. Select SAP BW Reader as the connection type.
The SAP BW Reader Connection Properties section appears.
6. Select the name of the runtime environment where you want to run the tasks.
7. Enter an SAP user name with the appropriate user authorization.
8. Enter the SAP password.
9. 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.
10. Enter the host name or IP address of the SAP BW server that you want to connect to.
11. Enter the SAP system number.
12. Enter the host name of the SAP message server.
13. Enter the SAP system name.
14. Enter the group name of the SAP BW server.
15. Enter the SAP client number.
16. Enter the language code that corresponds to the language used in the SAP system.
17. 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: <Secure Agent installation directory>\main\tomcat
• - Run-time information: <Secure Agent installation directory>\main\bin\rdtm
18. Enter any additional JCo connection parameters that you want to use.
Use the following format:
<parameter name1>=<value1>, <parameter name2>=<value2>
19. 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.
20. Select the Use HTTPS option to enable https streaming.
1. a. Enter the absolute path to the JKS keystore file.
2. b. Enter the password for the .JKS file.
3. c. Enter the export password for the .P12 file.
21. Click OK to save the connection.
22. Click Test to determine if the connection to the SAP BW system is successful.