- In the Repository tree view, expand the Metadata node, right-click NoSQL Connection, and select Create Connection from the contextual menu. The connection wizard opens up.
In the connection wizard, fill in the general properties of the connection you
need to create, such as Name, Purpose and Description.
The information you fill in the Description field will appear as a tooltip when you move your mouse pointer over the connection.When done, click Next to proceed to the next step.
Select MongoDB from the DB Type list and MongoDB version of the database you are
connecting to from the DB Version list, and
specify the following details:
Enter the host name or IP address and the port number of the MongoDB server in the corresponding fields.
If the database you are connecting to is replicated on different hosts of a replica set, select the Use replica set address check box, and specify the host names or IP addresses and the respective ports in the Replica set address table. This can improve data handling reliability and performance.
If you want to restrict your MongoDB connection to a particular database only, enter the database name in the Database field.
If you leave this field blank, the wizard will list the collections of all the existing databases on the connected server when you retrieve schemas.
If your MongoDB server requires authentication for database access, select the Require authentication check box and provide your username and password in the corresponding fields.
- Click the Check button to make sure that the connection works.
Click Finish to validate the settings.
The newly created MongoDB database connection appears under the NoSQL Connection node in the Repository tree view. You can now drop it onto your design workspace as a MongoDB component, but you still need to define the schema information where needed.Next, you need to retrieve one or more schemas of interest for your connection.