Connecting to data sources
Connecting to data sources at the platform level
You can create connections that can be used by various services across the platform. Any user who has access to the platform can see these connections. However, only users with the credentials for the data source can use a connection.
These platform-level connections are available from the Platform connections page. However, this page is available only if the Cloud Pak for Data common core services are installed.
- Cognos® Analytics
- Data Virtualization
- Watson™ Knowledge Catalog
- Watson Studio
Many of the tools that work with Watson Studio can use data from these connections after the connection is added to a project.
The Platform connections page is a specialized view of the Platform assets catalog. (The connections that are defined on the Platform connections page are also included in the Platform assets catalog.)
The Platform connections page shows the list of connections that can be used by various services on the platform. At a minimum, all users have the Viewer role on the catalog, which means that they can see the connections that are defined. For details, see Managing collaborators on platform connections.
- Required permissions
- To create a platform-level connection, you must be an Editor or Administrator on the Platform connections catalog.
Watch this video to see how to create a platform-level connection:
To create a platform-level connection:
- Log in to the Cloud Pak for Data web client.
- From the navigation menu, select .
- Click New connection.
- Select the type of data source that you want to connect to.
If you want to connect to an unsupported data source by creating a Generic JDBC connection, a Cloud Pak for Data administrator must upload the JDBC drivers for that data source. For details, see Importing JDBC drivers for data sources.
If you want to connect to an external NFS server or persistent volume claim by creating a Storage volume connection, a user with the Create service instances permissions must add the volume to Cloud Pak for Data. For details, see Managing storage volumes.
- Enter a name and description for the connection.
- Enter the details for the connection. The type of connection that you are creating determines
the information that you must specify. Typically, a connection requires either:
- A host name and port number
- A URL
You might also need to specify the database that you want to connect to.
- Enter your credentials for the connection. The type of connection that you are creating
determines the format of the credentials. Typically, a connection requires one or more of the following:
- Username and password
If the data source is a service that is deployed on the same instance of Cloud Pak for Data where you are creating the connection, you can use your Cloud Pak for Data credentials to authenticate to the data source. When you select Use your Cloud Pak for Data Credentials to authenticate to the data source, the username and password fields are disabled.
- API key
- Secret key
The credentials that you supply are accessible only from your account. Other users must supply their own credentials to use the connection.
Some data sources allow you to connect anonymously.
- Username and password
- If applicable, specify the SSL information required to connect to your data source.
Some data sources require you to use SSL for secure communication. Other data sources support it but do not require it. Ensure that you understand what information you need to provide to communicate securely with your data source:
- If you specified a port number that is configured to accept SSL connections, ensure that you select The port is configured to accept SSL connections
- If the data source uses a self-signed certificate, you must specify the contents of the certificate to enable secure communication between Cloud Pak for Data and the data source.
- If your data source uses chained certificates, you can specify the contents of multiple certificates.
Connecting to data sources at the service level
Typically, if you create a connection at the service level, the connection is accessible only from the service where it is created.