You can also execute free-form queries that are not tied to the schema. To access MongoDB collections as tables you can use automatic schema discovery or write your own schema definitions. Set the Server, Database, User, and Password connection properties to connect to MongoDB. See the "Getting Started" chapter in the help documentation for a guide to using the Microsoft ODBC Data Source Administrator to create and configure a DSN. This is also the last step of the driver installation. You can use the built-in Microsoft ODBC Data Source Administrator to configure the DSN. If you have not already done so, provide values for the required connection properties in the data source name (DSN). Follow the procedure below to start the MySQL remoting service of the SQL Gateway and work with live MongoDB data in MySQL Workbench. You can use the SQL Gateway from the ODBC Driver for MongoDB to query MongoDB data through a MySQL interface.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |