EIQ Products™
Related information
EIQ adapters and sub-middleware form the core of EIQ Products™
and include the tools and processes to discover data sources, profile
data, develop data quality transforms, build and maintain indexes and
process queries
The four EIQ adapters and sub-middleware currently offered are:
- EIQ SuperAdapters™ for data source access
with standard data model mapping
A superior alternative to conventional federated adapters, offered on a data source basis; includes index and results data cleansing, transformation and standardization, standard data model mapping and associated query transformation. Results from an EIQ SuperAdapter are produced in the same standard data model format as results data from other EIQ SuperAdapters, each accessing individual data sources. WhamTech EIQ Federation Server sub-middleware and/or other third-party middleware products can combine results as needed.
- EIQ TurboAdapters™ for data source access
without standard data
model mapping
A query enhancer that resides between an application or a conventional federated adapter, and a data source system, similar to an EIQ SuperAdapter, but without the ability to transform queries and map results to a standard data model. Indexes and results data are cleansed, transformed and standardized.
- EIQ ConventionalAdapters™
for conventional data source access without indexes, but
with
standard data model mapping
In the situation where none of the 12 change data capture (CDC) options are available to build and maintain indexes, EIQ ConventionalAdapters can be used and are similar to conventional adapters. Queries are submitted to, and transformed by EIQ ConventionalAdapters; however, queries are submitted to, and executed by, data sources. Results data can be cleansed, transformed and standardized.
- EIQ
Federation Servers™ for other EIQ Product integration - no direct
data source access
A virtual data integration, sharing and interoperability sub-middleware query management system, to access multiple data sources each of which must have an associated EIQ SuperAdapter, EIQ TurboAdapter or EIQ ConventionalAdapter product. EIQ Federation Server does not have its own indexes, query processing or results transformation, but can distribute queries and combine results data from other EIQ Products. EIQ Federation Servers can access other EIQ Federation Servers as though they are single data sources and can be independently configurable, allowing for high performance, scalability, load balancing, failover and redundancy.
The following table lists the major feature differences among the products:
| Feature | EIQ SuperAdapter | EIQ TurboAdapter | EIQ ConventionalAdapter | EIQ Federation Server |
| Standard driver/Web service access | yes | yes | yes | yes |
| ANSI SQL | yes | yes | yes | yes |
| Basic pass-through security | yes | yes | yes | yes |
| Works with multiple data sources |
(no) Only through ATTACH* |
(no) Only through ATTACH* |
no | yes Through other EIQ Products |
| Sold on a data source basis | yes | yes | yes | no |
| User-level data source access | yes | yes | yes | yes Through other EIQ Products |
| Index cleansing and transformation | yes | yes | no | no |
| Standard data model and metadata | yes | no | yes | yes |
| Query transformation from standard data model and metadata to indexes | yes | no |
(yes) Only to data source indexes |
no |
| Results data cleansing and transformation (does not necessarily include standardization) | yes | yes | yes | no |
| Advanced security on standard data model and metadata (available soon) | yes | no | yes | yes |
*ATTACH
allows disparate data source indexes to be integrated as though a single
set of indexes, similar to merging schemas; however, this is not a
highly scalable solution and requires a higher level of cooperation
among data source owners.