Getting connection information

You can find the connectivity information for IBM® watsonx.data from two locations: Connection information tile on the Configurations page and Instance details page.

The Connection information tile in the Configurations page provides the following information as per connection type selection:

General:
  • Instance details:
    • Host IP address
    • Port
    • Instance Id
    • SSL certificate
Engine and service connection details:
  • Presto engine details: Expand your Presto engine to see the following details:
    • Hostname
    • Port
    • SSL certificate
  • Spark engine details: Expand your Spark engine to see the following details:
    • Spark engine endpoint
    • Application endpoint
    • Port
  • Use the Copy JSON snippet and Export JSON links to copy or export JSON snippets for all engines and services
For IBM products:
  • Instance details:
    • Host IP address
    • Port
    • Instance Id
    • SSL certificate
  • Engine and service connection details:
    • Select the checkbox of the IBM product and use the Copy JSON snippet and Export JSON links to copy or export JSON snippets.
      Note: You can select one engine for the JSON snippet.
BI tools:
  • Tableu: Select the engine for connection details.
    • Server
    • Port
    • Catalog
      Note: You can use the edit icon to select the associated catalogs.
    • Username
    • Password: Enter the API key for authentication.
    • SSL certificate
    • You can also click the link to view BI connection documentation.
    • Use the Copy TDS snippet and Export TDS links to copy or export the data source files to quickly connect to data.
      Note: Data source files are shortcuts to quickly connecting to the original data that you use often. Data source files does not include the actual data but the information necessary to connect to the actual data. For more information, see Save Data Sources.
  • PowerBI: Select the engine for connection details.
    • Server
    • Port
    • Catalog
    • Username
    • Password: Enter the API key for authentication.
    • SSL certificate
    • You can also click the link to view BI connection documentation.
    • Use the Simba config.zip and CData config.zip links from the Export config files drop-down list to export config files.
  • Qlik: Select the engine for connection details.
    • Hostname
    • Port
    • Catalog
    • Username
    • Password: Enter the API key for authentication.
    • SSL certificate
    • You can also click the link to view BI connection documentation.
  • Domo: Select the engine for connection details.
    • Hostname
    • Port
    • Database
    • Username
    • Password: Enter the API key for authentication.
    • SSL certificate
    • You can also click the link to view BI connection documentation.
  • Looker: Select the engine for connection details.
    • Hostname
    • Port
    • Database
    • Username
    • Password: Enter the API key for authentication.
    • SSL certificate
    • You can also click the link to view BI connection documentation.
Visual Studio Code:
  • VS Code details:
    • Host IP address
    • API key: Enter the API key for authentication.
    • Username
  • View VS Code connection configuration
    • Connection information
    • Export JSON snippet
Data Build Tool:
  • Presto engine details: Expand your Presto engine to see the following details:
    • Hostname
    • Port
    • Catalog: You can change the catalog by clicking the pencil icon.
    • Username
    • Password: Enter your platform API key here. For information about generating platform API key, see Platform API keys.
  • Spark engine details: Expand your Spark engine to see the following details:
    • Spark engine endpoint
    • Application endpoint
    • Port
  • Associated query servers: Expand the associated query server to view the following details:
    • Hostname
    • URI
    • Catalog: You can change the catalog by clicking the pencil icon.
    • Instance ID
    • Username
    • API key: Enter your platform API key here. For information about generating platform API key, see Platform API keys.
    You can copy the profile details by clicking Copy profile snippet or export the details as a yaml file by clicking Export profile snippet.

To open the Instance details page, click the i icon on the home page. The Instance details page provides the following details:

    • Instance ID
    • Data Access Service (DAS) endpoint
    • Common Policy Gateway (CPG) endpoint