Test theme
Actian Avalanche: Connectivity (self-paced)

Actian Avalanche: Connectivity (self-paced)

This course we will describe how to connect your favourite third party software tools to an Avalanche Warehouse

About this course

At the end of this course you will be able to:

Understand how to connect third party software to an Avalanche database.  The course goes through each step required to facilitate a successful connection.

 

Course Style:

This course breaks down and describes each component part required to successfully make a connection.  Additionally we include some of our how to content which provides specific information for commonly connected third party software.  At the end of the course is a course quiz to reinforce your learning.

Audience:

This course is aimed at Avalanche Warehouse administrators or Warehouse owners.

 

Prerequisites:

  • The course provides a number of activities:
    • You will require access to an Actian Avalanche Warehouse.  
    • There will be a requirement to install the Actian data driver software as required.
    • The course content is demonstrated from a Windows environment.

Curriculum100 min

  • Overview
  • Objectives 2 min
  • Connectivity
  • Overview 2 min
  • Connections Panel 2 min
  • Activity: Connections Panel 5 min
  • Connection Password 2 min
  • Allow List IP 1 min
  • Activity: Allow List IP 5 min
  • Firewall Port 1 min
  • ODBC - Client Runtime 1 min
  • Install ODBC Client Runtime for Windows 3 min
  • JDBC - Client Runtime 1 min
  • Install JDBC Client Runtime 1 min
  • Connect via CLI 9 min
  • Third Party Software 1 min
  • How to: Connect DBeaver SQL client to an Actian Avalanche Warehouse 3 min
  • Activity: Connect Third Party Software to your Avalanche Database 20 min
  • Supplementary Content
  • How to: Connect Looker to an Actian Avalanche Warehouse 2 min
  • How to: connect QLIK to an Actian Avalanche Warehouse 3 min
  • How to: Connect Tableau to an Actian Avalanche Warehouse 2 min
  • How to: Connect Power BI to an Actian Avalanche Warehouse 2 min
  • How To: Connect Actian DataConnect to an Avalanche Warehouse 5 min
  • How to: Install the Avalanche Client Runtime Software into an Apple Mac Environment 3 min
  • How to: Install the Avalanche Client Runtime Software into a Linux Environment 4 min
  • Reinforce your knowledge!
  • Course Quiz! 10 min
  • Feedback
  • Take Course Survey 1 min

About this course

At the end of this course you will be able to:

Understand how to connect third party software to an Avalanche database.  The course goes through each step required to facilitate a successful connection.

 

Course Style:

This course breaks down and describes each component part required to successfully make a connection.  Additionally we include some of our how to content which provides specific information for commonly connected third party software.  At the end of the course is a course quiz to reinforce your learning.

Audience:

This course is aimed at Avalanche Warehouse administrators or Warehouse owners.

 

Prerequisites:

  • The course provides a number of activities:
    • You will require access to an Actian Avalanche Warehouse.  
    • There will be a requirement to install the Actian data driver software as required.
    • The course content is demonstrated from a Windows environment.

Curriculum100 min

  • Overview
  • Objectives 2 min
  • Connectivity
  • Overview 2 min
  • Connections Panel 2 min
  • Activity: Connections Panel 5 min
  • Connection Password 2 min
  • Allow List IP 1 min
  • Activity: Allow List IP 5 min
  • Firewall Port 1 min
  • ODBC - Client Runtime 1 min
  • Install ODBC Client Runtime for Windows 3 min
  • JDBC - Client Runtime 1 min
  • Install JDBC Client Runtime 1 min
  • Connect via CLI 9 min
  • Third Party Software 1 min
  • How to: Connect DBeaver SQL client to an Actian Avalanche Warehouse 3 min
  • Activity: Connect Third Party Software to your Avalanche Database 20 min
  • Supplementary Content
  • How to: Connect Looker to an Actian Avalanche Warehouse 2 min
  • How to: connect QLIK to an Actian Avalanche Warehouse 3 min
  • How to: Connect Tableau to an Actian Avalanche Warehouse 2 min
  • How to: Connect Power BI to an Actian Avalanche Warehouse 2 min
  • How To: Connect Actian DataConnect to an Avalanche Warehouse 5 min
  • How to: Install the Avalanche Client Runtime Software into an Apple Mac Environment 3 min
  • How to: Install the Avalanche Client Runtime Software into a Linux Environment 4 min
  • Reinforce your knowledge!
  • Course Quiz! 10 min
  • Feedback
  • Take Course Survey 1 min