Installation Steps

GlueSync NoSQL to SQL for MongoDB

Prerequisites

In order to have GlueSync working on your MongoDB instance you will need to have:

  • valid user credentials with permissions of reading, writing to the target database

Due to the way MongoDB users work, the user must be created on the target database.

Basic configuration example

The NoSQL to SQL module can be customized by using a configuration file, in JSON format. The file name to use must be specified as parameter when launching the app, with the -f or --file tokens. The file should be composed by union of common configuration file (see here Installation Steps) and source/destination specific configuration:

{
  ...
  "mongodb": {
    "enableRecursionProtection": false,
    "certificatesPath": "/path/to/certs/dir",
    "timeoutSeconds": 60
  }
}

MongoDB specific configurations are listed under the mongodb property:

  • enableRecursionProtection: boolean that avoid recursion when two ways sync capability is configured on the same table. If entities are different from SQL to NoSQL configuration this field should be false in order to improve performance, if entities are the same this field must be set true to avoid recursion loop. Default value is false;

  • certificatesPath (optional): the path to the certificates that need to be used when connecting to MongoDB. If omitted, no certificates are used;

  • timeoutSeconds (optional): number of seconds to set as timeout for operations involving communication with MongoDB. Default value is 60 seconds.

For more detailed configurations options please have a look at the section “Advanced configuration”.