I'm trying to connect to MongoDB and load data into Timextender
I have a ODBC driver setup, and test connection works.
In Timextender I have ODBC Generic Data setup, and test connection works and to Synchronize Data Source works as well.
But when I try to execute the data transfer from MongoDB into Timextender then I get an error.
As a workaround, you may test it with CData MongoDB provider.
Creating a support ticket to follow-up on error details.
As discussed in the support ticket, the following error messages were present:
' error: unexpected SUB at position 245
' error: unexpected STRING at position 342 near gr_notifications
A bug fix (12567) was released in 20.10.26 to handle the issue of Incorrect Accent grave sign in General ODBC setup. The Accent Grave type was character ' this has been changed to `. ODBC connections using the Accent Grave are update to use the new Single Quote.
Using TX Classic (V20.10.61) - what’s the preferred way to connect to a MongoDB ?
I have an ODBC setup, and when I sync the objects, we get a list of tables and flattened tables (which are JSON’s in the MongoDB collection).
However, when previewing such tables I often get an error - saying that some columns don’t exist. Is there a specific ODBC driver we should use, or specific options we should set in the connection to make this work?
We figured out the solution to be :
This setup is easy to maintain ( DRDL files ) and is performing very well.
as the mongodb bi connector is going to be deprecated:
https://www.mongodb.com/docs/atlas/bi-connection/
Important
Atlas BI Connector is approaching end-of-life. It will be deprecated and no longer supported in September 2026.
MongoDB is transitioning away from the BI Connector for Atlas to Atlas SQL. To learn about transitioning to the new interface, see Transition from Atlas BI Connector to MongoSQL.
What would be the recommended solution to connect to mongo db over the Mongo DB Atlas SQL ODBC Driver? We managed to setup a odbc connection, and could also query data using SQL syntax in other tools, but when we add an odbc datasource using that DSN, we cannot add Query Tables to get data. When I synchronize tables in the data source, there are no tables shown in timextender.
Hi
The AnySource ADO.NET provider can use Query Tables. Hence why I made this guide.
yes thank you very much that did the trick 👍
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
