Data Warehousing Components

Data Warehousing Components

Some specific data warehouse integration scenarios can prove challenging and time-consuming. These SSIS components were designed to streamline data integration with data warehousing services, making the process as easy as possible.

The following are the SSIS Data Warehousing components available within the SSIS Productivity Pack and their help manuals, including the Premium Slowly Changing Dimension (PSCD) data flow pipeline component:

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 designed to monitor changes in the value of dimension fields that change slowly. Slowly changing dimensions are dimensions with relatively static values that change infrequently and unpredictably. This 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, with a history of all previous values 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