How to Install the Necessary Drivers for Aginity Workbench for dashDB

The following post assumes the following prerequisites have been satisfied:

A) Access to a dashDB server

B) Access to the dashDB web console 

C) A client machine running the 64-bit version of Windows.

D) Be able to log into Windows as a local administrator or provide the credentials of a member of the local Administrators group.

Per IBM, the dashDB driver package contains several drivers. For example, Excel connects to the database by using the ODBC driver. Other drivers include CLI, JDBC, CLPPlus, .NET (Windows only), OLE DB (Windows only), PHP, Perl, Python, Node.js, Ruby, and more. 

The Aginity Workbench for dashDB software uses a managed .net data provider to connect to a dashDB server.  The data provider uses CLI, which is a core component of IBM software; therefore both the IBM Data Server Driver for ODBC and CLI package must be installed.

 

How to install the IBM Data Server Driver for ODBC and CLI driver package:

1) In your favorite web browser open the IBM dashDB web console.

2) Under the Setup tab on the left side of the page choose Connect Applications.

3) Download Driver package for Windows 64-bit (92.6 MB)

IBM_DashDB_driver_package.png 

 

4) Install the .exe file AS ADMINISTRATORThis can be done by right-clicking the driver executable and choosing “Run As Administrator”.  Choosing default install locations works well.

 RunAsAdministrator.png

 

5) After installation of the driver completes, it is highly recommended to reboot the Windows machine.

6) Open the Windows ODBC Data Source Administrator Console in Windows and verify the IBM DB2 ODBC DRIVER and IBM DB2 ODBC DRIVER-IBMDBCL1 drivers have been installed properly. 

This can be done by opening the Windows Control Panel -> Administrative Tools -> Data Sources (ODBC)

 ODBC.png 

 **NOTE** Failure to install As Administrator may lead to a partial install of the driver package.  If this happens, you will likely see the IBM DB2 ODBC DRIVER - IBMDBCL1 driver.  If this occurs, uninstall the driver package and reinstall AS ADMINISTRATOR.  To uninstall you can use the Windows uninstaller.

Start -> Control Panel-> Programs and Features

Highlight the program called "IBM Data Server Package - IBMDBCL1" and click Uninstall.

Screen_Shot_2015-03-04_at_4.52.50_PM.png

 

7) After the IBM Data Server Driver for ODBC and CLI has been verified as installed, open the Aginity Workbench for dashDB and connect to the dashDB using the dashDB server address and login credentials supplied to you by your organization.

 

NOTE:  If installing of 64 bit ODBC driver on Windows 7 fails without error (it displays a progress bar in a window that says "Extracting", and then closes without installing ODBC driver and no error messages are reported) :

See the IBM Technote here:  http://www-01.ibm.com/support/docview.wss?uid=swg21700340

For more information please refer to the Aginity Workbench for dashDB documentation:  https://www.aginity.com/documentation/wb/dashDB

Have more questions? Submit a request

2 Comments

  • 0
    Avatar
    Ray Canuel

    This is very useful.  Aginity-->nonSSL-->DashDB is working nicely.

    It seems challenging to get the SSL connection to work.   I check the SSL connection and it fails.  Error 42724.    I have copied and even created a new connection with SSL checked.  Same failure.  It seems Aginity does not connect to the DSN created within Control Panel.  I have that working for SSL.

     

    My steps:

    1)      Login to dashdb.  Go to Connect.  Download the SSL certificate

    2)      From the file manager, open the ssl certificate.  Choose all defaults.

    3)      Edit the dashdb_configure.bat script with notepad.

    4)      Find/replace 50000  to 50001 everywhere.

    5)      Save as dashdb_configure_SSL.bat

    6)      dashdb_configure_SSL.bat <hostname from dashdb connect page>

    7)      Go back to Control panel-->ODBC-->dashdb-->Configure <Advanced tab> Add “security” = ssl.

    8)      Test connection.  SUCCESS.

  • 0
    Avatar
    Dan Gasperut

    One note for this, if you are not an admin you probably don't have Setup in your dash db menu. The drivers are available under the Connect > Download Tools option as well. 

Please sign in to leave a comment.
Powered by Zendesk