Zoomdata Version

Connecting to Apache Phoenix

Zoomdata is able to connect to Apache Phoenix v4.5 (HBase 1.1) only. This is because the Phoenix driver is not backwards compatible  with earlier versions. Zoomdata does not provide data connectors to earlier versions of Phoenix.

To configure the connector, perform the following steps:

  1. Log into Zoomdata.
    Administrators and users with appropriate access privileges can connect data sources in Zoomdata.
  2. Click the Sources menu item.

Figure 1

  1. Click the Apache Phoenix connector icon.
  2. Specify the name of your source and add a description (if desired).

Figure 2

  1. Click Next .

Figure 3

  1. On the Connection page, define the connection source. You can use an existing connection, if available, or create a new one. To create a new connection, select the Input New Credentials option button and specify a connection name, JDBC URL, user name, and password. Click Validate . Once validated, the connection is saved. Click Next .
  2. On the Tables page, select a schema and a table for your charts from the Phoenix Objects list. If you want to include or exclude specific fields, select the corresponding checkboxes.

Figure 4

You can also run a custom SQL query to select the required objects. Click Custom SQL and type the SQL query in the Custom SQL section.
Click Preview . The returned results will be displayed in the Preview section.

Caveats for using Custom SQL in Phoenix:
* Due to the structure of Phoenix sources, Zoomdata recommends using aliases in your queries for this connection.
* Not all statements are handled by Phoenix, for example, GROUP BY and HAVING.
* Subqueries are not handled.
Zoomdata will wrap your SQL query into a SELECT statement. If specific statements inside the wrapped query are not supported by your data source, the query will not be executed.
  1. On the Fields page, create unique label names for the available fields in your data source. These labels will be displayed in the charts. Specify the required name in the Label field. If necessary, change the Type and Default options. Select the checkboxes in the Distinct Count column to enable this option. Configure Filter Display settings for the required fields.
    Click Next to continue.

Figure 5

  1. On the Refresh page, you can schedule asynchronous jobs to refresh fields in your data source. Refer to Using the Zoomdata Scheduler article for more information.
  2. On the Charts page, you can:
  • Edit Global Default Settings
  • Select the Standard and, if available, Custom chart styles to be used with the data source
  • Set default parameters  (group-bys, colors, sorting, etc.) for each chart style
Learn more about how to customize a chart .

Figure 6

  1. Click Finish to save your changes.