![\"\"](\"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2017\/08\/mongodb-logo.png\"){kind=logo}
In our previous post, we explored how to read and write MongoDB data using the ZappySys MongoDB Source<\/a>\u00a0and Destination<\/a>\u00a0SSIS connectors. In this article, you will learn how to connect MariaDB to MongoDB 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 MongoDB 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 MongoDB<\/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><\/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 MongoDB Destination<\/h3>\n
- \n
- In the Connection Manager pane, click New Connection<\/strong>.<\/li>\n
- Select ZS-MONGODB<\/strong>.<\/li>\n
- Configure the connection:\n
- \n
- Host<\/li>\n
- Username<\/li>\n
- Password<\/li>\n
- Database<\/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\/MongoDB-connection-configuration.png\")
<\/a>MongoDB connection configuration<\/p><\/div><\/li>\n
- Drag and drop the MongoDB Destination<\/strong><\/a> component.\n
![\"\"](\"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2026\/02\/Drag-and-drop-MongoDB-destination.png\")
<\/a>Drag and drop the MongoDB destination<\/p><\/div><\/li>\n
- Connect it to the ODBC Source <\/strong>and double-click to configure it.<\/li>\n
- Select the MongoDB connection.\n
![\"\"](\"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2026\/02\/MongoDB-Destination-Select-connection.png\")
<\/a>MongoDB Destination – Select connection<\/p><\/div><\/li>\n
- Go to the Properties<\/strong> tab and choose the operation and the target table.\n
![\"\"](\"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2026\/02\/MongoDB-Destination-Properties-configuration.png\")
<\/a>MongoDB Destination – Properties configuration<\/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\/MongoDB-Destination-Map-the-columns.png\")
<\/a>MongoDB 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 MongoDB.\n
![\"\"](\"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2026\/02\/MongoDB-Destination-Final-Result.png\")
<\/a>MongoDB Destination – Final Result<\/p><\/div><\/li>\n<\/ol>\n
Conclusion<\/h2>\n
With ZappySys SSIS PowerPack and ODBC PowerPack, connecting MariaDB to MongoDB becomes straightforward and reliable.<\/p>\n
By configuring the ODBC\/JDBC bridge for MariaDB and using the native MongoDB 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 MongoDB Destination<\/strong><\/a> component.\n
- Select ZS-MONGODB<\/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