AnalyticDB:QlikView

Connect to AnalyticDB for PostgreSQL by using QlikView

1. On the host where QlikView is installed, choose Control Panel > System and Security > Administrative Tools > ODBC Data Sources (the path may vary depending on the operating system), create a new DSN, and set Data Source to MySQL ODBC 5.xx Driver.

   Parameter	Description
   Data Source Name	The name of the database in the AnalyticDB for PostgreSQL cluster.
   TCP/IP Server	The endpoint used to connect to the AnalyticDB for PostgreSQL cluster.
   Port	The port number associated with the endpoint.
   User	The account created in the AnalyticDB for PostgreSQL cluster. Valid values: Privileged account. Standard account.
   Password	The password for the account.

2. After you configure the preceding parameters, click Test to test the connectivity. After the test is successful, click OK to add the AnalyticDB for PostgreSQL data source.

3. Open QlikView and choose File > Edit Script. Select the database name configured in Step 1 to test the connectivity.

   Note

   You can also run the ODBC CONNECT TO DATABASE_NAME; statement to test the connectivity.

4. After the connectivity test is successful, you can use a SELECT statement to retrieve data from the database in the AnalyticDB for PostgreSQL cluster.

   SELECT * FROM DATABASE_NAME.TABLE_NAME;

   For example, retrieve data from the user_info table.

   SELECT * FROM adb_database.user_info;

Use QlikView

After you retrieve data from the database, you can use QlikView to perform more data operations. For more information about how to use QlikView, see QlikView.