CODEWITHSUNDEEP
sqlmongodbbusiness-intelligence
Paul C
Paul C

Reputation: 23

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.

Upvotes: 0

Views: 149

Answers (1)

Stennie
Stennie

Reputation: 65383

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.

Upvotes: 2

Related Questions