|
|
|
 Data Access
Engine
|
|
Compliance |
|
ODBC Level 2
Compliant |
|
Full SQL
Support. |
|
 |
Supports full ODBC SQL.
(Insert, Update, Select, Delete, Create Table/Index, Drop Table/Index) |
|
Supports Group By and Distinct
and aggregate functions (AVG, MIN, MAX, SUM, COUNT) and all substring, string, date,
conversion and maths functions. |
|
Supports nested inner and
outer left/right joins. |
|
Supports subqueries and
correlated subqueries. |
|
Supports substring and date
functions. |
|
Supports Unions and
insert/select functions. |
|
|
Multithreaded
Asynchronous Execution. |
|
Supports the ODBC
asynchronous execution model and true 32 bit 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
Oracle data types including BLOB's and CLOB's (Binary Large objects and Character Large
Objects) |
|
Compatibility. |
|
CONNX works with
any OLE DB or ODBC compliant application and has been tested with 32 bit version of
Microsoft Access, Microsoft Studio, including Visual Basic / C++ etc.. Seagate Reports,
Delphi, PowerBuilder, Impromptu, Lotus Approach and I.Q. Support for ADO and ASP ( Active
Sever Pages ). |
|
Fast
Joins, Fast Throughput. |
|
CONNX has turbo
charged its proprietary RFFA Technology, resulting in faster multi-table joins and
increase in speed when performing searched on non-keyed fields. |
|
Fast
CONNX data dictionary. (CDD) |
|
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, and stored procedure definitions from Oracle Databases. |
|
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 form the end
user. CONNX Views facilitate the creation of heterogeneous
joins between multiple disparate databases. |
|
Wizards. |
|
CONNX includes a
data dictionary that reduces greatly start-up time, and truly provides instant access to
data. CONNX also includes application wizards for Microsoft Access, Visual Basic, Seagate
Reports and Impromptu. |
|
SQL
Passthrough. |
|
CONNX optimises
performance by analysing SQL statements to determine if they can be directly passed to the
target database. |
|
Stored
Procedures. |
|
Support for the
invocation of compiled Oracle stored procedures and functions within Oracle Packages. |
|
System
Requirements. |
|
|
PC:SQL*Net2.x or above |
|
Windows 9X/Windows NT |
|
8 Meg of free hard drive space
recommended. |
|
|
Server: |
|
|
Oracle RDBMS,(All platforms), |
|
Version 7.3 and above,
SQL*Net2.x. |
[Home][Products/Services][User
Stories][Support][News/Events][Contact Us]
[Product
FQA's][How To Find Us] |
