Advanced Connection Properties

Aginity Pro provides the ability to supplement the base connection information with advanced properties. Using these advanced properties allow you to create a JDBC connection string compatible with your own environment. This may be useful if your organization secures database connections using SSL and or Knox gateways. 

**NOTE: It is best to ask your DBAs or data platform administrator for the correct properties and values for your specific database connections.**

Hive

  • The connection string properties and values in the article here are accepted advanced properties for Hive. These properties and values are the same ones used to connect to your Hiveserver2 using beeline. 
  • An example of Hive advanced properties can be seen below:

Screen_Shot_2019-05-07_at_1.48.09_PM.png

 

IBM PureData System for Analytics (Netezza)

  • The connection string properties and values in the article here are accepted advanced properties for IBM PureData System for Analytics (Netezza).
  • An example of IBM PDSA advanced properties can be seen below:

 

Redshift

  • The connection string properties and values in the article here are accepted advanced properties for Amazon Redshift.
  • An example of Redshift advanced properties can be seen below:

 

Snowflake

  • The connection string properties and values in the article here are accepted advanced properties for Snowflake.
  • An example of Snowflake advanced properties can be seen below:

Note:  Recently we released a feature that allows you to copy the JDBC connection string to help debug JDBC connectivity issues.  Refer to this Knowledge Base article.

 

 

Was this article helpful?
0 out of 0 found this helpful
Have more questions? Submit a request

Comments

0 comments

Please sign in to leave a comment.