• Online, Self-Paced
Course Description

Connection managers in a data warehouse are used to define the data source connections. This course covers how to use connection managers to specify source and destinations, as well as how to create custom data sources.

Learning Objectives

Connection Managers

  • start the course
  • plan the configuration of connection managers
  • describe package level and project level connection manager
  • define a connection string
  • describe parameterization of connection strings

Data Sources

  • define data sources and destinations
  • distinguish between blocking and non-blocking transformations
  • determine when to use custom data sources, destinations, and transformations
  • describe both trusted and authoritative data sources
  • use different methods to pull out changed data from data sources
  • describe data flow components

Framework Connections

The materials within this course focus on the Knowledge Skills and Abilities (KSAs) identified within the Specialty Areas listed below. Click to view Specialty Area details within the interactive National Cybersecurity Workforce Framework.