Supports ODBC SQL. (Insert, Update, Select, and Delete). Supports group by and distinct and aggregate functions (AVG, MIN, MAX, SUM, and COUNT).Support for all string, date, conversion, and math functions. Supports nested inner and outer left/right joins. Supports subqueries and correlated subqueries. Supports substring and date functions. Support for Unions and Insert/Select.

UNIVERSAL CONSUMER

CONNX Universal Adaptor supports full access to any non CONNX directly supported SQL based OLEDB or ODBC compliant data source allowing one or many ODBC/OLEDB data sources and directly supported CONNX data sources to be presented as a single enterprise relational data source.

MULTITHREADED ASYNCHRONOUS EXECUTION

Supports the ODBC Asynchronous execution model and true 32bit threads for each SQL Statement being executed. This feature makes it possible to have a query running in the background while performing other meaningful work.

DATA CONVERSION

CONNX supports all ODBC data types including BLOBs, and CLOBs, (Binary Large Objects an Character Large Objects).

COMPATIBILITY

CONNX works with any SQL based OLEDB or ODBC compliant application. CONNX has been tested with 32bit Versions of Microsoft Access, Microsoft Studio including Visual Basic/ C++ etc, Crystal Reports, Delphi, PowerBuilder, Impromptu, Lotus Approach, and I.Q. Support for ADO,ASP (Active Server Pages).

FAST JOINS, FAST THROUGHPUT

CONNX has turbo charged its proprietary RFFA Technology, resulting in faster multi-table joins between and within data sources, and an increase in speed when performing searches on non-Keyed fields.

FAST CONNX DATA DICTIONARY

The CONNX data dictionary uses the Microsoft Component Object Model (COM) format, resulting in Fast access to information in the data dictionary, and fast queries.

MASS RECORD DEFINITION IMPORTS

CONNX imports table & view definitions directly from your ODBC/OLEDB compliant database.

SECURITY

CONNX respects all existing database security. The CONNX CDD utility supports setting up field and Table level security by group as well as individuals. CONNX also supports row level security with CONNX Views. Additionally, the CONNX data dictionary is encrypted to secure sensitive information.

VIEWS

CONNX supports the creation of views, which facilitate hiding table relationships from the end user. CONNX Views facilitate the creation of heterogeneous joins between multiple disparate databases.

WIZARDS

CONNX includes a Wizard that greatly reduces startup time, and truly provides instant access to your data. CONNX also includes application wizards for Microsoft Access, Visual Basic, Crystal Reports and Impromptu.