Skip to main content Skip to complementary content
Qlik Resources
Loading SearchUnify's search If you need assistance with your product, please contact Qlik Support.
Qlik Customer Portal
Loading SearchUnify's search If you need assistance with your product, please contact Qlik Support.
Qlik Customer Portal

Creating a connection to a MongoDB database

Procedure

  1. 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.
  2. 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.
  3. 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.

    • If you must use an SSL connection to connect to your MongoDB server, you can select the Enable SSL (using preference setup) check box to use the centralized connection information. Then make sure that you configured this connection in Windows > Preferences > Talend > SSL and restart Talend Studio to activate it.
  4. Click the Check button to make sure that the connection works.
  5. 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.

Did this page help you?

If you find any issues with this page or its content – a typo, a missing step, or a technical error – please let us know!

Leave your feedback here