CONNX Solutions Releases CONNX® 11 Which Includes 64-Bit and Expanded SQL Support
REDMOND, Wash. – September 17, 2009
CONNX Solutions, Inc., a leading provider of simplified data access, management and
integration software solutions, announces the release of CONNX 11, which is
available today for demonstration, evaluation and purchase. This release introduces
64-bit Windows support, performance increases, several new SQL features and On
Demand Connectivity.
CONNX 64-Bit Windows Support
With the upgrade to 64-bit database connectivity, CONNX now allows companies to take
advantage of the scalability and performance gains of 64-bit applications, such as
Microsoft SQL Server and Oracle. This new support means that the CONNX ODBC/OLE DB
Drivers and .NET Data provider can be used in developing 32-bit or 64-bit applications.
Also, CONNX Solutions is very pleased to announce a unique 32/64-bit ODBC/OLE DB Bridge
feature in this new release. The Bridge feature allows companies to access 32-bit data
sources from 64-bit applications, and 64-bit data sources from 32-bit applications.
“We have had many requests for a 64-bit driver to work with 64-bit SQL Server Linked server,
64-bit Oracle heterogeneous data access and other 64-bit applications, and we are pleased
that we can deliver this technology,” said Larry McGhaw, the CTO & VP of Engineering at
CONNX Solutions, Inc.
Speed and Ease Of Use Improvements
- Server performance has been increased by 20% while reducing CPU utilization.
- Complex expressions in join clauses resulting in significant performance increases with certain queries.
- Integrated install of DataSync and CONNX Drivers.
Expanded SQL Support Improvements
- Temp Table Support
CONNX now supports the creation of true temporary tables.
These tables are session based and are removed when the connection is closed. Temp tables
provide a way to perform complex calculations that require intermediate storage.
- Expanded SQL Support in CONNX Views
CONNX Views may now contain SQL DISTINCT,
Aggregates, Unions, Subqueries, and Subtables.
- Support for ANSI SQL COALESCE and NULLIF functions
- Extended Functions – CONNX_SERVER_VERSION, CastASCONNXType
- Subquery as a Table Support
CONNX now supports the ability to treat a subquery
as a table. This powerful SQL feature enables complex SQL statements to be written simply
and with better understanding and performance.
Metadata Support Improvements
- COBOL Copybooks with IMS.
- RM/COBOL Files.
“With the release of Version 11, CONNX is now firmly established in all levels of the enterprise.
The quality of our products and increased functionality make CONNX a great investment in today’s
economy as well as protection for future technology,” stated Douglas D. Wright, President
and CEO of CONNX Solutions, Inc.
On Demand Connectivity
With the ‘On Demand Connectivity’ feature, initial application connection time is shortened by only
connecting to those databases specified within the query and not all of the databases it is currently
accessing. As a result, companies can now establish a faster connection
through CONNX when accessing a large grouping of data sources, but only querying a few.
CONNX 11 is currently available for purchase. Contact CONNX Solutions at 888-882-6669 for pricing
information.
About CONNX Solutions, Inc.
CONNX Solutions, Inc. continues to offer standards-based software tools for direct access to
enterprise data via SQL regardless of the database type being targeted (relational or non-relational).
With CONNX’s unique metadata capabilities, VIEWS can be defined using disparate database tables and
the CONNX SQL engine will perform the joins for you when accessing or writing to your data through
this CONNX TABLE VIEW. CONNX continues to allow an automated way of replacing the 3GL program writing
for extracting, transferring, loading of production data to data warehouses as well as synchronizing
that data using our DataSync product.
CONNX Solutions’ products, CONNX drivers,
CONNX DataSync and
InfoNaut Professional have been used by over 3,000 organizations
worldwide. Government and business entities use CONNX in a wide range of industries, including
manufacturing, education, healthcare, financial services, telecommunications, aerospace and information technology.
For Simplified Data Access, visit
www.connx.com
CONNX Solutions and CONNX are registered trademarks of CONNX
Solutions, Inc.
All other trademarks, registered trademarks, product names,
and company names mentioned herein are acknowledged as the
property of their respective owners.
####
|