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-
Go to Connections tab
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:
The default value is |
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 |
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.