Actian Data Platform Architect: Data Drivers and Connections

Actian Data Platform Architect: Data Drivers and Connections

For the business to be able to leverage the power of an Actian Data Platform Warehouse and deep dive into the data contained within the Warehouse business users must be able to connect to it using their familiar analytical applications. In this course we provide all that you need to know to provide business users with the connectivity required, from maintaining the trusted list of IPs, user creation and connection string parameters.

rate limit

Code not recognized.

About this course

At the end of this course you will:
Learn about the requirements for connecting third-party applications to a Platform warehouse. Third-party applications are typically linked via JDBC or ODBC, but the Avalanche Command Line software is linked via our native data connection software. Security is provided either via an Avalanche Warehouse username and password or via SSO for Avalanche Warehouses provisioned on the Google Cloud Platform.
Course Style:
The content is broken up into numerous lessons, which you are able to navigate as you wish; however, the course is not considered complete until all content has been viewed at least once. Each lesson presents a specific topic in an informative and how-to  style.
Audience:
For architects who have a responsibility for designing solutions using the Actian Avalanche Platform.
Prerequisites:
The course assumes that you already have experience as a database/warehouse architect.
Resource Links:
Software Download: https://esd.actian.com/
Actian Community:  https://communities.actian.com
Documentation:  https://docs.actian.com/

Curriculum55 min

  • Course Objective
  • Objective
  • Connectivity - Data Drivers
  • Section Objective
  • Install the Actian Data Platform JDBC Data Driver for Windows 2 min
  • Install the Actian Data Platform ODBC Data Driver for Windows 7 min
  • Install and connect the Linux CLI to Actian Data Platform 4 min
  • Install and connect the Windows CLI to Actian Data Platform 3 min
  • Install the Actian Data Platform Data Driver for Apple MAC 5 min
  • Connectivity
  • Connections Panel 6 min
  • Activity: Connections Panel 5 min
  • Supplementary Content
  • Section Objective
  • How To Connect DBeaver to an Actian Data Platform 4 min
  • How To Connect Looker to an Actian Data Platform Warehouse 3 min
  • Connect Squirrel SQL to an Actian Data Platform Warehouse 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:
Learn about the requirements for connecting third-party applications to a Platform warehouse. Third-party applications are typically linked via JDBC or ODBC, but the Avalanche Command Line software is linked via our native data connection software. Security is provided either via an Avalanche Warehouse username and password or via SSO for Avalanche Warehouses provisioned on the Google Cloud Platform.
Course Style:
The content is broken up into numerous lessons, which you are able to navigate as you wish; however, the course is not considered complete until all content has been viewed at least once. Each lesson presents a specific topic in an informative and how-to  style.
Audience:
For architects who have a responsibility for designing solutions using the Actian Avalanche Platform.
Prerequisites:
The course assumes that you already have experience as a database/warehouse architect.
Resource Links:
Software Download: https://esd.actian.com/
Actian Community:  https://communities.actian.com
Documentation:  https://docs.actian.com/

Curriculum55 min

  • Course Objective
  • Objective
  • Connectivity - Data Drivers
  • Section Objective
  • Install the Actian Data Platform JDBC Data Driver for Windows 2 min
  • Install the Actian Data Platform ODBC Data Driver for Windows 7 min
  • Install and connect the Linux CLI to Actian Data Platform 4 min
  • Install and connect the Windows CLI to Actian Data Platform 3 min
  • Install the Actian Data Platform Data Driver for Apple MAC 5 min
  • Connectivity
  • Connections Panel 6 min
  • Activity: Connections Panel 5 min
  • Supplementary Content
  • Section Objective
  • How To Connect DBeaver to an Actian Data Platform 4 min
  • How To Connect Looker to an Actian Data Platform Warehouse 3 min
  • Connect Squirrel SQL to an Actian Data Platform Warehouse 4 min
  • Reinforce your knowledge!
  • Course Quiz! 10 min
  • Feedback
  • Take Course Survey 1 min