You can quickly test a connection string and queries using Progress DataDirect Dynamics 365 Configuration Manager.

To test your connection and query:

  1. Open the Dynamics 365 Configuration Manager by double-clicking on the driver jar file. Or, in a command line, navigate to the directory containing your driver jar file; then, execute the following command: 
    java -jar dynamics365.jar

    The Dynamics 365 Configuration Manager opens in your default web browser.

  2. Provide a connection string to test using one of the following methods:
    • Entering a string: Click the Edit button (); then, paste your string into the Connection String field. If you prefer, you can also type a string directly into this field.
    • Generating a string: Provide values of the connection properties you want to configure into the corresponding fields. The Dynamics 365 Configuration Manager will generate a string in the Connection String field based on the values you specify.
  3. Click Test Connect to attempt to connect to the service using the string specified in the Connection String field. The Test Connection window appears.
    Important: An initial connection may take a few minutes, depending on network speeds and the amount of metadata the driver must retrieve from the service. Similar delays may occur depending on the CreateMap setting. For example, a delay may be incurred if CreateMap is set to OnChange and changes have been made to Dynamics 365 native data. For details, see CreateMap.
  4. Provide connection property values for any fields required by your service.
  5. To execute a test query with the test connection, enter a SQL query into the Test Query field. For example: 
    SELECT * FROM ACCOUNTS
  6. Click Execute.
    If successful, the window displays a confirmation message and, if a query was specified, the results of the query.