View Image

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 “Design Studio” 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. This enterprise-class software allows companies to centrally manage their data schema and mapping rules in a central repository and directly archive those rules in PDF documents for easy sign-off.