QlikView

Connect to AnalyticDB for MySQL by using QlikView

1. On the host where QlikView is installed, navigate to Control Panel > System and Security > Administrative Tools > ODBC Data Sources (this path may vary depending on your operating system), create a new data source name (DSN), and select MySQL ODBC 5.xx Driver.

   

   Parameter	Description
   Data source name	A custom name for this data source.AnalyticDB for MySQL
   TCP/IP server	The endpoint of the AnalyticDB for MySQL cluster.
   Port	The port associated with the endpoint.
   User	The account that you created in the AnalyticDB for MySQL cluster. Valid values: privileged account standard account
   Password	The password for the account.

2. After configuring the parameters, click Test to verify the connection. If the test is successful, click OK to add the AnalyticDB for MySQL data source.

3. Open QlikView and select File > Edit Script. Select the data source name that you configured in Step 1 to test the connection.

   

   Note

   You can also run the ODBC CONNECT TO <DSN_NAME>; statement to test the connection.

4. After the connection test is successful, you can use SELECT statements to retrieve data from the database in your AnalyticDB for MySQL cluster.

   SELECT * FROM DATABASE_NAME.TABLE_NAME;

   For example, to retrieve data from the user_info table:

   SELECT * FROM adb_database.user_info;

   

Using QlikView

After retrieving data into QlikView, you can perform additional data operations. For more information, see the official QlikView documentation.