Admin: MarkLogic DB Configuration

This section describes how to create and configure a MarkLogic DB Data Source Name (DSN). Please follow the steps below: 

You may skip steps 1-4 if you have already installed the ODBC driver.

1. In a web browser, navigate to https://developer.marklogic.com/products/odbc/ to download the driver. 

2. In the download folder, double click mlsqlodbc-1.4-6-amd64.msi.

3. Follow the steps in the Installation Wizard to install the driver.

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

   

5. In the ODBC Data Source Administrator window, click the System DSN tab. 

6. Click the Add button to create the new Data Source.

7. Select MarkLogic SQL and click Finish. 

   

8. In the MarkLogic SQL ODBC Data Source Configuration Window, configure the following details: 

   • Data Source Name  

   • Database: the database name 

   • Server: the server name

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

   • Set SSL mode to ‘allow'

   • Username: the database username

   • Password: the database password

     

9. Click the Test Connection button. Once the connection has been made successfully, click the Save button to create the DSN.