Initially developed as part of our own analytics solution, we're pleased to say that we've released Mongosis, a set of custom components for integrating MongoDB and Microsoft SQL Server Integration Services (SSIS).
Developed in C#, Mongosis provides a means to read data from MongoDB within SSIS via custom data source and connection manager components. Available collection fields are automatically detected and added as output fields ready to be piped in to any of the standard SSIS destination components. At the time of writing, there is no facility to write to a MongoDB collection via a custom destination component, but we've open sourced the project so feel free to fork the project and get involved or let us know you're interested.
If you'd like to get stuck in and use Mongosis within SSIS immediately, the ready-to-use DLL is available here:
Please see the Mongosis [project page for a guide and info.
Want to know more about what it's like to work in tech at Simply Business? Read about our approach to tech, then check out our current vacancies.Find out more
Keep up to date with Simply Business. Subscribe to our monthly newsletter and follow us on social media.Subscribe to our newsletter
99 Gresham Street
29 St Katherine's Street
© Copyright 2019 Simply Business. All Rights Reserved. Simply Business is a trading name of Xbridge Limited which is authorised and regulated by the Financial Conduct Authority (Financial Services Registration No: 313348). Xbridge Limited (No: 3967717) has its registered office at 6th Floor, 99 Gresham Street, London, EC2V 7NG.