Actian Avalanche is the world’s fastest analytic data warehouse delivered as Software as a Service (SaaS). It has been designed for simplicity and doesn’t require any complex tuning to deliver consistent real-time performance for even the most challenging queries.
Actian Avalanche is standards based, supporting the latest SQL, ODBC and JDBC standards, which enables it to easily fit into any existing data eco-system.
This post shows how to connect to Actian Avalanche from Denodo, using either the Actian Avalanche ODBC or JDBC driver.
If you have not done so already, you will need to put your IP addresses on the Allow List in the Actian Avalanche console (Manage > Update Allow List IPs).
If this is the first time you are attempting to connect to Actian Avalanche and you have not set password, you must do that in the Actian Avalanche Console (Manage > Set Connection Password).
Here is how to create a database connection from Denodo to Actian Avalanche.
First, start Denodo Virtual DataPort Server from the Denodo Platform Control Center.
The connection can be defined using either of the following two methods:
Method 1: ODBC Connectivity
- Setting up the ODBC DSN
If not already done, create an ODBC DSN in the Windows ODBC Data Source Administrator.
In the Windows menu, go to Actian Client Runtime > Client Runtime CR 64-bit ODBC Data Source Administrator.
Create a System Data Source Name (DSN) to connect to your Actian Avalanche cluster. For example, you can name it “Actian Avalanche DB”.
Take the Host Name and Listen Address from the Actian Avalanche Console Manage > Connect – Generic Connection Settings.
The Host Name value is the Host value and the Listen Address value is the ODBC port. For the Database, type db.
2. Creating the Denodo Data Source
Once the ODBC DSN is created, create a new Data Source by going to File > New > Data source…
Provide a name for the database connection, e.g. avalanchedb.
Select Generic for the Database adapter.
Select DSN for the Connection type.
Select the Actian Avalanche DSN you created to connect to your instance of Actian Avalanche.
Enter your user name (dbuser) and password.
Click Save to save your data source.
Method 2: JDBC Connectivity
- Setting up the JDBC Driver
If you made the decision to use JDBC, a prerequisite is to have the Actian Avalanche JDBC driver downloaded and available in the environment where the tools run. The JDBC Driver is available via the Actian Avalanche console Drivers and Tools link.
Extract the downloaded JDBC package and place the extracted directory in the C:DenodoDenodoPlatform7.0libextensionsjdbc-drivers directory (where Denodo is installed) or in a directory you desire.
2. Creating the Denodo Data Source
After the JDBC driver has been placed in the expected location, create a new Denodo data source by going to File > New > Data source…
Provide a name for the database connection, e.g. AvalancheDB_JDBC.
Select Generic for the database adapter and Native (JDBC) for the type of access.
In the Driver class path field select the directory where the Actian Avalanche JDBC driver (iijdbc.jar) resides, by clicking on the Browse button.
For the driver class, type com.ingres.jdbc.IngresDriver.
Specify the JDBC Database URL, which is provided in the Actian Avalanche Data Cloud console (Manage > Connect).
Provide the user name (dbuser) and password.
Now test the new data source to confirm that the connection is successful and that’s it!