Configuring Connections in Aginity Pro

Aginity Pro allows you to set up connections to a variety of different database platforms. In order to do this, click the + symbol next to the “Connections” header in the left navigation pane of Aginity Pro. You will be presented with a list of existing connections, as well as options for adding another connection. Clicking the “New Connection” button will allow you to enter the necessary information for the connection you wish to create.

Adding a connection to |var_product_name|

Below is a quick start video of creating connections in Aginity Pro

Note

Aginity Pro uses JDBC to connect to database platforms. It is recommended you refer to the JDBC guides for our supported platforms to learn about specific variables to use within the Advance Parameters section of Aginity Pro. We will provide links to that documentation where available.

The video below provides a more detailed explanation of how to use advanced parameters to illicit the desired behavior and successful connection to the database platform.

Downloading Drivers

The first step in configuring a connection is to download the JDBC driver for the platform you will be using. In most cases, we will provide access to the drivers which have been certified to work with Aginity Pro. In some cases such as when the vendor does not allow us to distribute or you want to use a different version, you will have to manually add the JDBC driver.

The video below provides a quick illustration of how to manage drivers.

To get started, in the Edit or Add Connection box you will click on Edit Drivers as shown below

Getting to Driver

Automatic Download

As shown in the image below, if we are allowed to to download drivers you will be provided a link to do so and then be presented with one or more drivers to use and your done.

Editing Driver

In some cases you may get an error message if your organization does not allow you to download drivers (jar files) typically supplied through a Maven repository.

In this case please review the section below Manually Add Drivers.

Manually Add Drivers

If you have to manually add a driver it starts with first acquiring the JDBC jar for that platform and saving it somewhere on your machine. Once you acquire the JDBC jar you can upload it to Aginity Pro.

To do this you will hit the Edit Driver or Edit Drivers Panel section as shown above and you will be presented with the following screen.

Manual Driver

You can name the Driver anything you want and provide a description.

The class name if not provided must be looked up typically in the JDBC reference manual from the platform vendor.

Finally if you click on the Add File button you will navigate to where you saved the Jar file and then click Save Changes. You are now ready to configure your connection.

Setting up Netezza Connections

You can set up a connection to a Netezza (IBM PureData for Analytics) appliance here. Simply populate the requested data into the form.

Installing a Netezza connection

Note

Netezza does not allow us to distribute their drivers so you must obtain it from your DBA or directly from IBM Fix Central.

Using SSL with Netezza Connections

Aginity Pro supports SSL when setting up a Netezza connection. While setting up your Netezza connection simply select the level of security to enable from the dropdown selector. Your choices include:

  • Only Unsecured - Specify this option when you want an unsecured connection to the Netezza system. If the Netezza system requires a secured connection, the connection is rejected.

  • Preferred Unsecured - This argument is the default value. Specify this option when you would prefer an unsecured connection, but you accept a secured connection if the Netezza system requires one.

  • Preferred Secured - Specify this option when you want a secured connection to the Netezza system, but you accept an unsecured connection if the Netezza system is configured to use only unsecured connections.

  • Only Secured- Specify this option when you want a secured connection to the Netezza system. If the Netezza system accepts only unsecured connections, or if you are attempting to connect to a Netezza system that is running a release before release 4.5, the connection is rejected.

    See also

    For more information on SSL refer to the link Netezza SSL

Connection Timeout

The connection timeout will tell the session when to disconnect. Typically set this to 10 minutes or 3600 seconds.

Advanced Parameters

For Netezza you can supply additional JDBC parameters using the Advanced Properties section.

See also

Here is the link to other configurable parameters supported within Netezza JDBC’s driver

Setting up Redshift Connections

Installing a Redshift connection to |var_product_name|

Using SSL Mode with Redshift Connections

Aginity Pro supports SSL when setting up a Redshift connection. While setting up your Redshift connection simply select the level of security to enable from the dropdown selector. Your choices include:

  • Disable - SSL is disabled and the connection is not encrypted.
  • Prefer - SSL is used if the server supports it. Amazon Redshift supports SSL, so SSL is used when you set sslmode to prefer.
  • Allow - SSL is used if the server requires it.
  • Require - SSL is required.

See also

For more information on Redshift SSL refer to this link

Advanced Parameters

For Redshift you can supply additional JDBC parameters using the Advanced Properties section.

See also

Here is the link to other configurable parameters supported within Redshift JDBC’s driver

Setting up Snowflake Connections

You can set up a connection to a Snowflake here. Simply populate the requested data into the form.

Installing a Snowflake connection to |var_product_name|

Warehouse

A virtual warehouse, often referred to simply as a “warehouse”, is a cluster of compute resources in Snowflake. A warehouse provides the required resources, such as CPU, memory, and temporary storage, to perform the following operations in a Snowflake session. If you do not know which specific Warehouse to use speak to your Snowflake DBA.

Role

This is a security role that may have been setup for you to use. You can leave this field blank if you do not know what Role to connect as.

Advanced Parameters

For Snowflake most connection detail is handled through the command line additions to the JDBC URI. You can supply additional JDBC parameters using the Advanced Properties section.

See also

Here is the link to other configurable parameters supported within Snowflake JDBC’s driver

Setting up Hive Connections

You can set up a connection to a Hive databases here. Simply populate the requested data into the form.

Installing a Hive connection to |var_product_name|

Picking Subprotocol

You can choose either Hive 2 or Spark SQL syntax when executing against Hive databases. You can choose either value in this drop down.

Setting up Kerberos connections

In a lot of cases organizations require the use of Kerberos with Hive so by clicking on the radio button for Use Kerberos for authentication you will be prompted to enter the following:

  • Realm
  • FQDN
  • Service name

Note

The value of these parameters are typically set by your Hadoop administrator and it is best to work with them to obtain the appropriate values.

Advanced Parameters

You can supply additional Hive JDBC parameters using the Advanced Properties section.

See also

Here is the link to other configurable parameters supported within Hive JDBC’s driver

Setting up SQL Server Connections

You can set up a connection to Microsoft SQL Server databases here. Simply populate the requested data into the form.

Installing a MSSQL connection to |var_product_name|

Advanced Parameters

You can supply additional Hive JDBC parameters using the Advanced Properties section.

See also

Here is the link to other configurable parameters supported within SQL Server JDBC’s driver

Setting up Greenplum and Postgres Connections

You can set up a connection to Greenplum and Postgres databases here. Simply populate the requested data into the form. Greenplum and Postgres share the same drivers so we will speak of them together.

Installing a GP connection to |var_product_name|

Choosing Subprotocol (Only for Greenplum)

You can choose either generic Postgres or Pivotal Greenplum SQL syntax when executing against Greenplum databases. You can choose either value in this drop down.

Advanced Parameters

You can supply additional Postgres JDBC parameters using the Advanced Properties section.

See also

Here is the link to other configurable parameters supported within Postgres JDBC’s driver

Setting up Aginity Enterprise (AQE) Connections

You can set up a connection to Aginity Enterprise here. Simply populate the requested data into the form.

Note

In the host string for Aginity Enterprise connection use the Host name of the server appended with the /query-engine-jdbc suffix.

Installing an Aginity Enterprise connection to |var_product_name|