Goal
This document describes how to access MongoDB from the Denodo Platform.
Content
MongoDB is an open source NoSQL database that uses a document-oriented database model which supports various forms of data. Instead of using tables and rows as in relational databases, the MongoDB architecture is made up of collections and documents. It provides high performance, high availability, and automatic scaling
The Denodo MongoDB adapter is included in the Denodo MongoDB database using the collections as a data source for Virtual DataPort.
Note: For Denodo versions previous to Denodo 9, MongoDB is not included as an integrated data source and the MongoDB Custom Wrapper component has to be downloaded from the Denodo Support Site for the respective Denodo version.
Connecting to MongoDB from the Denodo Platform
Creating a Data Source
- From the Denodo Web Design Studio, create a new data source by selecting “File > New > Data source”.
- Search in the window “mongo” and then select the MongoDB adapter\
- This will create a new data source.
- Specify the input parameters of the data source with the Connection parameters option:
- Host: Name of the computer or IP address where MongoDB is running, default is
127.0.0.1.
- Port: Port number to connect to MongoDB, default is 27017.
- Specify the input parameters of the data source MongoDB URI
- Connection String: this parameter allows more options in the connection between the driver and mongodb. This is the pattern:
[mongodb://]host1[:port1][,host2[:port2],...[,hostN[:portN]]]/database[?
Options]
The prefix mongodb:// is optional, the database is mandatory and user and password are not written in this field, but in the User and Password Parameters.
- Input parameters for both options:
- Uses TLS: This provides three options: None, TLS, or Mutual (two-way TLS). Mutual (two-way TLS) allows you to provide certificate information.
- Authentication: This dropdown gives several forms of authentication.
- Click on “Save”.
Authenticate against a different database
In MongoDB, it is possible to authenticate against a database but read the data from a different one. When the authentication is done in a different database, you have to add the option authsource in the Connection String parameter.
More details about authsource can be found in the Connection Options of the Connection String URI here.
Creating a Base view
Once the data source is created, create base views for that particular source. In order to do that click on the "Create Base View" option.
- Click the + sign next to the database that contains information you are wanting.
- Select the collection with the information
- Click “Create Base View”
- Creation of the base view can take a long time.
- Select the columns you want to include in the base view
- Click ‘Ok’ to create a base view.
The below image is an example of a created base view over the MongoDB datasource.
- Now, the base view is ready for the execution and to be combined with the rest of the sources.
The information provided in the Denodo Knowledge Base is intended to assist our users in advanced uses of Denodo. Please note that the results from the application of processes and configurations detailed in these documents may vary depending on your specific environment. Use them at your own discretion.
For an official guide of supported features, please refer to the User Manuals. For questions on critical systems or complex environments we recommend you to contact your Denodo Customer Success Manager.
Recommended resources Recommendations generated by AI
Questions
