Compliance
Level 2 Compliant.

Full SQL Support

• Supports ODBC SQL. (Insert, Update, Select, Delete)
• Supports Group By and Distinct and aggregate functions (AVG, MIN, MAX, SUM, COUNT)
• Supports nested inner and outer left/right joins.
• Supports subqueries and correlated subqueries.
• Supports substring and date functions.

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.

Network Database Technology
CONNX has a unique technology which facilitates easy access of network database models using standard SQL. This is accomplished through the creation of CONNX "virtual" fields which represent "set" relationships between owner and member tables.

Data Conversion
CONNX supports all DBMS data types.

Compatibility
CONNX works with any ODBC compliant application. CONNX has been tested with the 16bit and 32bit versions of Microsoft Access, Microsoft Visual Basic, Crystal Reports, Delphi, PowerBuilder, Impromptu, Lotus Approach, I.Q..

Fast Joins, Fast throughput.
CONNX has turbo charged its proprietary RFFA Technology, resulting in faster multi-table joins, 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 definitions directly from your DBMS 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 databases.

Wizards
CONNX includes a Data Dictionary 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.

RPC (Remote Procedure Call)

Command Execution
CONNX provides an RPC mechanism that allows remote execution of batch jobs, command procedures, and applications from a PC.

System Requirements

PC

	TCP/IP (Winsock 1.1 or above) or Pathworks 4.0 or above
	Windows 95 / Windows NT
	8 Meg of memory (16 recommended)
	50 Meg of hard drive space free recommended.

VAX/Alpha

	VMS 5.4 or above
	TCP/IP (UCX or compatible) or Pathworks
	DBMS version 6 or above

For more information or to order an evaluation, please contact us

[Home][Products/Services][User Stories][Support][News/Events][Contact Us]

[Product FQA's][How To Find Us]