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.