Help Index - Data Warehousing Components

The Data Warehousing components from the SSIS Productivity Pack are SSIS components that facilitate integration with Data Warehouses such as Snowflake.

The SSIS Productivity Pack currently supports integration with Amazon Redshift, Google BigQuery, PostgreSQL, Snowflake as well as support for the Premium Slowly Changing Dimension (PSCD) data flow pipeline component in SSIS.

The following are the SSIS Data Warehousing components available within the SSIS Productivity Pack and their help manuals:

Amazon Redshift Components

• Amazon Redshift Connection Manager
  • Facilitates connecting to Amazon Redshift from within SSIS.
• Amazon Redshift Source Component
  • An SSIS data flow pipeline component that can be used to read / retrieve data from Amazon Redshift.
• Amazon Redshift Destination Component
  • An SSIS data flow component used to facilitate writing data to Amazon Redshift.

Google BigQuery Components

• Google BigQuery Connection Manager
  • Facilitates connection to Google BigQuery through a Google account and the Google BigQuery REST API.
• Google BiqQuery Source Component
  • Supports retrieving data from Google BigQuery from Project, Dataset, Job, Table, TableData, or Query objects.
• Google BigQuery Destination Component
  • Support writing data to Google BigQuery through Project, Dataset, Job, Table, or TableData objects.

PostgreSQL Components

• PostgreSQL Connection Manager
  • Facilitates connecting to PostgreSQL from within SSIS.
• PostgreSQL Source Component
  • An SSIS data flow pipeline component that can be used to read / retrieve data from PostgreSQL instance databases.
• PostgreSQL Destination Component
  • An SSIS data flow component used to write to a Destination table in a PostgreSQL instance.

Slowly Changing Dimensions Components:

• Premium Slowly Changing Dimension Component
  • The Premium Slowly Changing Dimension Component is an SSIS data flow pipeline component that can be used to monitor changes in the value of dimension fields that change slowly. Slowly changing dimensions are dimensions with values that are relatively static and change infrequently and unpredictably. The component can process three types of slowly changing dimensions: Fixed Attributes which are never supposed to change, Changing Attributes which can change but don't have a history, and Historical Attributes which can change, and a history of all previous values is kept.

Snowflake Components:

• Snowflake Connection Manager
  • Facilitates connecting to Snowflake from within SSIS.
• Snowflake Source Component
  • An SSIS data flow component used to retrieve data from Snowflake. Includes the option to specify retrieval mode such as retrieving files and folder or only files or choosing whether sub items should be retrieved as well.
    
• Snowflake Destination Component
  • An SSIS data flow component used to facilitate writing data to Snowflake. This component supports CreateFolder, Delete, and Upload actions when writing to Snowflake.