ADS Essentials

Agile Data Warehouse Service (ADS) Essentials

Summary

This course introduces the GoodData Agile Data Warehouse Service, which can be used to store staging data required by data loading (ETL) processes as well as building a complete data warehouse solution that is capable of feeding data to the GoodData Business Intelligence Platform. Practical hands-on exercises are included to walk participants through creating ADS instances, connecting to ADS from SQL Clients and CloudConnect, creating ADS data structures, loading data into ADS, and extracting data from ADS for loading into GoodData projects using both CloudConnect and the GoodData Automated Data Distribution (ADD) feature. By the end of the course, participants will be able to implement ADS for their GoodData projects.

Duration: 4 hours

If you would like to enroll in this course, please contact training@gooddata.com or your account manager to schedule a time.

 

Duration

4 hours

Audience

Engineers responsible for loading data into GoodData

Prerequisites

  • Introduction to Data Modeling and ETL course
  • ETL Essentials course
  • Data Modeling Advanced course
  • A basic understanding of SQL (Ability to create tables, select data and perform simple updates)
  • CloudConnect Designer installed on your computer system
  • DBVisualizer installed on your computer system
  • GoodData JDBC Driver installed on your computer system (simply unzip the downloaded zip file into a convenient folder)

Outline

  • Overview of ADS
  • ADS Management
  • Getting Started with ADS
    • Accessing ADS Using an SQL Client
    • Accessing ADS Using CloudConnect
  • Data Loading Methods (Copy versus Merge)
  • Extracting Data from ADS
  • Hands-on Exercises (spread throughout the course)
  • Certification Test Module (for those seeking GoodData Certification)

Upcoming Classes

No classes have been scheduled, but you can always Request a Quote.

Onsite Training

For groups of three or more

Request Quote

Public Training