This article describes how DataGalaxy Oracle connector works.
This connector is available in the following modes:
| Desktop mode ✅ | SaaS Online mode ✅ |
This connector supports the following import modes:
| Standard mode ✅ | URN mode ✅ |
Connector scope
The connector allows you to import the following metadata from Oracle into a Database source:
- The set of schemas for a given database
- The content of the schemas: tables, views and columns
- Primary and foreign keys between tables
The extracted objects and their correspondences are detailed in the following table:
Oracle Object | DataGalaxy Object | Comments |
| Schema | Model (Container) | |
| Table | Table (Structure) | Comments are uploaded to the DataGalaxy Technical Comment field. |
| View | View (Structure) | Comments are uploaded to the DataGalaxy Technical Comment field. |
| Column | Column (Field) | Name, data type (size and precision), description, order are returned when available. Comments are uploaded to the DataGalaxy Technical Comment field. |
| Primary Key | Primarey Key | This information will be used to link tables in DataGalaxy diagrams |
| Foreign Key | Foreign Key |
Configuration of a connection
DataGalaxy Oracle connector uses the JDBC driver provided by editor, version 12.2.0.1.
According to the compatibility matrix provided by Oracle, this driver is compatible with all Oracle versions from 12.1 to 21.1. More information here (see "What is the JDBC and RDBMS interoperability matrix or the certification matrix?", link checked Feb 23, 2023).
The following information is required to set up a connection:
Parameter | Mandatory | Description |
| Server | Yes | Server name |
| Port | Yes | Server port |
| Instance | Yes | Oracle Instance or SID to be set up |
| SID | ||
| Schemas | No | Limits the scope to the specified schemas. |
| User | Yes | |
| Password | Yes | |
| Advanced mode | No | Option to customize the JDBC URL used to connect |
Execution of the connector
To create a connection 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
| Date | Plugin Version | DataGalaxy release | Desktop Connector version (minimum) | Description |
| 23/01/2026 | 5.0.5 | v3.302.1 | 5.15.4 | Orphaned handling feature bugfix for urn mode |
| 31/12/2025 | 5.0.4 | v3.295.4 | 5.15.4 | Orphaned handling feature bugfix for urn mode |
| 28/11/2025 | 5.0.3 | v3.288.2 | 5.15.3 | Fix PK/FK issue |
| 25/09/2025 | 5.0.0 | v3.286.3 | 5.12.0 | Addition for URN support |
| 06/08/2024 | 4.0.0 | v3.65.0 | 5.0.5 | Migrated from java 11 to java 17 + CVE fixes |
| 02/07/2024 | 3.1.0 | v3.55.0 | Multi-schema selection |