Logi ETL - BI Software

Logi ETL - Business Intelligence BI Software

Extract, Transform and LoadLogi ETL Enables Data Integration from Different Sources. Optimize Your Data for BI and Reporting and Enjoy Impressive Scalability
Why should you choose Logi ETL for your data integration needs? Simple. Logi ETL gives you these unique benefits:

Fully Web-based Data Integration - With Logi ETL, you can not only seamlessly integrate your data. You can also integrate the ETL with your other BI applications—regardless of vendor or brand. Use Logi ETL as a Web Service, launch ETL jobs from any standard-type processes and Web processes. Integrate Logi ETL into your business processes and workflows tied to triggers and alerts.

Unique Web Data Sources - Do more with a diverse set of data! Logi ETL gives you easy connections out of the box with Web Services and other Web-oriented data sources (e.g. SalesForce.com, Google Docs, RSS and ATOM feeds). And as with all other LogiXML products, Logi ETL connects with relational databases and flat-file data sources.

Elemental Development Methodology – The same concepts you use to define logic in reports, templates, process files, etc., can be applied and even reused/shared in Logi ETL. You can also leverage or share previously created work from other projects, for example other ETL jobs or reports from Logi Info.

Optimization for BI and Reporting – Logi ETL is designed to work with data geared towards reporting, analysis and visualization. Thanks to the hybrid engine that powers it, Logi ETL gives you also impressive scalability. The ETL elements in Logi ETL are optimized to make data management for BI very easy, providing capabilities centered on Web-based integration, application extensibility and rapid development.

Source: Business Intelligence BI Software at LogiXML.com

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