Frequently Asked Questions (FAQs)
1. What do EIQ Products do?
EIQ Products solve most data access, integration, sharing, and interoperability challenges faced by organizations in an innovative and unique way.
EIQ Products combine the best of data warehousing and conventional federated data access and overcome the worst of these approaches. EIQ Product Suite enables true virtual data warehousing in distributed federated data systems, with aspects of virtual operational data stores and virtual data marts.
2. What are the different configurations of the EIQ Product Server (EIQ Server)?
The following are the data source adapter configurations that deal with specific data sources:
EIQ SuperAdapter
EIQ TurboAdapter
EIQ ConventionalAdapter
The EIQ Federation Server configuration handles query distribution and results consolidation across the adapters.
3. When do I use EIQ SuperAdapter, EIQ TurboAdapter, and EIQ ConventionalAdapter?
EIQ SuperAdapter: to provide clean and standardized indexes (based on a standard data model) when data in a data source is not clean and for additional query processing capabilities that a data source is not equipped to handle.
EIQ TurboAdapter: to provide an indexing and query processing layer to a data source in order to speed-up query processing and to reduce query loads.
EIQ ConventionalAdapter: to submit standardized queries (based on a standard data model) to a data source for query execution.
4. What data sources can EIQ Products work with?
EIQ Products™ work with various data sources including any major DBMS (SQL Server, Oracle, DB2, MySQL, PostgreSQL, Teradata, MS Access, etc.), files and archives (of numerous types including MS Office), e-mail, web services, and web content.
EIQ Adapters™ utilize standard drivers such as ODBC, JDBC, and Web Services to connect. Custom connectors can also be developed very quickly for unusual data sources.
WhamTech JavaGateway provides access to JDBC/Java-dependent data sources.
WhamTech WhamSearch Intelligent Spider provides access to the web documents.
EIQ Products can also work with cloud/big data systems such as Hadoop/HBase and EMC Greenplum.
5. What are the various components of the EIQ Product Suite?
The EIQ Product Suite comes with:
- Runtime server components for profiling, transforming, indexing and query processing, federation, updating indexes, and etc.
- Tools for data analysts
- Tools for administrators
- SDK for developers.
6. What developer components are provided in the EIQ Product Suite?
The developer SDK includes the following APIs for client applications:
Web Services Components
JDBC Driver
ODBC Driver
Java Socket Client
OLE-DB Driver
WhamTech Native API (WhamNAPI) (C/C++)
Thunderbolt Indexing and Query Processing Engine
Text Indexing and Query Processing
Java application developers can also use JBoss Hibernate which provides an object interface over a relational JDBC driver.
In addition, configuration APIs are available for integration with third-party configurations and administration tools.
7. What add-on functionality is available?
Cloud EIQT - scalable external indexing and query processing for cloud/big data
Link Indexes™ - Link mapping and link analysis across multiple data sources
Advanced Text Search
Indexed Views (Materialized Views)
E-discovery
Entity Extraction
Fuzzy Matching
Distributed Analytics
Mainframe Data File Access and Query
8. What are the EIQ Product Suite system requirements?
The EIQ Product Suite software runs on 64-bit Windows, Linux RHEL/CentOS, and IBM Power 8 platforms.
9. What SQL query syntax do EIQ Products support?
EIQ Products provide most of the commonly used ANSI SQL-92 and SQL-99 functionality including for Business Intelligence and Analytics.
1. How do EIQ Products work with common data models, standard data models, and canonicals?
All EIQ Server configurations but the EIQ TurboAdapter support common data models. Users can import models and use them to map individual data source columns to common data model columns. EIQ Federation Server automatically maps its common data model columns to all the mapped columns in the EIQ SuperAdapters/EIQ ConventionalAdapters in a deployment system.
2. What support do EIQ Products provide for Information/Entity Extraction?
EIQ Products use the popular open source software GATE (General Architecture for Text Engineering) for handling advanced analytics on unstructured text.
EIQ Products provide structure to unstructured data by allowing users to extract entities out of unstructured text in structured data sources (memo/text columns) as well as from unstructured data sources (files, web pages).
Users can do complex structured queries (JOINs etc.) on the extracted data by combining with other structured data.
WhamTech WhamEE (WhamTech Entity Extraction) server provides the entity extraction functionality.
3. How does Link Indexing work?
Link Indexes help find obvious and non-obvious links between data from across multiple data sources while not requiring the movement of data into a single database system.
In a federated EIQ deployment, the links are formed between records from EIQ SuperAdapter indexes associated with data sources based on matching values for given entities.
4. What are virtual keys and non-virtual keys and how do I use them?
Non-virtual keys are very similar to typical database index keys - they contain index trees, lists, and associated data for a column. Unlike non-virtual keys, virtual keys are dataless; they contain index trees and lists but not the associated data.
Typical EIQ installations use virtual keys for all columns except for primary key (PK) and foreign key (FK) columns.
5. How are EIQ SuperAdapter indexes kept in sync with changes in data sources?
An EIQ SuperAdapter uses its own indexes on data from the associated data source. These indexes are updated in real-time as data changes in the data source.
The EIQ Product Suite supports several ways of updating the indexes and comes with several tools to help with the process.
6. In the EIQ Server Configuration tool, under the ‘SuperSchema Mapping’ tab, when I try to map a field, I get an error message saying "Can't map column <ColumnName> with index data type <Type1> to metadata field <MetadataField> with data type <Type2>".
Columns with different data types in different data sources cannot be given the same Metadata Field name. You can either give a different Metadata Field name for each or click "Edit Metadata Dictionary" and change the default data-type for the specific Metadata Field name.
1. When I start the WhamTech EIQ Server service through the Windows Services panel, it does not start and shows an error 'The service did not respond to the start or control request in a timely fashion'.
This could happen due to a number of reasons. For more information about the exact causes of error, open the EIQ Diagnostics Tool from "Start Menu > WhamTech EIQ Server Suite". Open the Diagnostics window for 'EIQ_Server' and try restarting the service.
2. In the EIQ Diagnostics Tool, no diagnostic information is printed in the ‘EIQ_Server’ window, even though my Server is running and should be printing information.
Make sure you only have one window for the EIQ_Server application open in the Diagnostics tool. Also, in some cases you might have to close and re-open the window for diagnostic information to be printed.
3. EIQ Server service takes a very long time to start.
Check if the data source servers (SQL Server/Oracle/DB2, etc.) to which the EIQ Server data sources are connected are up and running. Keep the EIQ Diagnostics Tool running for the 'EIQ_Server' application for more information.
1. When I execute a query in the EIQ Sever Query Tool, it fails without displaying any results; or the Query Tool fails to connect to EIQ Server?
Check if the EIQ Server service is running; also check if other data source services that require (SQL Server, Oracle, DB2, etc.) configuration with the EIQ Server are running.
2. The query execution fails with the message "<ColumnName> is not a Standard Field Name in the SuperSchema"?
Check if the column names used in the query are from the metadata field names defined in the ‘SuperSchema Mapping’ tab of the EIQ Server Configuration Tool. You can also get a list of available field names by executing 'schema columns' in the query tool window.
3. I do not see results from all the data sources being displayed when I query a Virtual Data Source (VDS) having more than one data source.
Check the "AggregateRowSetLimit" and "DatasourceRowsetLimit" settings values in the 'Advanced Settings' tab in the EIQ Server Configuration tool. For no limitation on the number of records displayed in the result set (from each datasource/aggregate), change these values to 0 (zero).
1. When I try replacing the binary files in "C:\Program Files\WhamTech\bin" with an updated set, the system gives an error saying "cannot copy <Filename>. It is being used by another person or program". How can I fix this?
Before you start replacing the binaries, always make sure that the WhamTech Windows Services are in stopped state (EIQ Server and EIQ RTIS). Also, ensure that no WhamTech tools are running (EIQ Server RTI Tool, EIQ Server Query Tool, EIQ Diagnostics Tool, etc.).
2. How do I troubleshoot components?
Use WhamTech EIQ Diagnostics Tool to trace the problem component(s).
Copyright © 2019 , WhamTech, Inc. All rights reserved. This
document is provided for information purposes only and the contents hereof are
subject to change without notice. Names may be
trademarks of their respective owners.