Follow the instructions below to connect Yellowfin to a Phoenix database.
Yellowfin does not ship with the driver required for this connection due to licensing/paywall reasons. You will need to manually upload the driver through the Plugin Manager or Creating a Basic Data Source Connection. |
1. Click on the Create button and choose the data source option.
2. Select Phoenix from the databases list.
3. When the New Connection popup appears, provide a name and description for your database.
4. Connection String: when selecting Connection String you have the same functionality as in Generic JDBC Data Source.
5. Phoenix configuration fields:
6. Authentication Adapter: Specify an authentication method for the database adapter. More details Advanced Connection Editor.
7. Include Schema in SQL: Select this checkbox to add the schema name when addressing database tables in SQL queries.
8. Database Host: Enter the single hostname of the server or a comma-separated Zookeeper Quorum.
9. Database Port: The TCP/IP port used for this connection.
10. Path: This field makes up part of the Phoenix connection string. Set your path to HBase root Znode. If you also have a Kerberos authentication system, then you should set the path to: hbase root znode \[:kerberos_principal [:path to kerberos keytab] ].
For further clarification on the Phoenix connection string, refer to this external guide: https://phoenix.apache.org/faq.html#What_is_the_Phoenix_JDBC_URL_syntax
11. JDBC Driver: The JDBC driver to talk to your Phoenix source.
12. Username: Enter the username of your database account.
13. Password: Provide the password of the above account.
14. Toggle Advanced Settings to see more settings.
15. Once you have completed your connection information, you will have several options: