QlikView Expressor: Create a Database Connection to MySQL Community Edition

    Originally published on 08-24-2011 10:49 PM

     

    Beginning with Expressor 3.4, the driver for the MySQL Community Edition RDBMS is no longer included with the product.  In order to use this database management system, you will need to download the appropriate MySQL driver.  Since expressor 3.x is a 32-bit application, be certain to download and install the 32-bit version of the driver even if your computer has a 64-bit operating system.  The supported version of this driver for Windows is mysql-connector-odbc-5.1.8-win32.msi or earlier version.

    Once the driver has been installed, you have the same two options for creating the database connection on Windows.

    1. Supply the driver properties when using the expressor Database Connection wizard to create the database connection.
    2. Use the Windows ODBC DSN Administrator to create an ODBC DSN, which you then use in the expressor Database Connection wizard.
      • Be certain to use the Start > All Programs > expressor > expressor3 > system tools > Data Sources (ODBC) menu item to open the ODBC DSN Administrator.  This insures that you open the 32-bit version of this utility even if your operating system is 64-bit.

    To create the database connection using option 1, start the Database Connection wizard and on the first screen select the ODBC drivers not supplied by expressor radio button.

    mysql1.png

    In the following screen, fill in the required driver properties.

    mysql2.png

    Click Next, and if you have entered everything correctly the wizard will move to the following screen where you supply a name for your connection.

    To create the database connection using option 2, use the Windows ODBC DSN Administrator to create and test a DSN using the MySQL Community Edition driver.  Then start the Database Connection wizard and and on the first screen select the Existing DSN radio button. In the following screen, select the existing DSN and provide credentials for a valid user of the database. Cick Next, and if you have entered valid credentials the wizard will move to the following screen where you supply a name for your connection.

    Regardless of which approach you use to create the database connection, you are now ready to connect to the database.