0 / 0
IBM Db2 Hosted connection

IBM Db2 Hosted connection

To access your data in an IBM Db2 Hosted database, create a connection asset for it.

IBM Db2 Hosted is a hosted Db2 database service.

Create a connection to Db2 Hosted

To create the connection asset, you need these connection details:

  • Database name
  • Hostname or IP address
  • Port number

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

In a project
Click Assets > New asset > Data access tools > Connection. See Adding a connection to a project.
In a catalog
Click Add to catalog > Connection. See Adding a connection asset to a catalog.
In a deployment space
Click Add to space > Connection. See Adding connections to a deployment space.
In the Platform assets catalog
Click New connection. See Adding platform connections.

Next step: Add data assets from the connection

Where you can use this connection

You can use Db2 Hosted connections in the following workspaces and tools:

Projects

  • Data Refinery (Watson Studio or Watson Knowledge Catalog)
  • DataStage (DataStage service). See Connecting to a data source in DataStage.
  • Metadata enrichment (Watson Knowledge Catalog)
  • Metadata import (Watson Knowledge Catalog)
  • SPSS Modeler (Watson Studio)

Catalogs

  • Platform assets catalog
  • Other catalogs (Watson Knowledge Catalog)
Watson Query service
You can connect to this data source from Watson Query.

Db2 Hosted setup

Restrictions

  • For Data Refinery, you can use this connection only as a source. You cannot use this connection as a target connection or as a target connected data asset.
  • For SPSS Modeler, you can use this connection only to import data. You cannot export data to this connection or to a Db2 Hosted connected data asset.

Parent topic: Supported connections

Generative AI search and answer
These answers are generated by a large language model in watsonx.ai based on content from the product documentation. Learn more