facebooklinkedinrsstwitterBlogAsset 1PRDatasheetDatasheetAsset 1DownloadForumGuideLinkWebinarPRPresentationRoad MapVideofacebooklinkedinrsstwitterBlogAsset 1PRDatasheetDatasheetAsset 1DownloadForumGuideLinkWebinarPRPresentationRoad MapVideo
Actian Blog / Connecting to Actian Avalanche from Denodo via JDBC

Connecting to Actian Avalanche from Denodo via JDBC

Mountain Header2

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 whitelist your IP addresses in the Actian Avalanche console (Manage > Update Whitelist 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 theActian 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 

  1. 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.

Example:

2. Creating the Denodo Data Source 

Once the ODBC DSN is created, create a new Data Source by going to File > New > Data source… 

Select ODBC. 

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 

  1. Setting up the JDBC Driver 

If you made the decision to use JDBC, a prerequisite is to have theActian Avalanche JDBC driverdownloaded and available in the environment where the tools run.The JDBC Driver isavailable via theActianAvalanche consoleDrivers and Toolslink. 

 

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 locationcreate a new Denodo data source by going to File > New > Data source… 

Select JDBC. 

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).

Example:
jdbc:ingres://01c77d46010046ec7.vpaasstage.actiandatacloud.com:27839/db;encryption=on; 

Provide the user name (dbuser) and password.  

Now test the new data source to confirm that the connection is successful and that’s it! 

To learn more about Actian Avalanche, our fully managed cloud data warehouse service, visit https://www.actian.com/avalanche/. 

About Cris Ianculovici

Cristian Ianculovici is a Principal Support Engineer at Actian, with nearly 18 years of experience with Ingres and adjacent technologies, in the areas of Big Data and Hybrid Data as well as on the application side of these database technologies.