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.
Below is a quick start video of creating connections in Aginity Pro (video will be added soon)
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 elicit the desired behavior and successful connection to the database platform. (video will be added soon)
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. (video will be added soon)
Database Driver Reference Guide (link will be added soon)
To get started, in the Edit or Add Connection box you will click on Edit Drivers as shown below
As shown in the image below, if we are allowed to download drivers you will be provided a link to do so and then be presented with one or more drivers to use and you're done.
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.
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.