The Complete MongoDB BI Connector Migration Guide
A migration playbook from the team that does this for a living
The MongoDB BI Conenctor reaches End-of-Life on September 30.
5-STEP MIGRATION PATH
Most of the writing online about the BI Connector deprecation either oversimplifies the migration (“just install the SQL Interface”) or buries the practical decisions inside vendor marketing.
This guide is the document our own services team uses to scope migrations. We’re making it available because the teams who go in informed make better decisions, whether they end up working with us or not.
- Run the migration assessment tool: What it produces, and the known limitations most teams hit
- Install the Mongo SQL Interface: What it actually does, and the connection gotchas that stall projects early
- Map collections to your legacy virtual tables: The naming conventions the BI Connector used and how to navigate between the two worlds
- Choose a query-migration approach: Three real options, scored on effort vs. performance
- Validate, tune, and maintain: What to expect, and a realistic split of how much converts cleanly vs. needs hands-on work
Additional Resources
Free Migration
Assessment
We review the BI Connector views you have today, map the downstream dependencies, and deliver a clear migration plan free of charge, showing exactly what it takes to move to the SQL Interface.
On-Demand
Webinar
Watch our on-demand webinar featuring Alexi Antonino, MongoDB’s Product Manager for Data Federation, SQL Interface, and the BI Connector, and get the full picture on what this transition actually means.