ODBC TUTORIAL

Getting started with the unified installer for Progress DataDirect ODBC drivers

Updated: 26 Feb 2021

Introduction

We are pleased to announce that the unified installer for installing Progress DataDirect ODBC drivers is now available for our OEM customers. The unified installer is our brand new installer for ODBC drivers that will allow you to install and brand mixed versions of ODBC drivers by only running it once.

Before the unified installer, if you had licenses to distribute multiple ODBC drivers, some of them 7.1 and others on 8.0 version, you had to perform multiple installations and specify brand information for each version or driver.The various installers would then install the drivers to various locations, each with their own license file. Also, for branding the drivers, you had to either brand the drivers individually during the installation or by using a branding tool post installation.


To unify the installation, branding and licensing process we are happy to introduce our unified Installer for a better experience. With the unified installer, let’s say you have license for Impala 7.1.4 and Redshift 8.0.1 drivers, you will be able to install Impala 7.1.4 & Redshift 8.0.1 drivers using the unified installer by just running it once. This will install all the drivers to one install location, with just one license file. And for branding, you can brand all the drivers at once during the installation process.

So, let’s see how you can use the unified installer to install and brand multiple ODBC drivers spanning different versions.

IMPORTANT

You will need to obtain key(s) that are compatible with the unified installer before you can use the unified installer.  Please fill out the update form, you will receive the key in approximately one business day.


Using the unified installer

  1. Launch the installer binary and it will show you the introduction panel. For the unified installer, the title of the installer will not include the version number.

     
    Introduction panel

  2. Click on Next on the introduction panel, this brings up License agreement panel (EULA). Read the License agreement and if you choose to accept, Click on Next.

     License agreement

  3. On the next panel, you must choose the installation directory. All the drivers will be installed to the same directory. If you notice the default installation directory, you will see that directory path will not include the version number anymore.

     
    Choose install location

  4. Provide the Control # you received from Progress in product registration panel and click on Validate button. After validating your Control #, if it is valid, you will be shown the list of drivers that are available to you.

     
    Choose the driver installation

    Note: The unified installer requires 8.x based Control #’s. With this, IPE keys of 7.x version will be considered as invalid Control #.

  5. After selecting the list of drivers on Product Registration panel, you want to install, Click on Next button
    Note: If you choose to install multiple versions of the same driver, you will be shown the below error. Choose only one version of each driver to continue installation

    choose one version

  6. On the Next Panel, you are given options for OEM installation types. Choose how you intend to Brand the drivers and click on Next.
    1. Branded
    2. Unbranded

      choose oem installation type

  7. Depending upon which option you choose in the OEM installation type, you will be shown below branding panels. First one, if you choose branded and the next one if you choose unbranded. Fill out the details as you require and click on Next.


    Branded option selected


    Unbranded option selected

     

  8. On the Next panel, if you want to create a default datasource in ODBC Administrator, select the option “Create a default Data Source” and click on Next.

    Create default datasource


  9. Finally, you will be shown the Pre-installation summary, review all the details and Click on Install. This is will begin the installation and you will be shown a success panel after installation has completed successfully.

    Pre installation summary


  10. This will begin the installation and will take some time to complete, based on the number of drivers you choose to install.

    installing drivers

  11. You will see the below panel after the installation has completed successfully.

    Install Complete

  12. To verify if all the drivers you have selected got properly installed, Open ODBC Administrator, and Click on Add to see all the drivers available to use. If you see the drivers you have chosen to install, the installation is a success.

    Check ODBC Administrator

The installation can also be performed in Console mode and Silent mode. You can easily regenerate packages for your application with the latest patch releases to the driver versions they ship using the Silent mode installation.

Supported Platforms and Limitations


  1. The unified installer is currently available on
    • AIX 32/64-bit
    • HP-UX IPF 32/64-bit
    • HP/UX PA-RISC 32-bit
    • Linux 32/64-bit
    • Solaris SPARC 32/64-bit
    • Solaris x86 32/64-bit
    • Windows 32/64-bit
  2. It is only for installing ODBC drivers, you cannot install ODBC and JDBC drivers using it.
  3. Drivers for XML, and some limited availability libraries are not included in the unified installer.

Feel free to contact Progress support if you have any questions or issues with the unified Installer.

Connect any application to any data source anywhere

Explore all DataDirect Connectors

Need additional help with your product?

Get Customer Support