MongoDB Connection Properties
A MongoDB connection can have the following child objects: MongoDB Database, MongoDB Collection, MongoDB Element.
The properties of a MongoDB connection are as follows:
Property Name | Description |
---|---|
Connection Options | Specifies the options used to connect to the MongoDB server. The options are name=value pairs and the pairs are separated by "&".
Data type: String |
Default | Specifies whether the connection is the default connection in the current data source. By default, the first added connection in a data source is the default connection of the data source. A data source can have zero or one default connection.
Data type: Boolean |
Description | Specifies the description of the MongoDB connection.
Data type: String |
Name | Specifies the name of the MongoDB connection. If the name has already been used, a number starting from 1 will be appended to the name. For example, if aa exists, the new name will be aa1, and if both aa and aa1 exits, it will be aa2, and so on. If you change the name, the imported SQL and stored procedures that reference the connection will be automatically updated to use the new name.
Data type: String |
Password | Specifies the password for connecting to the MongoDB database, which is determined by the database administrator.
When the catalog is saved as xml format, the password will be encrypted by an algorithm and stored in an xml catalog file, and it will be decrypted when the xml format catalog is loaded. Data type: String |
Push Down Group Query | Specifies whether to push down group level summary computations in reports to the DBMS at runtime. Choose an option from the drop-down list.
Data type: Boolean |
Server Address | Displays a list of replica set members or MongoDBs, including IP/host name and port pairs. This property is read only.
If the list contains no IP/host name and port pairs, it means connecting to the local host with the default port of MongoDB. For each pair in the list, the IP/host name cannot be null, while, the port can be null. When the port is null, it means connecting to the MongoDB by the default port. |
User | Specifies the user name for connecting to the database, which is determined by the database administrator.
Data type: String |