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.
• Amazon Redshift Command Task
  • A control flow component that can be used to run commands to Amazon Redshift directly at control flow level. It can be used to execute queries, and also to get the output in a required manner.

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.
• Google BigQuery Command Task
  • A control flow component that can be used to run commands to Google BigQuery directly at control flow level. It can be used to execute queries, and also to get the output in a required manner.

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.
• PostgreSQL Command Task
  • A control flow component that can be used to run commands to PostgreSQL instance directly at control flow level. It can be used to execute queries, and also to get the output in a required manner.

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.
    
• Snowflake Command Task
  • A control flow component that can be used to run commands to Snowflake directly at control flow level. It can be used to execute queries, and also to get the output in a required manner.
    

Video Resources