(View in full screen)

MongoDB is a document based NoSQL database

  • Data is stored in the format of JSON docs.

  • They have a flexible schema.

Starting in 8.1, you can create connections to MongoDB and MongoDB Atlas connections through Trifacta application. These connections enable to read data from the MongoDB workspace.

This feature is available in Trifacta Premium only.

Prerequisites

  • MongoDB supports basic (username/password) authentication.

Create Connection

To Create a MongoDB connection-

  1. Go to Connections tab

  2. Click Create Connection and select the Connection type as MongoDB

3. In the Connection dialog, you need to enter the following details pertaining to MongoDB

Properties and their details-

Host

Name of the host.

Port

Set this value to the port number through which to access MongoDB. By default, this value is 27017.

Database

The database that you want to read

Auth Database

Name of the MongoDB database used for authentication

Replica Set

(Optional) Comma-separated list of secondary servers in the replica set, specified by address and port.

A replica set is a group of mongoDB processes that maintain the same data set. Replica sets provide redundancy and high availability and are the basis for all production deployments. For more information, see https://docs.mongodb.com/manual/replication/.

Secondary Reads

Enable this checkbox if you want to read from secondary (slave) servers.

Use SSL

Enable this checkbox if you want to connect using SSL.

Connect String Options

(Optional) You can specify additional options used to connect as a string value.

The following option sets the connection timeout in milliseconds:

Timeout=0;

The default value is 0, which disables connection timeouts. See below for more information.

Test Connection

After you have defined the connection credentials type, credentials, and connection string, you can verify that the Trifacta application can use them to connect to the database.

Default Column Data Type Inference

Set to disabled to prevent the product from applying its own type inference to each column on import. The default value is enabled.

Connection Name

Display name of the connection

Connection Description

(Optional) Description of the connection, which appears in the application.

Once you have added all the relevant details, you can test the connection and then Create.

MongoDB Atlas

To create a MongoDB Atlas connection, the details to be added are the same as MongoDB apart from two fields -

  • Auth Database - Must always be “Admin”

  • SSL - always needs to be true

More Info

For more details on creating MongoDB connections, read this detailed documentation guide.


Did this answer your question?