Actian Data Platform: Connectivity v2.0 (self-paced)

Actian Data Platform: Connectivity v2.0 (self-paced)

To harness the capabilities of an Actian Data Platform Warehouse and thoroughly explore the data it holds, business users must be able to connect to it through their familiar analytical applications. This course equips you with comprehensive knowledge on establishing connectivity for business users. This includes tasks such as managing a trusted list of IPs, creating user accounts, and configuring connection string parameters.

rate limit

Code not recognized.

About this course

Course Outcome:
You will have gained insight into the essential steps for integrating your preferred third-party applications with an Actian Data Platform Warehouse. While most third-party applications commonly use JDBC or ODBC for connection, the Actian Data Platform command line software is connected via our native data connection software. Security measures are implemented either through a Platform Warehouse username and password or via Single Sign-On (SSO) for Platform Warehouses provisioned on the Google Cloud Platform.
Course Style:
This course adopts a 'how-to' approach, offering a step-by-step guide on establishing connectivity to the Platform Warehouse.
Audience:
System or Database Administrators, Developers and Business users who have a requirement to connect to a corporate Platform Warehouse.
Prerequisites:
  • The course assumes the viewer has no knowledge of an Actian Data Platform Warehouse and how to connect to it.
Supplementary Resources:

Curriculum67 min

  • Course Objective
  • Objective
  • Connectivity - Security
  • Section Objective
  • Trusted list of Allowed IP for the Platform Warehouse 3 min
  • Warehouse native username and password
  • Platform Warehouse Create a Native User 6 min
  • Single Sign-On
  • Logging into the Platform using Google SSO 1 min
  • Connecting to a Platform Warehouse from DBeaver using JDBC and Google SSO Authentication 2 min
  • Connecting to the Platform from Excel using ODBC and Google SSO Authentication 3 min
  • Using Google SSO authentication with Device Flow 4 min
  • Connectivity - Data Drivers
  • Section Objective
  • Install the Actian Data Platform JDBC Data Driver for Windows 2 min
  • Install the Platform ODBC Data Driver for Windows 7 min
  • Install and connect the Linux CLI to the Platform 4 min
  • Install the 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 a Platform Warehouse 4 min
  • How To Connect Looker to a Platform Warehouse 3 min
  • Reinforce your knowledge!
  • Course Quiz! 10 min
  • Feedback
  • Take Course Survey 1 min

About this course

Course Outcome:
You will have gained insight into the essential steps for integrating your preferred third-party applications with an Actian Data Platform Warehouse. While most third-party applications commonly use JDBC or ODBC for connection, the Actian Data Platform command line software is connected via our native data connection software. Security measures are implemented either through a Platform Warehouse username and password or via Single Sign-On (SSO) for Platform Warehouses provisioned on the Google Cloud Platform.
Course Style:
This course adopts a 'how-to' approach, offering a step-by-step guide on establishing connectivity to the Platform Warehouse.
Audience:
System or Database Administrators, Developers and Business users who have a requirement to connect to a corporate Platform Warehouse.
Prerequisites:
  • The course assumes the viewer has no knowledge of an Actian Data Platform Warehouse and how to connect to it.
Supplementary Resources:

Curriculum67 min

  • Course Objective
  • Objective
  • Connectivity - Security
  • Section Objective
  • Trusted list of Allowed IP for the Platform Warehouse 3 min
  • Warehouse native username and password
  • Platform Warehouse Create a Native User 6 min
  • Single Sign-On
  • Logging into the Platform using Google SSO 1 min
  • Connecting to a Platform Warehouse from DBeaver using JDBC and Google SSO Authentication 2 min
  • Connecting to the Platform from Excel using ODBC and Google SSO Authentication 3 min
  • Using Google SSO authentication with Device Flow 4 min
  • Connectivity - Data Drivers
  • Section Objective
  • Install the Actian Data Platform JDBC Data Driver for Windows 2 min
  • Install the Platform ODBC Data Driver for Windows 7 min
  • Install and connect the Linux CLI to the Platform 4 min
  • Install the 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 a Platform Warehouse 4 min
  • How To Connect Looker to a Platform Warehouse 3 min
  • Reinforce your knowledge!
  • Course Quiz! 10 min
  • Feedback
  • Take Course Survey 1 min