Cant write to MongoDB ODBC

Edgar_Lozano · 2024-07-16T17:20:25.035Z

Hello, I am currently working on a custom tool tool which issues only SQL statements but I was already using MongoDB… I installed some mongo ODBC driver and the connector for BI and was able to read data but when trying to write I get the following: “insert requires --writeMode”…

Ran the connector for BI, then I configured the windows ODBC to port 3307
[custom software] → ODBC driver → MongoDB

am I missing something? The MongoDB AI chat said the following: “yes you can issue write statements to mongoDB using the MongoDB Connector for BI”

thanks in advance

Leo_Crown · 2024-07-25T11:59:49.494Z

Hello,

The error message “insert requires --write Mode” indicates that the BI Connector is not configured to handle write operations by default. The MongoDB Connector for BI is primarily designed for read operations, allowing you to query MongoDB data using SQL. Unfortunately, it does not support write operations directly1. This is why you’re seeing the error when attempting to insert data. To perform write operations, you would need to use MongoDB’s native drivers or another method that supports CRUD operations. Here are a few steps you can take:

Use MongoDB Native Drivers: Consider using MongoDB’s native drivers for your programming language to handle write operations. These drivers are designed to support full CRUD functionality.
Alternative Tools: If you need to use SQL for both read and write operations, you might need to look into other tools or frameworks that can bridge SQL and MongoDB more effectively.
Feature Request: If write operations via the BI Connector are crucial for your project, you can submit a feature request to MongoDB

I hope this info helpful to you.