Structural Cloud API docs
Other product guides
Tonic.ai

Configuring MongoDB workspace data connections

During workspace creation, under Connection Type, select MongoDB.

Connecting to the source database

The Source Settings section contains the connection information for the source database.

Providing the connection details

To provide the connection details, you can either populate the connection fields or use a connection string.

Populating the connection fields

By default, Use connection string is off, and you provide the connection values in the individual fields:

  1. In the Server field, provide the host name or IP address of the MongoDB instance.

  2. In the Database field, provide the name of the MongoDB database.

  3. In the Port field, provide the port number to connect to the server host.

  4. In the Username field, provide the username of a MongoDB user in your authentication database.

  5. In the Password field, provide the password of the specified MongoDB user.

  6. In the Authentication Database, provide the database where the MongoDB user that you authenticate with is stored. The default is often the admin database.

  7. The Use Srv setting indicates whether you are connecting to a DNS seed list. By default, the toggle is in the off position. If you connect to a DNS seed list, then toggle the setting to the on position.

Using a connection string

To use a connection string to connect to the source database:

  1. Toggle Use Connection String to the on position.

  2. In the Connection String field, provide a MongoDB connection string. For the password, use <password> as a placeholder value.

  3. In the Database field, provide the name of the MongoDB database.

  4. In the Password field, provide the password to use to replace <password>.

Providing SSL authentication settings

To configure the authentication settings for the source database:

  1. By default, SSL is enabled, and Enable SSL/TLS is in the on position. We strongly recommend that you do not turn off SSL.

  2. To indicate that Tonic Structural should trust the server certificate, toggle Trust Server Certificate to the on position.

  3. To specify your own client certificate for authentication:

    1. Click the expand icon for Client certificate settings.

    2. For Client Cert, choose the client certificate file.

    3. For Client Key, choose the key file for the client certificate.

    4. For Root Cert, choose the root certificate file.

Testing the source database connection

To test the connection to the source database, click Test Source Connection.

Blocking data generation on all schema changes

By default, data generation is not blocked as long as schema changes do not conflict with your workspace configuration.

To block data generation when there are any schema changes, regardless of whether they conflict with your workspace configuration, toggle Block data generation on schema changes to the on position.

Connecting to the destination database

The Destination Settings section contains the connection information for the destination database.

Copying the connection details from the source database

To copy the connection and authentication details from the source database:

  1. Click Copy Settings from Source.

  2. In the Password field, provide the password.

  3. To test the connection to the destination database, click Test Destination Connection.

Providing destination database connection details

If you don't copy the details from the source database, then you can either populate the connection fields or use a connection string.

Populating the connection fields

By default, Use connection string is off, and you provide the connection values in the individual fields:

  1. In the Server field, provide the host name or IP address of the MongoDB instance.

  2. In the Database field, provide the name of the MongoDB database.

  3. In the Port field, provide the port number to connect to the server host.

  4. In the Username field, provide the username of a MongoDB user in your authentication database.

  5. In the Password field, provide the password of the specified MongoDB user.

  6. In the Authentication Database, provide the database where the MongoDB user that you authenticate with is stored. The default is often the admin database.

  7. The Use Srv setting indicates whether you are connecting to a DNS seed list. By default, the toggle is in the off position. If you connect to a DNS seed list, then toggle the setting to the on position.

Using a connection string

To use a connection string to connect to the destination database:

  1. Toggle Use Connection String to the on position.

  2. In the Connection String field, provide a MongoDB connection string. For the password, use <password> as a placeholder value.

  3. In the Database field, provide the name of the MongoDB database.

  4. In the Password field, provide the password to use to replace <password>.

Providing SSL authentication settings

To configure the authentication settings for the destination database:

  1. By default, SSL is enabled, and Enable SSL/TLS is in the on position. We strongly recommend that you do not turn off SSL.

  2. To indicate that Structural should trust the server certificate, toggle Trust Server Certificate to the on position.

  3. To specify your own client certificate for authentication:

    1. Click the expand icon for Client certificate settings.

    2. For Client Cert, choose the client certificate file.

    3. For Client Key, choose the key file for the client certificate.

    4. For Root Cert, choose the root certificate file.

Testing the destination database connection

To test the connection to the destination database, click Test Destination Connection.

Last updated