Home page  
Help > Tools Introduction >
Frequently Asked Questions (FAQs)
Version 7.11

Frequently Asked Questions (FAQs) 1

General Introduction. 1

Configuration. 3

Runtime. 4

Client Tools. 5

Maintenance/Updates. 5

Frequently Asked Questions (FAQs)

General Introduction

 

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.

 

Click for more details.

 

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.

 

Click for more details.

 

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.

 

Click for more details.

 

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.

 

Click for more details.

 

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.

 

Click for more details.

 

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.

 

Click for more details.

 

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.

 

Click for more details.

 

Configuration

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.

 

Click for more details.

 

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.

 

Click for more details.

 

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.

 

Click for more details.

 

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.

 

Click for more details.

 

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.

 

Click for more details.

 

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.

 

Runtime

 

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.

 

Client Tools

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

 

Maintenance/Updates

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

 

Click for more details.

 

 

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.