WhereScape now offers customers the ability to use SQL Server Integration Services (SSIS) to load and leverage data in a data warehouse which was designed and managed by WhereScape RED; allowing WhereScape RED to work within SQL Server’s database engine to transform data and build objects. All taking a fraction of the time with traditional methods.
“SQL Server Integration Services excels at loading data from different sources. Once the data is loaded, WhereScape RED builds all the downstream SQL Server objects such as facts, dimensions, and Microsoft Analysis Services cubes in the database 10 times faster than with traditional, hand-coding methods,” said WhereScape CEO Michael Whitehead. “SSIS provides WhereScape customers another option to load data that is extremely fast, efficient and flexible. WhereScape developers enjoy full technical and user documentation for change management and data lineage.”