IBM DB2
The information on this page relates to the new upgraded interface of the IConduct platform. To view information about the Classic version of the user interface, follow this link.
IBM DB2 is a Relational DataBase Management System (RDBMS) introduced by IBM. It delivers advanced data management and analytics capabilities for your transactional and warehousing workloads. DB2 is supported across Linux, Unix and Windows operating systems.
The IBM DB2 connector by IConduct enables the user to seamlessly manage the data in an integrated data flow across IBM DB2 and company’s business applications. The connection is empowered by Open Database Connectivity (ODBC). This standard application programming interface (API) allows for accessing database management systems (DBMS) using SQL as a standard for accessing the data.
To configure the IBM DB2 connector, follow the instructions below:
- In the Main Menu, select Connections and press Create connection.
Accessing connections
- Scroll down to the Database Servers section and select the IBM DB2 item from the list.
Connector Selection Page
- In the ODBC Provider work area, fill in the following fields and pressCreate.
Connection Details Area
| Fields | Description |
|---|---|
|
Connection* |
A new connection name. Enter a connection alias here. |
|
Is Active |
Toggles connector’s activity at interface execution. Enable the checkbox to activate the connection for execution. |
|
Cloud Agent |
The LAN you are working with. Select "IConduct" for cloud systems and your corporate agent for internal systems. |
|
Implementation Type* |
Defines the implementation type. Select from the drop-down list:
|
|
Is Source |
This connection entity is available as a data source for Import (writing to Schema). Enable the checkbox to ensure data import. |
|
Is Target |
This connection entity is available as a data target that receives data from schema to current data container. Enable the checkbox to ensure data export. |
|
Timeout |
The length of time (in milliseconds) the IConduct platform waits for a response from the connection provider before returning a timeout error. Set the time value to stop the system from connection attempts. |
|
Query |
The box is intended for entering a query. You can test the defined query by clicking Test Query once the connection is saved. It’s recommended to test the query after the connection testing. |
|
DateTime Format |
Allows defining the date and time formats appropriate for the connection. Recommended Format: yyyy-MM-dd HH:mm:ss |
|
Connection String* |
A string that specifies information about a data source and the means of connecting to it. Refer to this page for more information about the IBM DB2 connection strings. General ODBC connection string example: DSN=myDsn;Uid=myUsername;Pwd=; See the IBM DB 2 connection string explanation in the table below. |
|
Username |
The username used for impersonation. |
|
Password |
The password to username used for impersonation. |
|
Domain |
Not used in this connector. |
* - mandatory fields
IB DB2 connection string breakdown example:
Driver=$HOME/db2_cli_odbc_driver1/lib/libdb2.a;Database=myDataBase;Hostname=myServerAddress;
Port=1234;Protocol=TCPIP;Uid=myUsername;Pwd=myPassword;
| Fields | Description |
|---|---|
|
Driver |
The full name of the installed IBM DB2 ODBC driver. Driver=$HOME/db2_cli_odbc_driver1/lib/libdb2.a |
|
Databse |
The database alias (for a cataloged database). The maximum size of the Database keyword is 255 bytes. Database=myDataBase |
|
Hostname |
The server name with an optional port number for a direct connection. Use either the IPv4 notation (server name|ip address[:port]) or the IPv6 notation. Hostname=myServerAddress |
|
Port |
The port number specified when launching the cluster. If you have a firewall, ensure that this port is open for use. Port=1234 |
|
Protocol |
The communication protocol used between the CreateConnection() and the database server. Protocol=TCPIP |
|
UID |
The login account. Required, unless the client machine is trusted by the host machine. Uid=myUsername |
|
PWD |
The password associated with the User ID. Required if the client machine or user account is not trusted by the host. Prohibited unless a User ID is given. Pwd=myPassword |
Once the connection is saved, you can test if it is successful. Press Test Connection. If the created connection works, you will receive a success message.
Testing the Connection