This article describes how DataGalaxy PostgreSQL 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 Overview
PostgreSQL connector imports metadata from a database into a DataGalaxy database source object.
The extracted objects and their correspondences are detailed in the following table:
| PostgreSQL Object | DataGalaxy Object | Comments |
|---|---|---|
| Schema | Model (Container) | |
| Table | Table (Structure) | |
| View | View (Structure) | |
| 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 | Primary Key | This information will be used to link tables in DataGalaxy diagrams |
| Foreign Key | Foreign Key |
Step 1 : Installation
- Download DataGalaxy connector from the portal (see Download and Install the Desktop Connector)
- Extract the connector archive in the directory of your choice
- Download the PostgreSQL plug-in from the portal and copy it into the /lib directory of the connector
Step 2 : Run PostgreSQL connector
- After starting the connector, access to Dictionary connectors:
- If it has been correctly installed, the PostgreSQL plug-in appears in the list
The following information is requested:
| Parameter | Mandatory | Description |
|---|---|---|
| Server | Yes | PostgreSQL Server name |
| Port | Yes | PostgreSQL Server port |
| Instance | Yes | PostgreSQL instance name |
| User | Yes | |
| Password | Yes | |
| Advanced mode | No | Option to customize the JDBC URL used to connect |
Once this information is filled, you can test the connection and start the import.
Releases
| Date | Plugin Version | DataGalaxy release | Desktop connector version (minimum) | Description |
|---|---|---|---|---|
| 29/09/2026 | 6.1.2 | 3.423.0 | 6.2.2 | New internal implementation to fix security vulnerabilities |
| 16/07/2026 | 5.2.0 | 3.379.0 | 5.18.5 | Retrieval of stored procedure now supported in URN mode |
| 16/06/2026 | 4.2.1 | v3.356.0 | 5.16.0 | Fixed some security vulnerabilities |
| 26/05/2026 | 4.2.0 | v3.344.0 | 5.15.12 | Support online mode |
| 19/12/2025 | 4.1.0 | v3.294.0 | 5.15.4 | Orphaned handling feature bugfix for urn mode |
| 28/11/2025 | 4.0.2 | v3.288.2 | 5.15.3 | Fix PK/FK issue |
| 01/10/2025 | 4.0.0 | v3.286.3 | 5.12.0 | Addition of URN support |
| 26/07/2024 | 3.0.0 | v3.62.0 | 5.0.3 | Migrated from java 11 to java 17 |