Managing schemas in a MongoDB connection

The relational schemas are transformed from the collection schemas in a MongoDB data source, and then you can add tables that are transformed from the relational schemas to the connection.

This document shows how to add more collections in the schemas to a MongoDB connection, refresh the schemas, etc.

Adding schemas

To add relational schemas which are transformed from the collection schemas in a MongoDB file to a MongoDB connection, follow the steps below:

1. Right-click the Schemas node or an existing schema in the MongoDB connection and select Add Collection from the shortcut menu to display the Add Collections dialog. See the dialog.

   

2. Select the required collections in the schemas that are transformed from the collection schemas in the Schema box and then click add them to the Added Schema box.
3. After adding the required collection schemas, click OK to close the dialog.

Refreshing schemas

The schemas in your catalog are a temporary cache to improve performance when you design and test your report. Your data source will probably change over the time; however, these changes will not be reflected automatically in your catalog. To refresh all of the collection schema metadata from the MongoDB database, you can choose to refresh the schema information using the Refresh command on the shortcut menu of the schema. Then when the refreshing job is done, a reporting dialog will be shown, summarizing the changes and operations that have been taken.

Renaming and deleting databases of schemas

• To rename the database of the schemas, right-click the database and select Rename from the shortcut menu, and then input the required database name in the text box.
  • If the renamed database exists in the MongoDB data source, it will connect to the new database.
  • If the renamed database does not exist in the MongoDB data source, no data will be retrieved.
• To delete the database of the schemas, right-click the database and select Delete from the shortcut menu.