- MongoDB Connector for BI Components >
mongodrdl
mongodrdl
¶
On this page
Description¶
-
mongodrdl
¶
Note
The MongoDB Connector for BI and associated utilities are only available with MongoDB Enterprise 3.2 and greater.
mongodrdl
produces a schema based on contents of one or more
mongod
collections and writes them out into
.drdl
files understood by mongosqld
.
See Schema Configuration for details on this format.
Important
Restart mongosqld
to apply any changes you make to your
DRDL
files.
Options¶
Core Options¶
-
--help
¶
Returns information on the options and use of mongodrdl.
-
--version
¶
Returns the mongodrdl release number.
-
--verbose
<level>
,
-v
<level>
¶ Specifies that mongodrdl should provide more detailed log output. Include multiple times for more verbosity (e.g.
-vvvvv
), or specify a numeric value (e.g.--verbose=5
).
-
--quiet
¶
Hides all log output.
-
--host
<hostname><:port>
,
-h
<hostname><:port>
¶ Default: localhost:27017
Specifies a resolvable hostname for the
mongod
to which to connect. By default, the mongodrdl attempts to connect to a MongoDB instance running on the localhost on port number27017
.To connect to a replica set, specify the
replication.replSetName
and a seed list of set members, as in the following:You can always connect directly to a single MongoDB instance by specifying the host and port number directly.
-
--port
<port>
¶ Default: 27017
Specifies the TCP port on which the MongoDB instance listens for client connections.
-
--db
<database>
,
-d
<database>
¶ Specifies a database from which to generate a
.drdl
schema file.
-
--collection
<collection>
,
-c
<collection>
¶ Specifies a collection from which to generate a
.drdl
schema file. If you do not specify a collection, this option will use all collections in the specified database or instance.
-
--customFilterField
<name>
,
-f
<name>
¶ Specifies the field name to add for a custom MongoDB filter. See Custom Filters for more details.
-
--out
<path>
,
-o
<path>
¶ Default: Standard out.
Specifies the path where
mongodrdl
will write the schema file. To send the schema to standard output, specify “-
” instead of a path.
-
--sampleSize
<size>
,
-s
<size>
¶ Default: 1000
Specifies the number of documents to sample when generating the collection’s schema.
-
--uuidSubtype3Encoding
<old|csharp|java>
,
-b
<old|csharp|java>
¶ Specify the encoding used to generate UUID binary subtype 3. Choose one of the following values:
old
: Old BSON binary subtype representation,csharp
: The C#/.NET legacy UUID representation, andjava
: The Java legacy UUID representation.
-
--preJoined
¶
Generate unwound tables including parent columns, resulting in a “pre-joined” table.
Kerberos Options¶
-
--gssapiServiceName
<service-name>
¶ Default: mongodb
Specifies the service name to use when authenticating using GSSAPI/Kerberos.
-
--gssapiHostName
<host-name>
¶ Default: remote server’s hostname
Specifies the hostname to use when authenticating using GSSAPI/Kerberos.
TLS/SSL Options¶
-
--ssl
¶
Default: False
Instructs mongodrdl to use TLS/SSL when connecting to a MongoDB instance.
-
--sslCAFile
<filename>
¶ Specifies the MongoDB instance’s
.pem
file containing the root certificate chain from the Certificate Authority. Specify the file name of the.pem
file using relative or absolute paths.Warning
For SSL connections (
--ssl
) tomongod
andmongos
, if the mongodrdl runs without the--sslCAFile
, mongodrdl will not attempt to validate the server certificates. This creates a vulnerability to expiredmongod
andmongos
certificates as well as to foreign processes posing as validmongod
ormongos
instances. Ensure that you always specify the CA file to validate the server certificates in cases where intrusion is a possibility.
-
--sslPEMKeyFile
<filename>
¶ Specifies the
.pem
file containing both the TLS/SSL certificate and key for the MongoDB instance. Specify the file name of the.pem
file using relative or absolute paths.This option is required when using the
--ssl
option to connect to amongod
ormongos
that hasnet.ssl.CAFile
enabled withoutnet.ssl.allowConnectionsWithoutCertificates
.
-
--sslPEMKeyPassword
<password>
¶ Specifies the path to a file containing the certificate and private key for connecting to MongoDB.
-
--sslCRLFile
<filename>
¶ Specifies the
.pem
file that contains the Certificate Revocation List. Specify the file name of the.pem
file using relative or absolute paths.
-
--sslAllowInvalidCertificates
¶
Permits the MongoDB instance to present an invalid server SSL/TLS certificate. When using the
net.ssl.allowInvalidCertificates
setting, MongoDB logs the use of the invalid certificate as a warning.
-
--sslAllowInvalidHostnames
¶
Disables the validation of the hostnames in TLS/SSL certificates. Allows mongodrdl to connect to MongoDB instances if the hostname their certificates do not match the specified hostname.
-
--sslFIPSMode
¶
Directs the mongodrdl to use the FIPS mode of the installed OpenSSL library. Your system must have a FIPS compliant OpenSSL library to use the
--sslFIPSMode
option.
Authentication Options¶
-
--username
<username>
,
-u
<username>
¶ Specifies a username with which to authenticate to a MongoDB database that uses authentication. Use in conjunction with the
--password
and--authenticationDatabase
options.
-
--password
<password>
,
-p
<password>
¶ Specifies a password with which to authenticate to a MongoDB database that uses authentication. Use in conjunction with the
--username
and--authenticationDatabase
options.
-
--authenticationDatabase
<dbname>
¶ Specifies the database in which the user is created. See Authentication Database.
-
--authenticationMechanism
<name>
¶ Default: SCRAM-SHA-1
Specifies the authentication mechanism the mongodrdl instance uses to authenticate to the
mongod
ormongos
.Value Description SCRAM-SHA-1 RFC 5802 standard Salted Challenge Response Authentication Mechanism using the SHA1 hash function. MONGODB-CR MongoDB challenge/response authentication. MONGODB-X509 MongoDB TLS/SSL certificate authentication. GSSAPI (Kerberos) External authentication using Kerberos. This mechanism is available only in MongoDB Enterprise. PLAIN (LDAP SASL) External authentication using LDAP. You can also use PLAIN
for authenticating in-database users.PLAIN
transmits passwords in plain text. This mechanism is available only in MongoDB Enterprise.
Custom Filters¶
You can add a special field to your schema to pass a custom
MongoDB $match
query string to your MongoDB instance.
Use the --customFilterField
option with mongodrdl
to name
a custom filter field. This field passes a native MongoDB
$match
stage to use as the first stage of the aggregation
pipeline. The MongoDB Connector for BI applies this stage before any additional stages
pushed down from SQL.
The query can refer to any field in the collection, even if the fields were not exposed in the relational schema.
For an example, see Custom Filter.
Usage¶
Generate a Schema¶
Given documents of the following shape in the collection abc
in the
database test
:
You can use mongodrdl
to generate a schema based on this collection
by running the following command:
The generated schema file schema.drdl
will look similar to the following:
Custom Filter¶
To use this field, specify the --customFilterField
flag with the name you
want this field to have:
Your DRDL file schema.drdl
will include the following field in every generated table:
To add the special MongoDB query stage to your standard SQL, use the following SQL syntax:
The MongoDB Connector for BI will translate the above SQL into the following MongoDB aggregation expression:
You can use this custom filter in any business intelligence tool by filtering on your special field and providing the value to match as a single quoted string representing valid JSON. All quotes inside the JSON must be double quotes.
See also