GoodData-MongoDB BI Connector Integration Details

When setting up direct data distribution from your MongoDB database through the MongoDB Connector for BI, pay attention to the considerations and best practices listed in this article.

This article is applicable to all use cases of GoodData and MySQL integration:

Contents:

Ports Used

You can use any port from within the range of 1024-65535.

User Access Rights

We recommend that you grant the following access rights to the user who is referenced in Data Sources:

The following template can used to create a user:

db.createUser(
  {
    user: "<username>",
    pwd: "<password>",
    roles: [ { role: "read", db: "<dbname>" } ]
  }
 )

The following template can be used to update a user:

db.grantRolesToUser(
   "<username>",
   [ { role: "read", db: "<dbname>" } ]
)

Data Types

When generating the GoodData logical data model (LDM), your MongoDB Connector for BI automatically converts your data to a type that is supported by your connector. This data is then converted to a format that the LDM supports. If you want to prevent automatic changes, update the schema manually. For more information on MongoDB BI Connector file formats, see the MongoDB documentation for their Document Relational Definition Language.

MongoDB

MongoDB BI MySQL Data Type

GoodData LDM Data Type

NUMERIC

NUMERIC

DECIMAL(12,2)

DATES

TIMESTAMP

DATE

TIMESTAMPS

NULL

-

OBJECTID

VARCHAR

VARCHAR

UUID

VARCHAR

VARCHAR

Heterogeneous Fields

BI Connector uses the most frequently sampled type.

GoodData uses and converts the data type the BI Connector selects according to the information in this table.

Other field types not specified (for example BOOLEAN, FLOAT)

Refer to MongoDB documentation.

Transforms according to MYSQL data types.

GoodData system columns have the following format:

GoodData System ColumnsMongoDBMySQL Data Types
x__timestampDATETIMETIMESTAMP
x__deletedBOOLEAN, CHAR, VARCHAR, TEXTBOOLEAN, CHAR, VARCHAR, TEXT
x__client_idCHAR, VARCHAR, TEXTCHAR, VARCHAR, TEXT

Limitations

We do not support the following versions of MongoDB:

  • MongoDB 3.2
  • MongoDB 3.4
  • MongoDB 3.6