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
Redmond, Wash. (PRWEB) September 29, 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 implemented 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 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.