![\"PostgreSql](\"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2019\/04\/ssis-PostgreSql-Destination.png\")
<\/a>In our previous post, we explored how to read and write PostgreSQL data using the ZappySys PostgreSQL Source<\/a> and Destination<\/a> connectors for SSIS. In this article, you will learn how to connect MariaDB to PostgreSQL using ZappySys SSIS PowerPack and transfer data between both systems.<\/p>\nWe will demonstrate a practical ETL pattern using ZappySys ODBC\/JDBC connectivity to extract data from MariaDB and load it into PostgreSQL within SSIS.<\/p>\n
Prerequisites<\/h2>\n
Before you begin, make sure you have the following:<\/p>\n
- \n
- First, you will need to have SSIS installed<\/li>\n
- Secondly, make sure to have SSDT<\/li>\n
- Thirdly, access credentials for both MariaDB and PostgreSQL<\/li>\n
- Finally, do not forget to install\u00a0ZappySys\u00a0SSIS PowerPack<\/a> and\u00a0ZappySys\u00a0ODBC PowerPack<\/a><\/li>\n<\/ul>\n
Steps<\/h2>\n
Configure MariaDB Connection Using ODBC (JDBC Bridge)<\/h3>\n
Since MariaDB connectivity is handled via JDBC, we will use the ZappySys JDBC Bridge Driver<\/strong> to expose it as an ODBC data source.<\/p>\n
- \n
- Visit the official MariaDB website<\/a>.<\/li>\n
- Download the latest MariaDB JDBC driver<\/strong>.<\/li>\n
- Save the
.jar<\/code> file locally, for example: D:\\Zappysys\\drivers\\mariadb-java-client-3.5.7.jar<\/span><\/li>\n- Download and install ZappySys ODBC PowerPack<\/strong><\/a> if not already installed.<\/li>\n
- Open ODBC Data Sources (64-bit)<\/strong>.\n
![\"\"](\"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2019\/01\/how-to-open-odbc-data-source-administrator-2.png\")
<\/a>Open ODBC Data Sources<\/p><\/div><\/li>\n
- Create a\u00a0User data source<\/strong>\u00a0(User DSN) based on\u00a0ZappySys JDBC Bridge Driver<\/strong>:\n
![\"\"](\"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2026\/02\/Create-a-User-data-source.png\")
<\/a>Create a User data source<\/p><\/div><\/li>\n
- Configure the JDBC Connection. Fill in the connection details\n
- \n
- Connection String\u00a0 <\/strong>
jdbc:mariadb:\/\/{host-name}:{port}\/{database-name}
\n<\/code><\/li>\n- JDBC Driver File <\/strong>
D:\\Zappysys\\drivers\\mariadb-java-client-3.5.7.jar
\n<\/code><\/li>\n- Username <\/strong>
root
\n<\/code><\/li>\n- Password <\/strong>
********
\n<\/code><\/li>\n- Connection Parameters<\/strong>
[]<\/code><\/li>\n<\/ul>\n<\/li>\n- Click Test Connection<\/strong>. If configured correctly, you should see a success message.\n
<\/div>\n![\"\"](\"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2026\/02\/Zappysys-JDBC-Mariadb.png\")
<\/a>Zappysys JDBC – MariaDB<\/p><\/div><\/li>\n
- You can also use the Preview<\/strong> tab to select the table and execute SQL queries. For advanced SQL examples, refer to the JDBC Bridge documentation<\/a>.\n
![\"\"](\"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2026\/02\/Zappysys-JDBC-MariaDB-preview-result.png\")
<\/a>Zappysys JDBC – MariaDB preview result<\/p><\/div><\/li>\n<\/ol>\n
Connect MariaDB to SSIS<\/h3>\n
- \n
- Open Visual Studio<\/strong>.<\/li>\n
- Create a New Project<\/strong>.<\/li>\n
- Select Integration Services Project<\/strong>.<\/li>\n
- Provide a project name and location, then click OK<\/strong>.<\/li>\n
- Drag and drop a Data Flow Task<\/strong> from the SSIS Toolbox onto the Control Flow surface.\n
![\"\"](\"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2026\/02\/Drag-and-drop-Data-flow.png\")
<\/a>Drag and drop Data flow.<\/p><\/div><\/li>\n
- Double-click the task to open the Data Flow Designer<\/strong>.<\/li>\n
- Drag and drop an ODBC Source<\/strong> component into the Data Flow.\n
![\"\"](\"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2026\/02\/Drag-and-drop-ODBC-source.png\")
<\/a>Drag and drop the ODBC source.<\/p><\/div><\/li>\n
- Double-click the component to configure it.<\/li>\n
- Click New\u2026<\/strong> to create a new ODBC Connection Manager.\n
![\"\"](\"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2026\/02\/Creating-ODBC-Connection-Manager-in-SSIS.png\")
<\/a>Creating an ODBC Connection Manager in SSIS<\/p><\/div><\/li>\n
- Select the MariaDB ODBC DSN you created earlier.<\/li>\n
- Click Test Connection <\/strong>and click OK <\/strong>to save the configuration.\n
![\"\"](\"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2026\/02\/Creating-ODBC-Connection-Manager-in-SSIS-from-JDBC.png\")
<\/a>Creating an ODBC Connection Manager in SSIS from JDBC<\/p><\/div><\/li>\n
- Choose Data Access Mode: <\/strong>Table name or SQL command.<\/li>\n
- Select the desired table or enter a custom query.<\/li>\n
- Click\u00a0Preview<\/strong>\u00a0to validate the data, and click\u00a0OK <\/strong>to save the configuration.
\n<\/span><\/span><\/p>\n![\"\"](\"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2026\/02\/Preview-ODBC-Connection-Manager-in-SSIS-from-JDBC.png\")
<\/a>Preview an ODBC Connection Manager in SSIS from JDBC<\/p><\/div><\/li>\n<\/ol>\n
Configure PostgreSQL Destination<\/h3>\n
- \n
- In the Connection Manager pane, click New Connection<\/strong>.<\/li>\n
- Select ZS-POSTGRESQL<\/strong>.<\/li>\n
- Configure the connection:\n
- \n
- Host<\/li>\n
- Username<\/li>\n
- Password<\/li>\n
- Port<\/li>\n
- Database name<\/li>\n<\/ul>\n<\/li>\n
- Use the other tabs for more configuration if needed<\/li>\n
- Click Test Connection <\/strong>and Click OK<\/strong>.\n
![\"\"](\"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2026\/02\/PostgreSQL-connection-configuration.png\")
<\/a>PostgreSQL connection configuration<\/p><\/div><\/li>\n
- Drag and drop the PostgreSQL Destination<\/strong><\/a> component.\n
![\"\"](\"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2026\/02\/Drag-and-drop-PostgreSQL-destination.png\")
<\/a>Drag and drop the PostgreSQL destination.<\/p><\/div><\/li>\n
- Connect it to the ODBC Source <\/strong>and double-click to configure it.<\/li>\n
- Select the PostgreSQL connection.\n
![\"\"](\"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2026\/02\/PostgreSQL-Destination-Choose-the-connection.png\")
<\/a>PostgreSQL Destination – Choose the connection<\/p><\/div><\/li>\n
- Go to the Properties<\/strong> tab and choose the target table.\n
![\"\"](\"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2026\/02\/PostgreSQL-Destination-Choose-the-target-table.png\")
<\/a>PostgreSQL Destination – Choose the target table<\/p><\/div><\/li>\n
- Go to the Column Mappings<\/strong> tab and map source columns to destination columns.\n
![\"\"](\"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2026\/02\/PostgreSQL-Destination-Map-the-columns.png\")
<\/a>PostgreSQL Destination – Map the columns<\/p><\/div><\/li>\n
- Click OK <\/strong>to save the configuration.<\/li>\n
- Run the SSIS package. If everything is configured correctly, the data will be transferred from MariaDB to PostgreSQL.\n
![\"\"](\"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2026\/02\/PostgreSQL-Destination-Final-result.png\")
<\/a>PostgreSQL Destination – Final result<\/p><\/div><\/li>\n<\/ol>\n
Alternative Option \u2014 Using Upsert Destination<\/h3>\n
An alternative destination component is the Upsert Destination<\/a>; you can replace it with the PostgreSQL destination. You can preview data from the element, select the options to insert or\/and update, and more.<\/p>\n
- \n
- Replace the PostgreSQL Destination with the Upsert Destination<\/strong><\/a>.<\/li>\n
- Select your PostgreSQL connection.<\/li>\n
- Choose the target table.<\/li>\n
- Choose Insert<\/strong> or\/and Update<\/strong> action.n<\/li>\n
- Map the columns.<\/li>\n
- Select the primary key column(s).<\/li>\n
- Configure additional options under the Advanced<\/strong> tab if needed.\n
![\"\"](\"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2026\/02\/Upsert-Destination-PostgreSQL-destination-table.png\")
<\/a>Upsert Destination – PostgreSQL destination table<\/p><\/div><\/li>\n
- Run the package to perform the upsert operation.\n
![\"\"](\"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2026\/02\/Upsert-Destination-Final-result.png\")
<\/a>Upsert Destination – Final result<\/p><\/div><\/li>\n<\/ol>\n
Conclusion<\/h2>\n
With ZappySys SSIS PowerPack and ODBC PowerPack, connecting MariaDB to PostgreSQL becomes straightforward and reliable.<\/p>\n
By configuring the ODBC\/JDBC bridge for MariaDB and using the native PostgreSQL destination in SSIS, you can build a robust ETL pipeline between the two databases.<\/p>\n
Explore the full capabilities of the ZappySys\u00a0SSIS PowerPack<\/a> and\u00a0ZappySys\u00a0ODBC PowerPack<\/a> to optimize your data integration tasks.<\/p>\n
Need Help?<\/h1>\n
If you encounter any issues, our support team is here to help:<\/p>\n
- Drag and drop the PostgreSQL Destination<\/strong><\/a> component.\n
- Select ZS-POSTGRESQL<\/strong>.<\/li>\n
- Create a New Project<\/strong>.<\/li>\n
- JDBC Driver File <\/strong>
- Download the latest MariaDB JDBC driver<\/strong>.<\/li>\n
- Visit the official MariaDB website<\/a>.<\/li>\n