DigDash Enterprise allows you to retrieve information from NoSQL databases. Currently, only MongoDB is supported.

To connect to a SQL database :

1. In the Create a new data model box, click the NoSQL button in the Database section.
   
   ➡ The NoSQL dialog box is displayed.
   
2. Select the desired connection mode:

•  Manual connection mode
  The connection will be visible in the data source only.
  1. The MongoDB solution is selected by default
  2. In the Server field, enter the address of the MongoDB database in the form :
     [user:password@]host1[:port1][,host2[:port2],...[,hostN[:portN]]][/[AuthentificationBase]... (the default port number is 27017).
     It is not mandatory to enter the user name and password in plain text in the URL. These can be entered in the fields below.
  3. In the Database field, enter the name of the database.
  4. In the User field, enter the name of the user to be used when connecting to the database.
  5. In the Password field, enter the password to be used when connecting to the database.
      
• Named connection mode
  The connection will be visible in the connection manager and can be used by all data sources.
  1. Click Select: the Database Connection Manager is displayed.
  2. You can :
     • Select an existing connection from the list. Click OK.
     • Create a new connection as described on the Add a connection named.

3. In the Restrictive clause field, enter the SQL query manually as described below.
4. Click on the Preview button to display a preview of the result.
   See the page  Preview page page for more details on column properties.

5. You can also add data transformations. See the Transform data page for more details.
6. Once you are satisfied with the result, click Next to configure the data model.

Writing the NoSQL query

There is currently only a manual mode for writing your NoSQL query.

In the Restrictive clause section :

1. Select the Name of the collection to request. Click Get collections to refresh the list of collections.
2. In the Query field, enter the restrictive clause for your query, for example : { "field1": "value_a", "field2": "value_b" }. You do not need to enter the beginning of the db.name.find(..) command, just the restrictive clause.
3. In the Projection field, you can enter the fields to be projected in order to specify the fields to be returned. For example, { "champ1": 1}.
4. In the Sort field, you can enter a parameter to sort the results. For example, , { "field": 1}.
5. Enter a Maximum number of rows if you wish to restrict the number of results.