Calumo BI Extract Transform Load

Business Intelligence BI Software : Calumo Extract Transform Load

SQL Server 2005 includes a new enterprise data integration platform. This platform, with exceptional ETL and integration capabilities, enables organizations to more easily manage data from a wide array of traditional and non-traditional data sources. With SQL Server Integration Services (SSIS), organizations gain a competitive edge through a holistic view of their business.

Enterprise Data Integration Platform
The SQL Server Integration Services platform takes the place of a popular feature in SQL Server 2000, Data Transformation Services (DTS). But SSIS is completely new for SQL Server2005, providing the features and per-formance necessary to build enterprise-class data integration applications. The performance advantage of the transformation engine is noticeable from lightweight 32-bit systems to high-end 64-bit architectures.

Development Environment. The Business Intelligence Development Studio hosts an intuitive UI for rapidly developing SSIS packages. The Studio also enables shared solutions with Analysis Services and Reporting Services including source control, metadata integration, and a complete environment for designing, testing, deploying and maintaining end-to-end Business Intelligence applications.

Visual debugging. Developer productivity reaches new levels with visual debugging. With Data Viewers designers can see the data pipeline at work, visualizing data during transformation in grids, graphs and charts, while breakpoints, variable watches and the call stack provide powerful debugging capabilities.

Data connectivity. Integration of diverse data sources and destinations is easy. In addition to common sources, that include text files, OLEDB and ADO.NET (including ODBC for .NET), there is also simplified access to data within SAP. Built in support for XML and Web Services data enables easy integration of service oriented architectures and other non-standard data sources. An optimized SQL Server destination offers data loading, and even SQL Server Mobile databases can be targeted directly. With metadata integration and shared engineering, Reporting Services reports, or Analysis Services cubes can be loaded straight from the SSIS pipeline.

Out of the box, high performance, transformations. SQL Server Integration Services includes a great range of productive and powerful components, such as data and character conversions, calculated columns, conditional operations for partitioning and filtering, lookups, sorting, aggregation, and merges. Advanced components simplify otherwise complex operations such as Slowly Changing Dimension loading. Custom requirements can be met with flexible and fast VisualBasic.NET scripts, or developers can readily code and distribute their own reusable components.

Data quality and data mining. For data quality, Fuzzy Lookup and Fuzzy Grouping components provide inexact matching and de-duplication. Data mining features can train models from integrated data, but also bring new capabilities to the data integration process. Use predictive models to impute incomplete and missing data, or use association and clustering models to identify outliers and anomalies for data quality issues - all captured, with rigorous audit and execution metadata.

Trustworthy and reliable.Package configurations customize the way a package runs in different circumstances, for example for different server environments. Packages for deployment can be secured and digitally signed, and a simple wizard enables easy installation of deployed packages. Checkpoint restart and transaction support, together with WMI listeners and flexible error-handling and event-driven features enables resilient processes for unattended execution. Integration with the SQL Server Management Studio simplifies the management and monitoring of packages in the SQL Server ecosystem.

Integrating the community. SQL Server Integration Services is not just about integrating data. The architecture and infrastructure empowers a remarkably dynamic and diverse community from specialized software vendors to committed users. The infrastructure of SQL Server Integration Services is so readily extensible and powerful that vendors can easily develop and distribute their own advanced components, while users enjoy active and helpful communities for sharing ideas, components and support.

Source: For more information on BI business intelligence software, Calumo Extract Transform Load (ETL), check out http://www.calumo.com/extract-transform-load.html