This article describes how DataGalaxy Denodo connector works.
This connector is available in the following modes:
| Desktop mode ✅ | SaaS Online mode ✅ |
Connector scope
The connector allows you to import the following metadata from Denodo into a Database source:
- All Denodo databases
- The content of the database : folders, views and columns
- Primary keys of views
The connector also allows to visualize the links between Denodo views by importing metadata in the Processing module.
The extracted objects and their correspondences are detailed in the following table:
| Denodo Object | DataGalaxy Object | Comments |
| Database | Model (Container) | Each Denodo database is imported as a template (schema) into a parent DataGalaxy source. |
| Folder | Model (Container) | The folder tree is imported as a template (schema) as a child of its parent database. |
| View | Table (Structure) | The views are raised as tables in order to create the associated primary keys in DataGalaxy. |
| Field Name (column) | Column | |
| PK | Primarey Key | |
| Folder / Database | Data Flow | Each folder/base in the Denodo tool is imported as a flow into a root flow in the Processing module. |
| View | Data Processing | |
| Links between views | Data Processing Item | |
| Field Name (column) | Data Processing Item Input | |
| Data Processing Item Output) |
Configuration of a connection
Denodo connector uses the JDBC driver provided by editor.
The following information is required to set up a connection:
Parameter | Mandatory | Description |
| Server | Yes | Server name |
| Port | Yes | Server port |
| Database | Yes | Limits the scope to the specified database |
| User | Yes | |
| Password | Yes | |
| Dataflow root object name (Desktop connector option) | Yes | Name of the "parent" flow in the DataGalaxy Processing module, which will be used to store all links between Denodo views. |
| Advanced mode (Desktop connector option) | No | Option to customize the JDBC URL used to connect |
Execution of the connector
To create a connection to Donodo via the Online connector, the entry points are as follows:
From the Import button of the "Shortcuts" widget on the home screen of a client space or workspace
From the Import button of one of the modules when it is empty
From the Import button in the contextual menu of one of the modules, on the right side of the filtered views
From the Add a connection button in the Connector tab available in the workspace setup screen
You can optionally filter (by module, connector type or by using the search bar), then click on the desired technology: 
You then need to complete the login form using the login information described above to perform an import. For more details on the steps involved in running the Online connector, you can consult the following article: [HowTo] Running the Online Connector.
This technology is also available via the Desktop Connector, you can find more information on the procedure here: [How to] How to use the connector.
Releases (Denodo)
| Date | Plugin Version | DataGalaxy release | Desktop Connector version (minimum) | Description |
| 06/08/2024 | 5.0.0 | v3.65.0 | 5.0.5 | Migrated from java 11 to java 17 + CVE fixes |
Releases (Denodo version 7)
| Date | Plugin Version | DataGalaxy release | Desktop Connector version (minimum) | Description |
| 06/08/2024 | 4.0.0 | v3.65.0 | 5.0.5 | Migrated from java 11 to java 17 + CVE fixes |