Testing connections and queries with the Configuration Manager
Note: The Configuration Manager is currently supported only on Windows platforms.
You can quickly test data sources, connection strings and queries using Progress DataDirect Dynamics 365 Configuration Manager.
To test your connection and query:
1. Open the Dynamics 365 Configuration Manager by selecting the ODBC Administrator from the Progress DataDirect group.
For detailed information on launching the Configuration Manager, see "Configuring data sources with the Configuration Manager."
2. If you are not testing an existing data source, provide connection information using one of the following methods:
Enter a connection string you provide by clicking the Edit button (
); then, pasting your string into the Connection String field. If you prefer, you can also type a string directly into this field.
Enter values of the connection options you want to configure into the corresponding fields. The Dynamics 365 Configuration Manager will generate a data source and connection string 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.
4. Provide connection option values for any fields required by your service.
5. Optionally, to execute a test query with the test connection, enter a SQL query into the Test Query field. For example:
SELECT * FROM INFORMATION_SCHEMA.SYSTEM_TABLES
6. Click Test Connect
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 Create Map (CreateMap) setting. For example, a delay may be incurred if Create Map is set to 4 (OnChange), the default, and changes have been made to the schema on the Dynamics 365 backend. For details, see "Create Map".
If successful, the window displays a confirmation message and, if a query was specified, the results of the query.
Enter a connection string you provide by clicking the Edit button (
); then, pasting your string into the Connection String field. If you prefer, you can also type a string directly into this field.