Detailed Description of Adeptia ETL Suite 5.1

Adeptia ETL Suite is a comprehensive solution that provides a powerful data conversion capability. This is a graphical, easy to use software that supports ANY TO ANY conversion.

*Flat file to XML
*XML to CSV
*Any Database to XML
*Excel to Database
*XML to EDI
*HIPAA to XML
*HL7 to XML
*Date format, string, numerical conversions etc.
*And any other combination

Adeptia ETL consists of three distinct components. It has a web-based a????Design Studioa???? that provides wizard-driven, graphical ability to document data rules as they relate to validations, mapping and edits. This tool includes a library of functions which can be pre-created and reused again and again. Data Mapper has a "preview" capability to see actual source and target data, while the rules are being specified, if the source data file is available.

The second component is the 'Central Repository' where all the rules and mapping objects are saved. The third component is the 'Run-time Execution Engine' where the mapping rules and data flow transactions are executed on incoming data files and messages.


This is enterprise-class software that is centrally administered and managed to ensure smooth performance and uptime. Detailed logs are maintained and audit trails are available to ensure compliance with regulatory requirements like Sarbanes-Oxley. This product is standards-based and it leverages Service-Oriented Architecture (SOA) and process-based approach to create flexible and loosely coupled data flows that suit any aggregation or data warehousing solutions. It is ideally suited for an Extract, Transform and Load (ETL) scenario.

ETL Suite offers a powerful middleware application to document, automate and execute critical data processes especially for creating and populating data marts from various internal or external data sources. This allows data to be received from multiple sources in different formats and mapped to a common database schema.

TAGS OF ADEPTIA ETL SUITE

flash maker suite , psp pc suite , mahjong suite , sony pc suite , microsoft wordsuite , dvd suite , dcs deluxe suite , lg suite , mp3 to ipod suite