This section provides you with an overview of the steps required to install and set-up the driver. After completing this procedure, you will be able to begin accessing data with your application.

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. Open the Windows ODBC Administrator. The ODBC Administrator 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. Open the Snowflake Configuration Manager through the User DSN or System DSN tab.
    • 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 Configuration Manager in your browser.

      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 Configuration Manager.

    • 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 Configuration Manager in your browser.
    Note: Configuring data sources using the File DSN tab in the ODBC Administrator is not currently supported.
  5. In the Configuration Manager Connection tab, provide values for the following connection options; then, click Apply:

    For user ID and password authentication:

    • 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.
    • Account Name: Type the name of your account and the region where it is hosted. For example, my_account.us-east-1.
    • Database Name: Type the name of database to which you want to connect.
    • Password: Type the password that is used to connect to the Snowflake instance.
    • Schema: Type the schema for the specified database.
    • User: Type the user name that is used to connect to the Snowflake instance.
    • Warehouse: Type the name of the virtual warehouse.
    • Role Name: Type the role for access control in the Snowflake session initiated by the driver.
    Note: User and Password connection options can also be specified in the logon dialog box or passed by your application.
    Note: The driver supports a number of authentication methods. See Authentication for more information.
  6. Set the values for any additional connection options that you want to configure. To view more options, click on the tabs on the dialog. See the following resources for additional information on optional features and functionality:
    Note: For most connections, specifying the minimum required connection options is sufficient to begin accessing data; however, you can provide values for optional connection options to use additional supported features and improve performance.
  7. Click Test Connect to attempt to connect to the data source using the connection options.
  8. The logon dialog appears. If not already specified, update the following fields; then, click OK.
    • User: Type the user name that is used to connect to a Snowflake database. For example, jsmith.
    • Password: Type the password that is used to connect to the instance.
    Note: The information you enter in the logon dialog box during a test connect is not saved.
  9. If the test was successful, the window displays a confirmation message.
  10. Click Save to save the data source definition. The values you have specified are the defaults used when you connect to the data source. You can change these defaults by reopening the Configuration Manager to modify your data source, or you can override these defaults by connecting to the data source using a connection string with alternate values.
  11. Connect to your instance and 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, execute SQL statements, and practice using the ODBC API right out of the box.
    • Microsoft Excel: Excel is a spreadsheet tool that allows you to connect, view tables, and execute SQL statements against your data.
    • Connection option descriptions: 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.