⚠️ The DataGalaxy OTIC connector will be removed from the list of supported connectors end of June 2026. It won't be available in your platform anymore.
If you're already using the OTIC connector plugin of the Desktop connector, you can continue using it at your own risk. But it will not be updated anymore (including regarding vulnerabilities) and the support team won't be able to help you if you encounter issues.
This article describes how OTIC (ex-Genio) connector for DataGalaxy works.
This connector is available in the following modes:
| Desktop mode ✅ | SaaS Online mode ❌ |
Connector Overview
OTIC connector allows you to import the definitions of mapping stored in the database of an OTIC repository. The extracted objects and their correspondences are detailed in the following table:
| OTIC object | DataGalaxy object | Comments |
|---|---|---|
| Folder (Process) | Data Flow | The tree of folders and subfolders is represented using the Data Flow objects |
| Mapping (Module) | Data Processing | |
| Tables and columns in mapping input | Data Processing Input | Element of type Table (structure) |
| Tables and columns in mapping output | Data Processing Output | Element of type Table (structure) |
Step 1: Installation
- Download DataGalaxy connector from the portal (see here)
- Extract the connector archive in the directory of your choice
- Download the OTIC plug-in from the portal and copy it into the /lib directory of the connector
Step 2: Run the OTIC connector
- After starting the connector, access Processing type connectors:
- If it has been correctly installed, the OTIC plug-in appears in the list
- The following information is requested:
The connection is done using a JDBC driver that must be installed first ( it is also possible to use a JDBC driver embedded in a plugin if necessary).
For this type of plugin, the JDBC driver must first be copied into the /lib directory of the connector to be used in a connection chain
| Parameter | Mandatory | Description |
|---|---|---|
| URL | Yes | JDBC URL to connect to the OTIC repository database |
| User | Yes | |
| Password | Yes | |
| Advander mode | No | Option that allows the use of custom SQL queries. For more information: here |
You can then select the mappings you wish to import.
Releases
| Date | Plugin Version | DataGalaxy release | Desktop Connector version (minimum) | Description |
| 06/08/2024 | 3.0.0 | v3.65.0 | 5.0.5 | Migrated from java 11 to java 17 + CVE fixes |