Hi, I'm Ask INFA!
What would you like to know?
ASK INFAPreview
Please to access Bolo.
Communities
A collaborative platform to connect and grow with like-minded Informaticans across the globe
Product Communities
Connect and collaborate with Informatica experts and champions
Discussions
Have a question? Start a Discussion and get immediate answers you are looking for
User Groups
Customer-organized groups that meet online and in-person. Join today to network, share ideas, and get tips on how to get the most out of Informatica
Get Started
Community Guidelines
Knowledge Center
Troubleshooting documents, product guides, how to videos, best practices, and more
Knowledge Base
One-stop self-service portal for solutions, FAQs, Whitepapers, How Tos, Videos, and more
Support TV
Video channel for step-by-step instructions to use our products, best practices, troubleshooting tips, and much more
Documentation
Information library of the latest product documents
Velocity (Best Practices)
Best practices and use cases from the Implementation team
Learn
Rich resources to help you leverage full capabilities of our products
Trainings
Role-based training programs for the best ROI
Certifications
Get certified on Informatica products. Free, Foundation, or Professional
Product Learning Paths
Free and unlimited modules based on your expertise level and journey
Resources
Library of content to help you leverage the best of Informatica products
Tech Tuesdays Webinars
Most popular webinars on product architecture, best practices, and more
Product Availability Matrix
Product Availability Matrix statements of Informatica products
SupportFlash
Monthly support newsletter
Support Documents
Informatica Support Guide and Statements, Quick Start Guides, and Cloud Product Description Schedule
Product Lifecycle
End of Life statements of Informatica products
Ideas
Events
Change Request Tracking
Marketplace
English
  • Administrator
  • All Products

Table of Contents

Search

  1. Connectors and connections
  2. Connection configuration
  3. Connection properties
  4. Swagger file generation for REST V2 connections

Connections

Connections

Back Next

SAP BW Reader connection properties

SAP BW Reader connection properties

To read data from SAP BW objects, select the
SAP BW Connector
 connection type and configure the connection properties.
The following table describes the SAP BW connection properties:
Property
Description
Connection Name
Name of the connection.
Description
Description of the connection.
Type
Type of connection.
Runtime Environment
Required. Runtime environment that contains the Secure Agent that you want to use to read data from SAP BW objects.
Username
Required. SAP user name with the appropriate user authorization.
Password
Required. SAP password.
Connection type
Required. Type of connection that you want to create.
Select one of the following values:
  • Application. Create an application connection when you want to connect to a specific SAP BW server.
  • Load balancing. Create a load balancing connection when you want to use SAP load balancing.
Default is Application.
Host name
Required when you create an SAP application connection.
Host name or IP address of the SAP BW server that you want to connect to.
System number
Required when you create an SAP application connection.
SAP system number.
Message host name
Required when you create an SAP load balancing connection.
Host name of the SAP message server.
R3 name/SysID
Required when you create an SAP load balancing connection.
SAP system name.
Group
Required when you create an SAP load balancing connection.
Group name of the SAP application server.
Client
Required. SAP client number.
Language
Language code that corresponds to the language used in the SAP system.
Trace
Use this option to track the JCo calls that the SAP system makes.
Specify 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
Additional parameters
Additional JCo connection parameters that you want to use.
Use the following format:
<parameter name1>=<value1>, <parameter name2>=<value2>
Port Range
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.
Default is 10000-65535.
Use HTTPS
Select this option to enable https streaming.
Keystore location
Absolute path to the JKS keystore file.
Keystore password
Password for the .JKS file.
Private key password
Export password specified for the .P12 file.
SAP Additional Parameters
Additional SAP parameters that the Secure Agent uses to connect to the SAP system as an RFC client.
Specify the required RFC-specific parameters and connection information to enable communication between
Data Integration
 and SAP.
You can specify the Secure Network Communication (SNC) parameters as additional arguments to securely connect to SAP as shown in the following format: 

MSHOST= <Message server hostname>
GROUP=PUBLIC
R3NAME=SLT
SNC_MODE=1
SNC_QOP=3
SNC_MYNAME=p:CN=<Common name>, OU=<Organizational unit>, O=<Organization>, C=<Country> This is the SNC name of the Secure Agent machine.
SNC_PARTNERNAME=p:CN=<Common name>, OU=<Organizational unit>, OU=SAP Web AS, O=<Organization>, C=<Country>. This is the SNC name of the SAP system.
SNC_LIB =<Secure Agent installation directory>/apps/Data_Integration_Server/ext/deploy_to_main/bin/<libsapcrypto.so for Linux/sapcrypto.dll for Windows>
X509CERT=<X509 certificate>
For more information about the SNC parameters that you can configure in this field, see the How-To Library article, How to Configure the SAP Secure Network Communication Protocol in Informatica Cloud Data Integration.
The values of any required connection parameters override SAP additional parameter values that you have entered.
0 COMMENTS
We’d like to hear from you!