AnalyticDB:QlikView

Prerequisites

Before you begin, make sure you have:

• MySQL Connector/ODBC installed — Use version 3.5.1 or 5.3.

• QlikView 11.20.x installed — Download from the Qlik official site.

• Your cluster connection details — Have the cluster endpoint, port, and a privileged account or standard account with its password ready. Find these in the AnalyticDB for MySQL console.

Step 1: Configure an ODBC data source

1. Open the ODBC Data Source Administrator:

   • Go to Control Panel > System and Security > Administrative Tools > ODBC Data Sources.

2. In the ODBC Data Source Administrator dialog box, click Add to add a system DSN, then select MySQL ODBC 5.xx Driver as the driver.

3. Fill in the connection parameters:

   Parameter	Description
   Data Source Name	The name of the database in the AnalyticDB for MySQL cluster.
   TCP/IP Server	The endpoint of the AnalyticDB for MySQL cluster.
   Port	The port number of the cluster endpoint.
   User	The account used to connect. Use a privileged account or a standard account.
   Password	The password of the account.

   

4. Click Test to verify the connection.

5. Click OK to save the DSN.

Step 2: Load data in QlikView

1. Open QlikView and go to File > Edit Script.

2. Select the database name configured in Step 1 to connect to the cluster. Alternatively, run the following statement in the script editor:

   ODBC CONNECT TO DATABASE_NAME;

3. After the connection is established, use a SELECT statement to load data from the cluster:

   SELECT * FROM DATABASE_NAME.TABLE_NAME;

   For example, to load data from the user_info table in the adb_database database:

   SELECT * FROM adb_database.user_info;

   

What's next

With your data loaded in QlikView, build charts, dashboards, and reports. For more information on QlikView features, see the QlikView product documentation.