Delbridge Solutions
Delbridge Solutions

Migrating from the BI Connector to the SQL Interface

Keep your MongoDB data accessible for analytics, BI, and AI without ETL, replication, or re-architecting your stack.

Free Migration Assessment

MongoDB BI Connector Goes End-of-Life on September 30, 2026

Since 2015 the BI Connector has been the preferred solution for those wanting to connect BI tools to MongoDB and produce reports.  On September 30, 2026 the BI Connector comes to end of life.  The SQL Interface is the successor solution.  In many ways it is an improvement over the BI connector.  Essentially the new solution is a SQL-92 compliant query engine providing all the functionality and familiarity of SQL in the form of MongoSQL, MonogDB’s dialect of SQL which comes complete with some special features  for flattening out document models and rendering them accessible to BI tools.

Monalytica is designed as a complementary solution that works with the SQL Interface in three areas:

  1. As a purpose-built IDE for writing and editing MongoSQL
  2. As a tool for writing and persisting as views in MongoDB, the views/table that the BI Connector previously persisted in MySQL
  3. A natural language-based AI interface to generate ad hoc, real-time queries to explore and extract data from MongoDB. 

In short, the BI professional and Data analyst now has a tool kit to work with MongoDB and exploit the full power of MongoSQL. 

Free Migration Assessment
What are the benefits of migrating from the BI Connector to the SQL Interface?

The SQL Interface is a very efficient and dynamic query engine usable by anyone with knowledge of SQL with lower maintenance overhead and fewer moving parts than the BI Connector.

How can we get the equivalent of the flat views that the BI Connector creates today?

You must now build these views using MongoSQL. Monalytica gives you a purpose built IDE to build these views. Ask about our migration assessment we can accelerate the development of these views.

What are the Benefits of Using Monalytica with the SQL Interface?

Monalytica comes with a purpose built IDE for workig with MongoSQL, AI based data exploration and profiling and a natural langauge query generation capability making all data easily available to users with BI and analytics backgrounds.

Free Migration Assessment

Monalytica. Built for the SQL Interface Era

Migration

Connect
1
Point Monalytica at your MongoDB instance and the SQL Interface. Browse your existing collections immediately.
Recreate Your Views
2
Use Monalytica's IDE to rebuild your BI Connector views as persistent SQL views once. They'll be stored as aggregation pipelines natively in MongoDB and surfaced as clean tables to every connected BI tool.
Reconnect Your Reports
3
Your legacy reports reconnect to familiar view names, minimizing the need for rewrites. No retrained analysts. Just a clean migration path with Monalytica managing the view layer.

September 2026 is closer than it looks.

Get ahead of the BI Connector end-of-life now. Monalytica is ready when you are. Book your free migration assessment and we’ll review your existing BI Connector views and tell you exactly what it will take to move them to MongoSQL.