Understanding the differences in SQL Server data warehouse architecture, approach and benefits between leveraging Microsoft SQL Server Integration Services (SSIS) versus WhereScape® RED automation software is integral to choosing the right toolset for your data warehouse or big data integration project. This white paper provides an overview of both offerings to help you gain a clear grasp of the functionality each offers and which approach is best suited to the development methodologies and vision within your IT organization.

Download this white paper to better understand:

  • The difference in architecture and approaches between Microsoft SSIS and WhereScape RED
  • The potential roles of both data warehousing tools within the data warehouse lifecycle to address needs typically associated with the ETL process
  • The additional benefits WhereScape RED offers teams beyond ETL/ELT needs in developing, managing and documenting data warehouses on Microsoft SQL Server, given its use of metadata