0 / 0
Denodo connection
Last updated: Jan 28, 2025
Denodo connection

Denodo is an open, data virtualization platform. It supports all the major third-party data sources.

Supported versions

  • Version 8.0

Prerequisite

Create a connection to Denodo

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

  • Hostname or IP address: Hostname or IP address of the Denodo service
  • Port: Port number of the Denodo service
  • Database: Database name
  • Username and Password: The username and associated password to access the for the Denodo service.
  • SSL certificate: The SSL certificate of the host to be trusted. The certificate is needed only when the host certificate is not signed by a known certificate authority.

Choose the method for creating a connection based on where you are in the platform

In a project
Click Assets > New asset > Connect to a data source. 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 Import assets > Data access > Connection. See Adding data assets 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 the Denodo connection in the following workspaces and tools:

Projects

  • Data quality rules (IBM Knowledge Catalog)
  • Data Refinery (watsonx.ai Studio, IBM Knowledge Catalog)
  • DataStage (DataStage service). See Connecting to a data source in DataStage.
  • Metadata enrichment (IBM Knowledge Catalog)
  • Metadata import (data assets) (IBM Knowledge Catalog)
  • Notebooks (watsonx.ai Studio). 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.

Catalogs

  • Platform assets catalog

  • Other catalogs (IBM Knowledge Catalog)

Denodo setup

To set up the Denodo connection, see the Denodo platform installation guide.

Restrictions

You can use this connection only for reading data. You cannot write data or export data with this connection.

Running SQL statements

To ensure that your SQL statements run correctly, refer to the Virtual DataPort VQL Guide for the correct syntax.

Learn more

Parent topic: Supported connections