---
title: "Phoenix"
canonical: "https://wiki.yellowfinbi.com/space/yfcurrent/2196029/Phoenix"
format: markdown
---
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](https://yellowfin.atlassian.net/wiki/display/yfcurrent/Plugin+Management) or [Creating a Basic Data Source Connection.](https://yellowfin.atlassian.net/wiki/display/yfcurrent/Creating+a+Basic+Data+Source+Connection)

1. Click on the **Create** button and choose the data source option.  
> Macro (inline-media-image)

  
<span style="color: #000000">2. Select </span>**<span style="color: #000000">Phoenix</span>****<span style="color: #000000"> </span>**<span style="color: #000000">from the databases list.</span>  
> Macro (inline-media-image)

  
3. When the New Connection popup appears, provide a name and description for your database.  
<span style="color: #000000">4. </span>**<span style="color: #000000">Connection String: </span>**<span style="color: #000000">when selecting Connection String you have the same functionality as in </span>[<span style="color: #000000">Generic JDBC Data Source</span>](https://yellowfin.atlassian.net/wiki/display/yfcurrent/Generic+JDBC+Data+Source)**<span style="color: #000000">.</span>**  
> Macro (inline-media-image)

  
<span style="color: #000000">5. </span>**<span style="color: #000000">Phoenix</span>**<span style="color: #000000"> configuration fields:</span>  
> Macro (inline-media-image)

  
**<span style="color: #000000">6. Authentication Adapter: </span>**<span style="color: #000000">Specify an authentication method for the database adapter. More details </span>[<span style="color: #000000">Advanced Connection Editor</span>](https://yellowfin.atlassian.net/wiki/display/yfcurrent/Understanding+Connection+Parameters#UnderstandingConnectionParameters-AdvancedConnectionEditor)<span style="color: #000000">.</span>  
**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.   
> Macro (inline-media-image)



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](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.   
> Macro (inline-media-image)

  
**12. Username:** Enter the username of your database account.  
**13. Password:** Provide the password of the above account.  
<span style="color: #000000">14. Toggle Advanced Settings to see more settings. </span>  
> Macro (inline-media-image)

  
15. Once you have completed your connection information, you will have several options:  
  
> Macro (inline-media-image)



> Macro (legacy-content)