Another quite an aspiring name in the ETL / data integration software industry is Adeptia. The company was founded in 2000 in Chicago and stays focused on providing companies with comprehensive data management solutions. It's rather young and not very famous, but it's a fact that more and more customers decide to try offers by less known vendors, but more cost-efficient, supplied with individual support, etc. For data integration, Adeptia's offer is Adeptia Enterprise Business Integration Management suite (EBIMS).

Adeptia Strengths

• broad core capabilities
• ease of use
• many tools, one suite
• data integration and application integration at once

What Adeptia offers as a data integration solution, Enterprise Business Integration Management, is a whole suite in fact, therefore its functionality has to be much broader than in case of separate tools. And the fact is that most of core capabilities in data integration - bulk/batch data delivery, grannular data capture, data propagation - are very well worked out. Additionally, data integration and application integration capabilities are grouped under one name, as a one suite, what results in some really meaningful benefits.
The first is ease of use thank to common interface and easy access to the most important capabilities. The second, is significant cost reduction with one, easy to understand pricing model. This way buyers don't actually neither have to nor need to purchase single products or tools separately.

The platform itself also is a big advantage of Adeptia offering - a single but comprehensive environment connecting data integration and application integration is exactly what today's customers expect their DI platform to be.

Adeptia Weaknesses

• lack of extra capabilities beside standard ETL for data integration
• limited metadata support
• low quality of provider support

Even though Adeptia Enterprise Business Integration Management is thought to be a comprehensive suite, it focuses mostly on chosen part of data management uses area, therefore its users often complain on lack of additional options, especially the capabilities beyond the traditional extract, transformation and load functions. Experienced users point out that they would like to have more options, more data integration styles supported, data replication and synchronization enabled, and so on. Perhaps it is still the matter of time for Adeptia to improve the product and broaden its capabilities.

What else is easy to notice are solution's difficulties with metadata management. It should be much better worked out with plenty of additional options. Up to now, metadata support within Adeptia data integration suite is way below the requirements of even those not very sophisticated users. So is the technical support provided, or maybe it would be more accurate to say 'not provided' by the vendor. It's another question which Adeptia still has a lot to improve so it image, clearly enhanced with attractive pricing, could be appealing to more customers. So far the help from the provider, for instance in case of installation, setup or documentation, didn't address the customers' needs.

Adeptia ETL Suite

Adeptia ETL Suite (AES) is a graphical, easy-to-use data mapping solution that is ideal for aggregating data from multiple sources to populate databases and data warehouses for Business Intelligence solutions. AES is a comprehensive solution that combines data transport with powerful metadata management and data transformation capability.

AES platform components

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 Service 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.

The diagram represents the key components of Adeptia ETL suite in a greater detail.

Key Features of Adeptia ETL Suite

• Data integration functionality which is perfectly suited for Extract, Transform, and Load (ETL) type of data warehousing solutions for business intelligence, reporting and dashboards
• Process flow based and service-oriented approach for data transformation and integration
• Easy to use, intuitive user-friendly interface to define data mapping and data transformation rules
• Graphical design environment and fully featured run-time engine in one package
• Object-based architecture that promotes reusability of components and functionality across disparate custom packaged and legacy applications
• Web-based interface that enhances productivity with minimal training
• Complete management, reporting and auditing capabilities to track and monitor transactions

What makes Adeptia ETL Suite unique?

• Process-centric Integration in single package
  • Allows complete business process around the integration to be automated
  • Supports Services Orchestration
  • Allows Human Workflow to handle errors, exceptions and approvals
• Enables SOA
  • Flows can be exposed as Services
  • Includes a services repository
  • Metadata Driven approach, Integration components are re-usable
• Quick implementations in days and weeks
  • Allows quick projects so customers can see immediate value
  • Ease of Use: Graphical, No coding approach ideal for business analysts
  • Reduces reliance on expensive consultants
• Flexible pricing reduces customer risk