Introduction In our previous post we saw how to read / write MongoDB data using ZappySys MongoDB Source and Destination. However it was all about connecting to On Premises hosted version of MongoDB. In this post you will focus on specifically on how to connect to MongoDB Atlas in SSIS (MongoDB Hosted in Cloud). MongoDB Atlas is Replicaset (Cluster setup) behind the scene so you have to tweak few options as explained in this post. Prerequisites Before we perform steps listed in this article, you will need to make sure following prerequisites are met: SSIS designer installed. Sometime ..read more

Introduction MongoDB is one of the most poplar NoSQL database out there. In this article you will learn how to use ZappySys MongoDB Destination Connector to perform various bulk operations on MongoDB such as Insert, Update, Delete and Upsert. If you wish to learn how to Update MongoDB Array items then check this blog post instread. MongoDB data read/write Example SSIS Package Before we talk more about loading data into MongoDB lets look at screenshot and steps involved in our sample package for this tutorial. Below sample SSIS package uses 4 Custom SSIS Tasks SSIS MongoDB Source Connector (Use ..read more