Menu Request Demo

White Paper: RED and ssis integration

Author: WhereScape

The purpose of this document is to demonstrate how quick and easy it is to integrate external Microsoft SQL Server Integration Services (SSIS) packages developed using Microsoft tools like Visual Studio into a RED data warehouse environment.

There are a number of scenarios where integrating external ETL processes may be needed, some potential scenarios are: 

  • Integration with a data source not supported natively by RED (e.g. SharePoint List, Web Services)
  • Integration of Data Quality (DQ) rules into the workflow (e.g. MSSQL Data Quality Services or DQS)
  • Complex processing rules where an ETL package is a better fit

By following a few simple steps and applying the provided base code templates integration between external SSIS packages and RED can be achieved within minutes.

To read more please download the full White Paper below.