Is it Possible to Load data to MongoDB Using SSIS? If yes tools required to achieve? Does MongoDB Support all the SQL Operations?
1 Answers
Is it Possible to Load data to MongoDB Using SSIS? If yes tools required to achieve?
There are several ways to load data into MongoDB using SSIS:
1. Using MongoDB ODBC driver and BI Connector
I already published an article about importing data from MongoDB to SQL Server using SSIS using ODBC source component. You can refer to that article and use the same approach with the ODBC Destination component.
2. Using a Script Component as Destination
The second approach is to use a Script Component as a destination. You should use the MongoDB .NET Driver to insert rows into the MongoDB database within the Script Component.
- Data migration to NoSQL from Relational DB using MongoDB, MSSQL and SSIS 2012
- MongoDB for .NET Developers official course
3. Using Third-party component
You can buy a MongoDB SSIS third-party component from the Visual Studio Marketplace:
Do MongoDB Support all the SQL Operations?
No, as MongoDB is a Not a relational database and it has its own query language MQL which is built using Javascript.
You can check the following article, where similar features are listed:
Related