Search code examples
sqlmongodbbusiness-intelligence

Does MongoDB BI Connector support INSERT/UPDATE operations?

Does the MongoDB BI connector support INSERT and UPDATE SQL commands?

I want to use the BI connector to INSERT data into MongoDB from an SQL connection.

I've looked through all your documentation but I cannot find any concrete answer.

Is that supported? Thank you.

Solution

  • The MongoDB Connector for BI currently provides a read-only interface to a MongoDB deployment via the MySQL wire protocol or ODBC.

    This is intended to be used for querying and reporting on data in MongoDB with BI tools rather than being a full SQL interface for CRUD interaction.

    For more details, see Supported SQL Functions & Operators in the BI Connector documentation.