Connection Managers and Data Sources


Overview/Description
Target Audience
Prerequisites
Expected Duration
Lesson Objectives
Course Number
Expertise Level


Overview/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.

Target Audience
Data warehouse developers and database administrators who create and manage business intelligence solutions as part of their daily tasks, which include implementing data warehouse databases, extracting and transforming data as part of an ETL solution, and data cleansing

Prerequisites
None

Expected Duration (hours)
1.2

Lesson Objectives

Connection Managers and Data Sources

  • 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
  • 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
  • use different methods to pull out changed data from data sources
  • describe data flow components

    • Course Number:
    md_idwm_a03_it_enus

    Expertise Level
    Intermediate