Admin: MongoDB (SQL) Configuration

This section describes how to create and configure a MongoDB (SQL) Data Source Name (DSN). Please follow the steps below.  Please note that you may skip steps 1 – 4 if you have already installed the ODBC driver. 

1. In a web browser, navigate tohttps://www.progress.com/products/datasources/mongodb https://www.progress.com/odbc/mongodb to download the driver.  2. In the download folder, locate the PROGRESS_DATADIRECT_ODBC_MONGODB_WIN_64.zip file and extract its contents. 

3. Within the extracted folder, double click the PROGRESS_DATADIRECT_ODBC_8.0_WIN_64_INSTALL.exe file. 

4. In the DataDirect for ODBC 8.0 – 64 bit Window, click Next and follow the required steps to install the driver. 

   

5. Once you have successfully installed the ODBC driver, go to Control Panel\System and Security\Administrative Tools and click ODBC Data Sources (64-bit).

6. In the ODBC Data Source Administrator Window, click the System DSN tab. 

   

7. Click the Add… button to create a new Data Source.  

8. Find and select DataDirect 8.0 MongoDB and click Finish. 

   

9. In the ODBC MongoDB Driver Setup Window, configure the following details: 

   • Data Source Name 

   • Host Name: the MongoDB host server (IP address or a server name). 

   • Port Number: the MongoDB server port number. Only numerical values are accepted. The default port number is 27017. 

   • Database: the MongoDB database name. 

   • Schema Definition Path: specifies the name and location of the configuration file where the relational map of native data is written. 

     

10. For more information about the Schema Tool, go to C:\Program Files\Progress\DataDirect\ODBC_80\help\SchemaToolHelp and click schematoolhelp. 

    

11. Click the Advanced tab and make sure the Read Only option is not selected. 

    

12. Click the Test Connect button. Once the connection has been made successfully, click the OK button to create the DSN.