SQL Server 2005 Integration Services
SQL Server 2005 offers a new data ETL platform, SSIS. Formerly known as Data Transformation Services (DTS) in previous versions of SQL Server, SSIS has been redesigned to provide the functionality and high-scale performance necessary to be an enterprise ETL platform. SSIS performs complex data integration, transformation, and synthesis at high speeds for very large data volumes, enabling you to more easily integrate and analyze data from multiple heterogeneous information sources. SSIS is fully programmable, embeddable, and extensible characteristics that make it an ideal ETL platform.Rich Development Environment
Tight integration with Visual Studio 2005 provides development teams that are building data-centric applications with a platform that enables the most productive and collaborative development for dependable solutions. Visual Studio 2005 directly supports all of the new SQL Server 2005 data types, such as native XML. You can also deploy new database objects directly from Visual Studio 2005 without having to switch tools. Visual Debugging SSIS comes with powerful debugging capabilities that help your designers visualize data during transformation in grids, graphs, and charts. With SSIS, developers can use the Visual Studio debugging interface to debug the Common Language Runtime (CLR) application code and Transact-SQL (T-SQL) database code whether the code is located on the developer’s machine or is stored in the SQL Server 2005 database. You can set breakpoints on packages, containers, task events, and data viewers for watching data as it moves through the data flow.
The breakpoint can be defined before, after, or at several points during the task's execution in the debugging process. Variable watches and the call stack also provide powerful debugging capabilities.
Data Quality
Some data transformation tasks require complex logic. The Fuzzy Lookup and Fuzzy Grouping transformations within SSIS provide inexact matching and de-duplication. Use predictive models to assign incomplete and missing data, or use association and clustering models to identify anomalies for data quality issues. All models are captured with rigorous audit and execution metadata.
Extensible Architecture
SSIS includes a completely rewritten object model that makes extending and programming packages easier, more flexible, and more powerful. With SSIS, developers can extend and program almost every aspect of Integration Services packages including tasks, log providers, enumerators, connection managers, and data flow components. These custom objects can be integrated into the user interface of Business Intelligence
Development Studio.
Out-of-the-Box, High Performance Transformations
SSIS includes a great range of productive and powerful components that are available right out of the box data and character conversions, calculated columns, conditional operations for partitioning and filtering, lookups, sorting, aggregation, and merges. These readily available and advanced components can simplify otherwise complex operations such as Slowly Changing Dimension loading.
No comments:
Post a Comment