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
We create this content for general information purposes and it should not be taken as advice. Always take professional advice. Read our full disclaimer
6th Floor99 Gresham StreetLondonEC2V 7NG
Sol House29 St Katherine's StreetNorthamptonNN1 2QZ
© Copyright 2020 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.