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

Connecting to Actian Avalanche via JDBC

Mountain Mobile

Actian Avalanche delivers an operational data warehouse as a managed service in the cloud. Its developer-friendly high-performance analytics engine has been proven to outperform other popular analytics platforms without specialized hardware or complicated software development. Requires minimal setup, provides automatic tuning to reduce database administration effort and enables highly-responsive end-user BI reporting.

This is how to connect to Actian Avalanche from a few popular BI tools using the Actian Avalanche JDBC driver.

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.

Looker

Because Looker is a web-based tool, it already has the driver installed, so there is no need to download the driver.

This is how to connect from Looker to Actian Avalanche.

Login to your Looker Account.

If you have a Looker-hosted instance, you will need to whitelist the Looker IP addresses in your Actian Avalanche console (Manage > Update Whitelist IPs).

More information about the Looker IP addresses is available at Enabling Secure Database Access.

Go to Admin > Database > Connections.

Fill out the connection information ( from the Actian Avalanche console Manage > Connect):

• Select Vector for the Dialect.
• Enter the host and the JDBC port in the Host:Port fields.
• Type db for the Database.
• Enter you database username and password in the Username and Password fields.
• In the Additional Params field type encryption=on.

Example:

Click on Test These Settings to confirm that the connection works.

DBVisualizer

Setting up DB Visualizer to connect to Actian Avalanche can be done by following these steps:

1. Add the Actian Avalanche JDBC driver to DBVisualizer.

Go to Tools > Driver Manager…

Add a new driver by clicking on the plus sign (+). Provide a name for the new driver, e.g. Actian Avalanche Driver. Use the folder button to add the jar file (iijdbc.jar) from where it was downloaded and uncompressed.

Select the driver class from the Driver Class drop down box. It should be com.ingres.jdbc.IngresDriver.

Exit the Driver Manager window.

2. Create a new database connection

Click on Create new database connection.

In the wizard, select the newly created driver, then edit the user name, password, and URL.

The URL should be taken from your Actian Avalanche Data Cloud console (Manage > Connect).

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

Once the connection configuration is completed, the database is available for querying.

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.