Feature Availability: This feature is available in Cloud Dataprep Premium by TRIFACTA® INC.
You can create connections to one or more DB2 databases from Cloud Dataprep by TRIFACTA® INC..
NOTE: Only connections to DB2 for Windows and Unix/Linux are supported.
To create this connection:
- In the Import Data page, click the Plus sign. Then, select the Relational tab. Click the DB2 card.
- You can also create connections through the Connections page. See Connections Page.
Modify the following properties as needed:
|Port||Set this value to |
|Connect String Options|
Please insert any connection options as a string here.
|Database Name||Enter the name of the DB2 database to which to connect.|
|User Name||(basic credential type only) Username to use to connect to the database.|
|Password||(basic credential type only) Password associated with the above username.|
|Test Connection||After you have defined the connection credentials type, credentials, and connection string, you can validate those credentials.|
|Default Column Data Type Inference|
|Connection Name||Display name of the connection|
|Connection Description||Description of the connection, which appears in the application.|
For more information, see Database Browser.
For more information on how values are converted during input and output with this database, see DB2 Data Type Conversions.