DB2 connection configuration
When you connect to DB2 directly, select Local DB as the location, select DB2 as the data type, and configure the detailed settings.
|1||User ID||Use ID for the DB2 account.|
|2||Password||Password for the DB2 account.|
|3||Connection Type||Select Basic|
|7||Default Schema||If Default Schema is specified, the tables and views of the specified schema will be listed during mapping.
If blank, all accessible tables and views will be listed.
DB2 Connection String
SDI uses IBM.Data.DB.Provider to connect to DB2.
You can connect to DB2 by using DB2 Connection String directly.
|1||Connetion Type||Select DB2 Connection String|
|2||DB2 Connection String||Enter the details of the DB2 Connection String.
* Do not enter user and password information in the Connection String.