AnalyticDB:QlikView

Use QlikView to connect to an AnalyticDB for MySQL cluster

1. On the host where QlikView is installed, choose Control Panel > System and Security > Administrative Tools > ODBC Data Sources. This path may vary with the operating system. In the ODBC Data Source Administrator dialog box that appears, add a system data source name (DSN) and select MySQL ODBC 5.xx Driver as the data source.
   

   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 to which you want to connect.
   Port	The port number of the AnalyticDB for MySQL cluster endpoint.
   User	The account used to connect to the AnalyticDB for MySQL cluster. You can use one of the following account types: Privileged account Standard account
   Password	The password of the account used to connect to the AnalyticDB for MySQL cluster.

2. After you configure the preceding parameters, click Test to test the connectivity. After the connection passes the test, click OK to connect to the AnalyticDB for MySQL database.
3. Start QlikView and choose File > Edit Script. Select the database name specified in Step 1 to test the connectivity.
   Note You can also execute the ODBC CONNECT TO DATABASE_NAME; statement to test the connectivity.
4. After the database passes the connectivity test, use the following SELECT statement to obtain data from the AnalyticDB for MySQL cluster:

   SELECT * FROM DATABASE_NAME.TABLE_NAME;

   For example, use the following statement to obtain data from the user_info table:

   SELECT * FROM adb_database.user_info;

   

Use QlikView

After you obtain data from AnalyticDB for MySQL databases, you can use QlikView to perform more operations. For more information about how to use QlikView, visit QlikView.