Mongo Atlas JDBC possible to issue update?

[Daniel_Reyes]

@Telmo_baia

I’ve been trying to use jdbc drivers to read and write tables in mongo atlas via sql connection, but when i try to update the tables i get a message saying ‘command update not available’.
Is there a way to update records directly to the database, or data federation?
Does the SQL command Update not wor

@Telmo_baia

Hi! Thanks for replying. I’m using a platform to mask data in several types of databases. I can mask a local mongodb, but i need to mask mongodb/atlas. The platform i’m using allows me to install jdbc drivers to do this. So the logic was to communicate with atlas using SQL JDBC URL, read the database, then the platform will find the data that needs to be masked/anonymized and will update the tabled accordingly in atlas, and ofcourse, return it to the previous state, when requested. But i wasn’t aware the SQL interface was read only. I spent alot of time trying
Is there any other way to connect via JDBC driver to do this?

• Use MongoDB Drivers or APIs (e.g. native Java driver) to run updates
• Or use Data Federation / Atlas SQL Interface for read/write support (if enabled)
• As a fallback, pull the document via SQL, modify it in app logic, then write it back via native driver