Catalog Support

By default, the Simba MongoDB JDBC Driver supports catalogs by using the name of the MongoDB database as the catalog. Doing so allows the connector to work easily with various JDBC applications.

The connector supports queries against MongoDB databases outside of the one that you are connected to, as well as joins between tables that belong to different databases. To work with data from other databases, in your SQL statements, specify the database (or catalog) that each table belongs to using the syntax DatabaseName.TableName.

Note:

As an alternative, you can configure the connector to treat MongoDB databases as schemas instead of catalogs. For more information, see CatalogSchemaSwap.