IBM Cloud Pak for Data
Access Db2 from IBM Cloud Pak 4 Data
Section titled “Access Db2 from IBM Cloud Pak 4 Data”Go to the project page, and click the Assets tab
Section titled “Go to the project page, and click the Assets tab”Click New asset > Data access tools > Connection
Section titled “Click New asset > Data access tools > Connection”Select the IBM Db2 for i connector
Section titled “Select the IBM Db2 for i connector”Upload JDBC driver files
Section titled “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
Section titled “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 Driver | Port Non-SSL | Port SSL |
|---|---|---|
| JCC driver | 446 | 448 |
| JT400 driver | 8471 | 9471 |
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
Section titled “Verify the connection”Click Test connection to verify if the connection can be created successfully
Create the connection
Section titled “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
Section titled “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.
-
Select an existing connection asset or create a new one as the source of the data.
-
Select the data you want. You can select multiple connected data assets from the same connection. Click Import.