Connection properties for private endpoints

To connect your integrations to on-premises endpoints, provide connection details for the required endpoint.

IBM MQ Client Connection

Table 1. Connection details for an IBM MQ endpoint
Property Description
MQ policy name The name of the MQEndpoint policy that is used to specify properties for the IBM® MQ nodes in your message flows. Enter the name of the policy only; do not enter the full URL of the policy. For example, if the node uses a policy with a URL of /apiv1/policy/MQEndpoint/QM1, enter the policy name QM1. For more information, see MQEndpoint policy in the IBM Integration Bus product documentation.
Host The host name of the server where the IBM MQ queue manager is running (for example: test.eu.acme.com).
Port The port number on which the IBM MQ listener is listening (for example: 1414).
Queue manager The name of the IBM MQ queue manager to which you want to connect.
Channel name The name of the SVRCONN channel that is used by the queue manager to receive messages (for example: SERVER.DEF.SVRCONN).
User name The user name that is used to connect to IBM MQ, if required. This property is optional, and is used in IBM MQ version 8 and later.
Password The password that is used to connect to IBM MQ, if required. To view the password, click Show password (Show password icon).
For more information, see Configuring connections to WebSphere® MQ in the IBM Integration Bus product documentation.

DB2® ODBC

Table 2. Connection details for a DB2 ODBC endpoint
Property Description
Data source name (DSN) The ODBC data source name of the database that contains the tables to which you refer in the database, Compute, or Filter nodes in your integrations.
Host The host name of the server where DB2 is running (for example: test.eu.acme.com).
Port The port number on which DB2 is listening (for example: 50000, which is the default port number for DB2).
Database name The name of the database to which you want to connect.
User name The user name that is required to log on to DB2.
Password The password that is required to log on to DB2. To view the password, click Show password (Show password icon).
For more information, see Enabling ODBC connections to the databases in the IBM Integration Bus product documentation.

SQL Server ODBC

Table 3. Connection details for a Microsoft SQL Server ODBC endpoint
Property Description
Data source name (DSN) The ODBC data source name of the database that contains the tables to which you refer in the database, Compute, or Filter nodes in your integrations.
Host The host name of the server where Microsoft SQL Server is running (for example: test.eu.acme.com).
Port The port number on which Microsoft SQL Server is listening (for example: 1433).
Database name The name of the database to which you want to connect.
User name The user name that is required to log on to Microsoft SQL Server.
Password The password that is required to log on to Microsoft SQL Server. To view the password, click Show password (Show password icon).
Domain The domain name, if you are using NTLM authentication. This property is optional. You must specify the domain name if you want to use NTLM authentication. If you leave this property blank, SQL Server authentication is used.
For more information, see Enabling ODBC connections to the databases in the IBM Integration Bus product documentation.

cl00034_.htm | Last updated 2018-12-15 07:47:01