Skip to content
A comprehensive guide to using AI with IBM i

IBM Cloud Pak for Data

Access Db2 from IBM Cloud Pak 4 Data

Go to the project page, and click the Assets tab

image

Click New asset > Data access tools > Connection

image

Select the IBM Db2 for i connector

image

Upload JDBC driver files

JDBC driver files are required to create a connection using the IBM Db2 for i connector and there are two options: IBM JCC driver and JT400 driver. The JT400 driver is preferred because it does not require an additional license like the JCC driver does. For more information, see Db2 for i connection.
Not all the users have the permission to do this step. Ask the admin to upload the jar files following the instructions in this link: Upload JDBC driver files.

Enter the connection information

Typically, you need to provide information like the hostname, port number, username, and password. Below is port number information based on the JDBC driver and SSL/TLS configuration.

JDBC DriverPort Non-SSLPort SSL
JCC driver446448
JT400 driver84719471
image image image

If the certificate used in SSL/TLS configuration is not signed by a publicly trusted CA, then you need to paste the content of the CA certificate in the SSL certificate text box.

Verify the connection

Click Test connection to verify if the connection can be created successfully

Create the connection

Click Create. The connection appears on the Assets page. You can edit the connection by clicking the connection name on the Assets page.

Add data assets from the connection

A connected data asset is a pointer to data that is accessed through a connection to an external data source. You create a connected data asset by specifying a connection, any intermediate structures or paths, and a relational table or view, a set of partitioned data files, or a file. When you access a connected data asset, the data is dynamically retrieved from the data source. See Add data assets from the connection.

To add a data asset from a connection to a project:

  • From the project page, click the Assets tab, and then click Import assets > Connected data. image

  • Select an existing connection asset or create a new one as the source of the data. image

  • Select the data you want. You can select multiple connected data assets from the same connection. Click Import. image