To access your data in IBM Db2 Warehouse, create a connection asset for it.
IBM Db2 Warehouse is an analytics data warehouse that gives you a high level of control over your data and applications. You can use the IBM Db2 Warehouse connection to connect to a database in these products:
IBM Db2 Warehouse in IBM Cloud
IBM Db2 Warehouse on-prem
Create a connection to Db2 Warehouse
Copy link to section
If you have set up an integrated cloud service, select the service instance to automatically fill in the fields in the connection form. Confirm that all the fields are complete.
To create the connection asset, you need these connection details:
SSL certificate (if required by the database server)
Credentials
Copy link to section
If you select Shared, enter either an API key or a username and password. for the server.
If you select Personal, you have two choices:
Enter your username and password for the server.
Select platform login credentials. You can use this option only if the Db2 service is hosted on the instance of Cloud Pak for Data that you are connecting to.
Authenticating with an API Key
Copy link to section
You can use an API key to authenticate to Db2 Warehouse in IBM Cloud.
Db2 Warehouse in IBM Cloud First add the user ID as an IAM user or as a service ID. For instructions, see the Console user experience section of the Identity and access management (IAM) on IBM Cloud topic.
If users want to authenticate with Db2 Warehouse with an IAM API key, the administrator of the Db2 Warehouse instance can add the IAM users by using the User management console, and then the users can each create an API key for themselves
by using the IAM access management console.
For Private connectivity, to connect to a database that is not externalized to the internet (for example, behind a firewall), you must set up a secure connection.
Choose the method for creating a connection based on where you are in the platform
You can use Db2 Warehouse connections in the following workspaces and tools:
Projects
Data Refinery
Decision Optimization
Notebooks. Click Read data on the Code snippets pane to get the connection credentials and load the data into a data structure. See Load data from data source connections.
About cookies on this siteOur websites require some cookies to function properly (required). In addition, other cookies may be used with your consent to analyze site usage, improve the user experience and for advertising.For more information, please review your cookie preferences options. By visiting our website, you agree to our processing of information as described in IBM’sprivacy statement. To provide a smooth navigation, your cookie preferences will be shared across the IBM web domains listed here.