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 (). |
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 (). |
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 (). |
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.