Before you begin: You will need a Model file before beginning this procedure. You can get one from an administrator or by creating your own (see Getting started creating a Model file). If you are connecting to a publicly available REST service, you can also use a pre-built Model file (see Getting started using prebuilt Model files (Windows)).

This section provides you with an overview of the steps required to install, set-up, and begin accessing data using Model files created by you or an administrator.

To begin accessing data with the driver:

  1. Install the driver:
    1. After downloading the product, unzip the installer files to a temporary directory.
    2. From the installer directory, run the appropriate installer file to start the installer. The installer file takes the following form:

      PROGRESS_DATADIRECT_ODBC_nn_WIN_xx_INSTALL.exe

    3. Follow the prompts to complete installation.
    Note:

    The installer program supports multiple installation methods, including command-line and silent installations. For detailed instructions, refer to the Progress DataDirect for ODBC Drivers Installation Guide.

  2. Before you can use your driver, you must set the PATH environment variable to include the path of the jvm.dll file of your Java™ Virtual Machine (JVM).
  3. To configure the driver using the ODBC Administrator (GUI), start the ODBC Administrator from the Progress DataDirect program group. The GUI dialog allows you to configure the data source definitions in the Windows Registry or generate connection strings.
    Note: The Windows driver also supports using connection strings to connect to your service. For more information, see "Using a connection string."
  4. Select either the User DSN, System DSN, or File DSN tab to display a list of data sources.
    • User DSN: If you installed a default DataDirect ODBC user data source as part of the installation, select the appropriate data source name and click Configure to display the driver Setup dialog box.

      If you are configuring a new user data source, click Add to display a list of installed drivers. Select your driver and click Finish to display the driver Setup dialog box.

    • System DSN: To configure a new system data source, click Add to display a list of installed drivers. Select your driver and click Finish to display the driver Setup dialog box.
  5. The Connection tab of the Configuration Manager opens.

    Hub window for the Configuration Manager of the Autonomous REST Connector

    Provide values for the following fields:
    • Data Source Name: Type a string that identifies this data source configuration, such as Projects.
    • Description: Type an optional long description of a data source name, such as My Development Projects.
    • Host Name: Optionally, set this option to specify the host name portion of the HTTP endpoint to which you send requests. For example, a Jira endpoint would take the following form: https://mycompany.atlassian.net.
      Note: This value will be provided by the Model for data sources that have static host names.
    • Port Number: Optionally, specify the TCP port of the server that is listening for REST API requests.
    • REST Config File: Enter the name and location of your Model file. For example, C:\path\to\myrest.rest.
  6. From the Authentication Method drop-down, select the authentication method used to connect to your data source. The properties related to the selected method are exposed. See Authentication for more information on supported methods.
  7. Provide values for the exposed authentication fields that apply to your connection. Note that some of the fields may not apply to your data source. Refer to the documentation for your REST service for details.
  8. Set the values for any optional properties that you want to configure. For additional information on optional features and functionality, see the following resources:
    • Connection URL examples provides connection string examples that can be used to configure common functionality and features. You can modify and combine these examples to create a string that best suites your environment.
    • Connection property descriptions provides a complete list of supported properties by functionality.
  9. To test your configuration:
    1. Click Test Connect.
    2. In the Test Query field, specify a query that you would like to test.
      Note: The default query returns only a list of the tables defined in the Model file. This list is generated by the driver's internal SQL Engine. To authenticate to the REST service, specify a simple SELECT statement using of the table from the results.
    3. Click Execute.
    If successful, the driver will return results from a test query.
  10. Click Save to save your data source.
    Note: As you provide values for properties, the Configuration Manager generates an ODBC connection string for use by your application. To use your string, click the Copy button () and paste the string to a location that can be used by your application.
  11. Begin accessing data with your applications, BI tools, database tools, and more. To help you get started, the following resources guide you through accessing data with some common tools:
    • Example Application: The example application allows you to test connect and execute SQL statements right out of the box.
    • Power BI: Power BI is a business intelligence software program that allows you to generate analytics and visualized representations of your data.
    • Tableau: Tableau is a business intelligence software program that allows you to easily create reports and visualized representations of your data.
    • Microsoft Excel: Excel is a spreadsheet tool that allows you to connect, view tables, and execute SQL statements against your data.
    • Supported SQL statements and extensions: This section describes the syntax used for SQL statements supported by the driver. You can modify and use the provided examples for your application or tool.

This completes the deployment of the driver.