CONNX for Java EE™ enables organisations to create high performance enterprise-wide applications.
The Java EE architecture allows for the creation and distribution of enterprise applications on any platform. The CONNX component that fits into the Java EE architecture is a pure Java JDBC driver that provides access to non-relational and relational data alike.
CONNX makes non-relational data sources, like RMS, Oracle Rdb, Oracle Codasyl DBMS, C-ISAM, D-ISAM, Micro Focus, VSAM, IMS and Dataflex files, appear as true relational databases. A significant component of the Java EE is the Connector. The Connector is a method of wrapping data access and business rules into a single component. This component is the front door to the underlying business object. The creation of Connector components eventually requires access to the actual data.
CONNX provides a pure Java method of accessing the actual data through JDBC. Most JDBC drivers provide access to relational databases, such as SQL Server, Oracle, and DB2. CONNX not only provides access to those common databases, but also to non-relational databases.
Unifying SQLA key feature in CONNX is its unifying SQL technology. Even though most relational databases support ANSI SQL, there are subtle (and, sometimes, not so subtle) differences in the SQL supported between major relational databases, such as Oracle, DB2, and SQL Server.
CONNX provides a unified ANSI SQL syntax that works across all databases, and even across those data sources that do not support SQL at all. This enables JAVA EE developer’s true database-independent data access. CONNX automatically translates the standard ANSI SQL syntax to the native database syntax. This has the advantage of portability, and provides the performance of using native SQL.
Additionally, CONNX enables you to pass true native SQL directly through to the relational database, providing the best of both worlds.
Connection Pooling and Connection SharingWhen creating enterprise applications, scalability is a key factor in the performance and success of the application. CONNX provides two technologies through JDBC that lead to increased scalability: Connection Pooling and Connection Sharing.
Connection Pooling keeps previously used connections in a “pool” for a configurable period of time. This eliminates the overhead of creating a new connection every time one is needed. Connection Sharing enables multiple users to “share” a single physical connection resource.
CONNX provides configuration options to control the number of logical users that share a single physical connection. By using these two options together, it is possible to create JAVA EE applications that support thousands of users with excellent performance.
SummaryCONNX for JAVA EE enables organisations to create high performance enterprise-wide applications. By taking advantage of the CONNX portability and scalability features, organisations spend more time on addressing business needs and less time on the technical details of the implementation and rollout.
CONNX 11.5 now includes support for SQL Azure, SQL Server 2012, SAP Hana, SAP Max DB and new platform support.
Generix Limited is delighted to announce the release of CONNX 11.5. Building on CONNX 11’s core technology, this significant release now includes support for SQL Azure, SQL Server 2012, SAP Hana and SAP MaxDB. We have also enhanced CONNX DataSync Transformation Server to integrate with SQL Server SSIS and added several additional Linux and Unix systems to our list of supported platforms.
SQL Azure SupportCONNX 11.5 now supports the Cloud with support for SQL Azure. We provide the ability to move and synchronize data from our 90+ supported data sources to and from Azure, as well as move and synchronize data from Azure to Azure.
CONNX DataSync Transformation Server integration with SQL Server SSISThe CONNX SSIS CDC Connector enables SQL Server SSIS Packages to incrementally process data instead of performing a full “extract and load” each time the package is run.
This incremental processing of data – from virtually any data source:
The CONNX DataSync Transformation Server provides complete control of CDC processing from within SSIS. Choose either full CDC or just inserts and updates with no deletes.
SAP Hana and SAP MAX DB SupportCONNX 11.5 now supports SAP Hana and SAP Max DB. We provide the ability to move and synchronize data from our 90+ supported data sources to and from SAP Hana and SAP Max DB.
SQL Server 2012 SupportCONNX 11.5 now provides full support for SQL Server 2012 in addition to SQL Server 2008, SQL Server 2005, SQL Server 2000.
New Platform SupportThe following platforms have been added to CONNX 11.5:
CONNX 11 SP3 includes a metadata comparison tool, 64 bit Unix and Linux support, performance and ease of use improvements, and enhanced support for VSAM.
Generix Limited is pleased to announce the release of CONNX 11 SP3. Building on CONNX 11’s core technology, this release includes a metadata comparison tool, 64 bit Unix and Linux support, performance and ease of use improvements, and enhanced support for VSAM.
“Systems, architecture and environments continue to change rapidly, often with far reaching implications. CONNX continues to be improved and enhanced in order for our customers to keep abreast of ever changing technology to remain competitive”, said Leonard Klejnow, Director of Business Development at Generix Limited.
CONNX 64-bit Unix and Linux Support In addition to 64 bit support for Windows, CONNX 11 now has both 64 bit and 32 bit client support for Linux, AIX, Solaris and HPUX.
“Customers can now deploy applications on 64 bit or 32 bit and use CONNX as the glue that seamlessly joins all their enterprise data”, said Anthony Lightfoot, Product Manager at Generix Limited.
Performance and ease of use improvements
Enhanced Support for VSAM Databases CONNX for VSAM now natively supports GDG (IBM Generational Data Groups) data sets, enabling access to a particular generation, or simply the latest generation.
Generix Limited Announces Release of CONNX DataSync Transformation Server.
We are pleased to announce that the release of CONNX DataSync Transformation Server adds full ETL capabilities to CONNX DataSync
"CONNX DataSync Transformation Server extends our proven data integration and synchronisation technology. Customers can now easily join any database table columns from many data sources, transform columns and incrementally synchronise target databases. This will save companies time and money with a quick ROI", said Leonard Klejnow, Director of Business Development at Generix Limited.
Key Features of CONNX DataSync Transformation Server
"Datasync Transformation Server was designed with Ease of Use in mind from the very start. A common factor with other ETL solutions on the market, was the high learning curve and inability to incrementally synchronise data. Companies can now achieve this easily with one solution", said Anthony Lightfoot, Product Manager at Generix Limited.
CONNX 11 enables support for 64-bit Windows, Unique 32/64-bit bridge, RM/Cobol ISAM files and On Demand Connectivity.
CONNX Solutions, Inc., a leading provider of simplified data access management and integration software solutions, announces the release of CONNX 11. This release enables support for 64-bit Windows, Unique 32/64-bit bridge, RM/Cobol ISAM files and On Demand Connectivity.
CONNX 64-Bit Windows Support
CONNX enables you 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 64-bit or 32-bit applications.
CONNX 11 also provides a unique 32/64-bit ODBC/OLE DB Bridge which enables you to access 32-bit data sources from 64-bit applications, and 64-bit data sources from 32-bit applications.Speed and Ease Of Use Improvements
Support for RM/Cobol
CONNX now supports direct access to RM/Cobol ISAM files, in addition to Micro Focus ISAM files.IMS support for COBOL copybooks
In addition to importing IMS metadata directly from IMS data structures, the metadata can now be imported from COBOL copybooks.On Demand Connectivity
With the ‘On Demand Connectivity’ feature, CONNX will speed up the initial connection time to CONNX by only connecting to those databases specified within the query and not all of the databases it is currently accessing. As a result, you can now establish a faster connection through CONNX when accessing a large grouping of data sources, but only querying a few.
CONNX 10.5 SP3 includes expanded support for HP-UX 11i v2 on HP Integrity servers and support for the IBM® IMS DLI (Batch) Interface.
CONNX Solutions, Inc., a leading provider of simplified data access management and integration software solutions, announces the release of CONNX 10.5 SP3. This release features support for applications running on HP-UX 11i v2 on HP Integrity servers as well as support for the IBM IMS DLI (Batch) Interface and other enhancements.
CONNX Support for HP-UX 11i v2 on HP Integrity Servers
CONNX has been and continues to be a valuable tool for companies to access their HP-UX 11i data on HP Integrity servers and now extends that access to their applications. CONNX 10.5 SP3 gives companies the tools to enable HP-UX 11i applications running on Integrity to natively access off-platform enterprise data via JDBC or ODBC.
“CONNX gives application developers for HP-UX 11i on Integrity the freedom to seamlessly access off platform relational and non-relational data from any web engine or programming language,” said Larry McGhaw, the CTO & VP of Engineering at CONNX Solutions, Inc.
CONNX Solutions continues to offer the same secure, real-time, read/write, SQL access, and seamless joins between most legacy and relational databases on Integrity servers running HP-UX 11i for:
CONNX Support for IMS DLI (Batch) Interface
With this new release, CONNX also offers access to IBM IMS data through both ODBA and DLI (Batch) Interfaces, providing greater flexibility in accessing IBM IMS data with CONNX.
CONNX 10.5 SP2 enables support for Oracle Rdb and Oracle CODASYL DBMS for OpenVMS on HP Integrity Servers, expanded support of Microsoft SQL Server 2005 and other enhancements
CONNX Solutions, Inc., a leading provider of simplified data access management and integration software solutions, announces the release of CONNX 10.5 SP2. This release features support for Oracle Rdb and Codasyl DBMS for OpenVMS on HP Integrity Servers, expanded support of Microsoft SQL Server 2005 and other enhancements.
Support for Oracle Rdb and CODASYL DBMS for OpenVMS on HP Integrity ServersCONNX Solutions welcomes to its family of OpenVMS/HP Integrity server products, CONNX for Oracle Rdb and CONNX for Oracle CODASYL DBMS. CONNX already supports RMS and Oracle for OpenVMS on HP Integrity Servers.
Customers using CONNX for RMS on HP Integrity servers running OpenVMS have reported a significant performance increase over previous generations of servers, and customers using CONNX for Oracle Rdb and CONNX for Oracle CODASYL DBMS on HP Integrity servers running OpenVMS can experience a similar improvement in performance. CONNX Solutions has been offering RMS support on HP Integrity servers running OpenVMS since April 2005.
“With this update CONNX fully supports the HP Integrity platform for OpenVMS with all relevant data sources. We are pleased that customers are satisfied with the performance gains of using our products on this platform,” said Larry McGhaw, the CTO & VP of Engineering at CONNX Solutions.
With the addition of Oracle Rdb and CODASYL DBMS support on HP Integrity servers running OpenVMS, enterprise businesses can transition to a higher performance platform.
CONNX Solutions now offers the same secure, real-time, read/write SQL access and seamless joins between
most legacy and non-legacy databases on HP Integrity servers running OpenVMS for:
Expanded CONNX Support of Microsoft SQL Server 2005 with the following functions:
“CONNX now fully integrates with SQL Server’s SSIS and Analysis Services. We are pleased to satisfy the requests of our customers with this service pack,” said Bill Luton, Director of Engineering at CONNX Solutions.
Numerous feature requests have been implemented, including:
These and the many other features contained within this release add performance, functionality, and ease of use to CONNX. This release contains all previous enhancements and resolved issues.
CONNX Solutions Announces Support for Oracle Rdb and Codasyl DBMS for OpenVMS on HP Integrity Servers
CONNX Solutions, Inc., a leading provider of simplified data access management and integration software solutions, today announced support for Oracle Rdb and Codasyl DBMS on HP Integrity servers running OpenVMS. CONNX already supports RMS and Oracle on the same platform.
Customers using CONNX for RMS on HP Integrity servers running OpenVMS have reported a significant performance increase over previous generations of servers, and customers using CONNX for Oracle Rdb and Codasyl DBMS & CONNX for Oracle on HP Integrity servers running OpenVMS can experience a similar improvement in performance. CONNX Solutions has been offering RMS support on HP Integrity servers running OpenVMS since April 2005.
"With this update CONNX fully supports the HP Integrity platform for OpenVMS with all relevant data sources. We are pleased that customers are satisfied with the performance gains of using our products on this platform,” said Larry McGhaw, the CTO & VP of Engineering at CONNX Solutions.
With the addition of Oracle Rdb and Codasyl DBMS support on HP Integrity servers running OpenVMS, enterprise businesses can transition to a higher performance platform.
CONNX Solutions now offers the same secure, real-time, read/write SQL access and seamless joins between
most legacy and non-legacy databases on HP Integrity servers running OpenVMS for:
Generix showcases CONNX at DECUS DE symposium.
Generix Limited, will be showcasing CONNX which provides Simplified Data Access to enterprise data on HP systems at the DECUS DE symposium in Nurnberg 16th-20th April.
"Generix have been working with European customers and partners for over ten years and we are still seeing strong interest from loyal HP customers who value the investment they have made in their applications but want to leverage more from them," says Anthony Lightfoot, CONNX Product Manager at Generix Limited.
CONNX provides Simplified Data Access to enterprise data on HP systems via ODBC, OLE DB, JDBC and .Net to enable:
CONNX Solutions Announces Continued Commitment To OpenVMS on HP Integrity Servers.
CONNX Solutions, Inc., a leading provider of simplified data access management and integration software solutions, announced today that in Q.2, 2007, it will offer Oracle Rdb and Codasyl DBMS support for OpenVMS on HP Integrity Servers. CONNX Solutions currently supports RMS and Oracle on the same platform.
Customers using CONNX for RMS on HP Integrity servers running OpenVMS have reported a significant performance increase—two to three times faster than RMS running on Alpha Servers—and customers using CONNX for Oracle Rdb and Codasyl DBMS on HP Integrity servers running OpenVMS should experience a similar increase in performance. CONNX Solutions began offering RMS support on HP Integrity Servers running OpenVMS in April 2005.
“We are committed to supporting the HP Integrity platform with all related data sources and are pleased that customers are satisfied with the performance gains of using our products on this platform,” says Larry McGhaw, the CTO & VP of Engineering at CONNX Solutions.
With the addition of Oracle Rdb and Codasyl DBMS support on HP Integrity servers running OpenVMS, Enterprise businesses can transition to a higher performance platform.
Currently CONNX for RMS and Oracle on HP Integrity servers running OpenVMS provides secure, real-time, read/write SQL access to those databases and allows database users to perform seamless joins between RMS, Oracle and most other legacy and non-legacy databases. In Q.2, 2007, CONNX for Oracle Rdb and Codasyl DBMS on HP Integrity servers running OpenVMS will provide real-time, read/write SQL access to Oracle Rdb and Codasyl DBMS and allow seamless joins to be performed between Oracle Rdb, Oracle Codasyl DBMS and most other legacy and non-legacy databases too.
CONNX for RMS and Oracle on HP Integrity servers running OpenVMS is currently available for purchase. You can purchase CONNX for Oracle Rdb and Codasyl DBMS in the second quarter of 2007. Contact Generix Limited at +44 (0) 1924 500151 for pricing information.
“Today’s data centers increasingly rely on secure and easy access to management applications,” said Michelle Weiss, vice president of marketing, Business Critical Systems, HP. “The availability of CONNX solutions on HP Integrity servers running OpenVMS ensures our loyal customer base can maximize their investment while simplifying IT operations.”
CONNX Solutions Announces 10.5 Release
CONNX Solutions, Inc., a leading provider of simplified data access management and integration software solutions, announces the release of CONNX 10.5. This release features a CONNX adapter for the IMS database and support for the CONNX client running in a z/Linux environment.
The CONNX IMS adapter supports the following features:
“The IMS adapter for CONNX allows us to address the needs of larger enterprise customers with a vendor independent data access solution. Existing customers have asked for IMS connectivity”, said Pat Malone, VP Sales and Marketing, “and the ability to easily combine mainframe transaction information with relational or other enterprise data sources, without enormous reprogramming, or new database costs. This latest edition to the CONNX suite of enterprise database adapters gives senior management, a business analyst, or the line of business application developer, a powerful toolkit to integrate data from multiple sources for a comprehensive view of their business in real time.”
This new CONNX IMS adapter will allow users to:
This release also includes:
“We have had a high demand for our technology on the z/Linux platform, and I’m pleased that now we can deliver that solution. Our IMS technology is unique in the industry, because the installation and metadata collection is completely GUI based, enabling customers to get up and running in less than 1 hour.” said Larry McGhaw, the CTO at CONNX Solutions.
CONNX Solutions Announces 10.0 Release
CONNX Solutions, Inc., a leading provider of simplified data access management and integration software solutions, announces the release of CONNX 10. This release features a native Linux/UNIX implementation of the powerful CONNX SQL Engine, enabling Web services and Java applications to access enterprise data via a single server. Removing the “data federation” server previously required in mixed-platform environments reduces IT expenditures for the enterprise by reducing the complexity of hardware and software setup and deployment.
The CONNX SQL engine provides real-time and simultaneous access to a wide array of relational and non-relational data sources. The new CONNX Linux/UNIX SQL engine in Version 10 also includes a native JDBC server, which plugs in to the CONNX pure-Java JDBC Driver. Companies that use Linux, AIX, Solaris, or HP-UX as their primary operating system in the back office can now deploy applications that store data on an open system, on mainframes, and on Windows.
“CONNX 10 doubles our market opportunities with the newest release of the CONNX SQL Engine, since it enables CONNX to be deployed behind Web servers in Linux or UNIX environments with no additional server hardware. Many of our existing customers and development partners looking to standardize on a single platform have asked for this, to make them more competitive,” said Pat Malone, Vice-president of Sales and Marketing at CONNX Solutions.
CONNX has been an essential tool for many years for companies that want to preserve their investment in existing applications whilst enabling additional functionality using current solutions and tools. The CONNX Solutions, Inc., technology has traditionally been Windows-based, designed to function as a gateway to Java data sources. Companiesusing CONNX have been able to access and integrate legacy data with SQL-standards-based technology, thereby extending the functionality of their current Java applications and avoiding costly migrations. CONNX Version 10 brings companies the option to use a Windows platform or Linux/UNIX platforms for access to legacy information.
“This release is another step forward in our strategy to allow customers to choose the technology appropriate for their business needs, without getting locked into a particular vendor. Customers can now deploy applications on UNIX servers, Windows servers, or on the mainframe, and can use CONNX technology as the glue that ties all their corporate data together seamlessly,” said Larry McGhaw, the CTO at CONNX Solutions.
CONNX Solutions Announces 9.0 Release
CONNX Solutions, Inc., a leading provider of simplified data access management and integration software solutions, today announces the release of CONNX 9.0, the latest version of its flagship product.
The new release contains many major new additions.
It can be used in conjunction with Microsoft Visual Studio .NET or Visual Studio .NET 2003 to quickly develop Web applications.
New RPC functionality for VMS, OS/390, and VSE data sources has been included in the release. By adding SQL support, in addition to its existing OLE support, CONNX extends the reach of CONNX RPCs to ODBC, OLE DB, .NET, and JDBC. Additionally, the RPC input and output data can be cleanly mapped using the CONNX Data Dictionary utility.
This simplifies the RPC process and enables CONNX to automatically
perform data conversions and parameter marshalling.
Also New in 9.0 is support for VSAM / QSAM / PDS data sources in the CONNX for VSAM module, first included in CONNX version 8.7; as well as the newly completed CONNX for D-ISAM, and CONNX for MicroFocus COBOL modules, which provide secure, real-time, read/write access to D-ISAM and MicroFocus data on Windows, Solaris, HP-UX, AIX, Linux, and other UNIX platforms.
Additionally, numerous feature requests have been implemented,
including Java support for several new CONNX connection
parameters, increased performance enhancements to the
CONNX Data Synchronization tool, and support for the Barnard
TCP/IP stack, available now to users of the CONNX
for VSAM/VSE module. These and the many other features
contained within this release add performance, functionality,
and ease of use to CONNX. This release contains all previous
enhancements and resolved issues. Please see previous
release notes for enhancements contained within those
CONNX Solutions Announces 8.9 Release
CONNX Solutions, announced the release of the latest version of its flagship product, CONNX. CONNX 8.9 includes a number of significant performance and feature enhancements, giving companies the freedom to choose the open technology most appropriate for their business needs.
The list of new features in CONNX version 8.9 includes the following:
CONNX Solutions Announces 8.8 Release
CONNX Solutions announced the latest release of its industry-leading data access middleware product - CONNX 8.8. Included in CONNX 8.8 are a number of significant performance and feature enhancements. Support for an additional data source, VSAM VSE, which provides real-time, high-performance access to VSAM files under CICS partitions on the VSE operating system, has also been included in this release.
Direct support for Microsoft .NET technology also has been added to CONNX 8.8 with the introduction of a pure CONNX OLE DB Provider. Users will be able to achieve the performance of a native provider while writing their own applications in managed C# or VB .NET code.
The new release also includes a new product called the CONNX Data Synchronization Tool. The CONNX Data Synchronization software allows users to easily move enterprise data from any source location to any target data source. This Windows-based application employs a unique technique of hash keys to quickly detect when records are updated, deleted, or inserted. By storing these hash keys, along with the primary key of each record, in a separate CONNX private data store, the CONNX Data Synchronization software performs incremental updates from source to target at a fraction of the usual, full update speed.
CONNX Data Synchronization is ideally suited for creating and maintaining data warehouses and data marts. Once the target source is populated, CONNX can be used with other tools for ad hoc reporting, application development, and Web development. This engine provides the flexibility of querying either against the data warehouse and data marts or against the live operational data sources.
"The new CONNX Data Synchronization Tool has already generated a lot of excitement among our existing customers. It is the first tool that makes data synchronization fast and simple," said Larry McGhaw, Director of Product Development.
Tom Bennett from Brodart Corporation says, "The CONNX Data Synchronization tool allows easy and quick synchronization of our legacy data with SQL Server. Once the data is in SQL Server we can take advantage of modern reporting tools. The CONNX Data Synchronization tools combined with modern reporting tools has empowered our users with information and reduced our report creation time from weeks to hours."
Support for C-ISAM databases, which was included in the CONNX 8.7 release, has also been expanded to include Solaris 5.6 and above, as well as AIX 4.1 and above. Microfocus COBOL C-ISAM support has also been enhanced.
CONNX provides businesses secure read/write real-time access to all enterprise data from any platform as if all the data existed in one relational database. All data is then accessible using standard SQL and any standards-based application. CONNX acts as a reusable data access framework for projects throughout the enterprise. CONNX supports C-ISAM, VSAM, DB2, Oracle, RMS, RDB, PostGreSQL, DBMS, Dataflex, POWERflex, SQL Server, Sybase, Informix, and any OLE DB, ODBC or JDBC data source.
CONNX Supports C-ISAM with CONNX 8.7 Release
CONNX Solutions today announced the latest release of its industry-leading data access middleware product -- CONNX 8.7. CONNX 8.7 incorporates a number of significant performance enhancements in addition to support for an additional data source - C-ISAM files on AIX, SunOS, SCO, HPUX and Linux.
"CONNX 8.7 opens up the CONNX technology to the UNIX world of C-ISAM, providing a native, high-performance C-ISAM driver ," said Larry McGhaw, Director of Product Development.
CONNX Solutions' vision of one common data access interface to all data sources within an enterprise was extended by the release of CONNX 8.7 and its support for the C-ISAM database. While many standards such as XML attempt to solve the disparate database integration problem, most of these tend to rely on multiple products and messaging technology, or are so generic they cause tremendous manual effort to accomplish the task. CONNX differs by integrating databases in real-time and through one common, integrated interface product.
In general, legacy data sources such as C-ISAM are the backbone of enterprise computing. The Internet is creating a need in the enterprise (and throughout the industry) to be able to seamlessly access both relational and non-relational data sources as if they were stored in a single database. The CONNX architecture enables users to overlay common relational technology access on data sources within the enterprise, regardless of location, type, or hardware.
CONNX 8.7 also includes a new major feature, called Infonaut Professional. An easy to use query building and report writer wrapped into one tool. Additionally, CONNX 8.7 rolls out a native OLEDB provider, providing seamless integration with Microsoft's .NET technology platform.
CONNX Solutions CEO Douglas D. Wright described the need for InfoNaut Professional in the following statement: "Many of the reporting tools on the market today provide fabulous functionality... for those that need and understand that functionality. But there are those who do not have the need for complex capabilities - mainly business users and some developers - who just want to build a quick query that returns the information they need without having to go through a large product-learning curve. With non-InfoNaut products, the overabundance of features tends to slow down the process of accessing information."
CONNX Supports VSAM with CONNX 8.6 Release
CONNX Solutions announced the latest release of its industry-leading data access middleware product - CONNX 8.6. CONNX 8.6 incorporates a number of significant performance enhancements in addition to support for an additional data source - VSAM on OS/390 CICS.
"CONNX 8.6 is a significant release for CONNX Solutions both in terms of enhancements to our core technology in speed and usability as well as in extending our native database access to include IBM's VSAM legacy database," said Doug Wright, President and CEO of CONNX Solutions.
The addition of VSAM support to CONNX further enhances CONNX Solutions' vision of integrating all enterprise data sources into a single virtual database. While many solutions such as XML claim to accomplish disparate database integration, most of these solutions tend to rely on multiple products or messaging to accomplish this task. CONNX differs from this in that the integration is real-time and through one product. Since legacy data sources such as VSAM continue to be mission-critical in many organisations, despite the rise of relational databases, the CONNX strategy focuses on providing access first to "orphan" data sources. It then also provides access to other relational sources across the enterprise - representing them as a single data source. VSAM data sources are highly prevalent in those organisations that utilised IBM mainframes as their primary systems.
"CONNX 8.6 opens up the CONNX technology to the IBM world of VSAM, providing a native high performance CICS driver. Additionally, our existing RMS customers will enjoy the significant FTL performance enhancements in 8.6 when accessing multi-million row files," says Larry McGhaw, Director of Product Development.
CONNX 8.6 also marks the release of enhancements to CONNX's proprietary FTL (Fast Tuning Logic) technology, which provides transparent optimisation of nonoptimal queries created through reporting tools or direct user entry. Specifically, CONNX 8.6 is expected to return results four times faster than previous versions on queries run against RMS files that do not utilise an index. Additionally, CONNX 8.6 also allows the representation of multiple RMS files as a single database object
All users of CONNX will benefit from enhancements to InfoNaut - the CONNX query including instant grouping of query results and several UI improvements. InfoNaut allows CONNX users to simply and quickly generate queries against CONNX data sources without the overhead and complexity necessitated by other query tools and can be deployed throughout their enterprise with minimal effort and training.
CONNX Solutions CEO Doug Wright described the need for InfoNaut as follows: "Many of the reporting tools on the market today provide fabulous functionality … for those that need and understand that functionality. For those that do not - mainly business and developer end users who just want to build a quick query that returns the information they need NOW -- the overabundance of features in other reporting tools tends to slow down the process of accessing information."
CONNX 8.6 also includes the product enhancements including support for Linked (parent/child) CONNX data dictionaries, integrated NT security support, catalog support, additional SQL Server support, a GUI-based CONNX View builder, InfoNaut and 30 new statistical aggregate functions.
CONNX supports JAVA with CONNX® 8.3 release
Bellevue, WA, July 3, 2000:
CONNX today announced the release of the latest edition of CONNX® data access middleware - CONNX 8.3 - which will add support for the JDBC (Java Data Base Connectivity) standard enabling data access from any Java supported platform.
CONNX functions as a single master data access engine that gives users single point instant access to data from multiple enterprise sources - in real time without expensive programming or disruption to existing systems. CONNX acts as a data access framework, which allows data from multiple databases to be accessed as if it existed in one relational database. In addition to support for JDBC, CONNX also provides an ODBC interface to DB2, Digital RMS, Codasyl DBMS, Oracle Rdb, Oracle RDBMS, SQL Server, Sybase, Informix, DataFlex/PowerFlex, and any ODBC/OLEDB compliant data source. More than 3,000 organizations worldwide use CONNX products to reduce the development time and maintenance costs associated with using disparate databases.
This latest release of CONNX adds support for the JDBC standard as well as some significant performance enhancements. CONNX users can now access data sources from any platform that supports JAVA through a platform-specific Java Development Kit (JDK), including MacOS, Unix, Linux, OS/390, OS/400, and Alpha VMS. This can enable applications running on mainframes or non-windows platforms to access databases residing on other systems within the enterprise, as well as allow web users to securely access enterprise data served by non-windows web servers such as Apache or Netscape. JDKs for specific platforms are usually available for download on the platform vendor's website. A type 3 JDBC Driver is included in this release. CONNX 8.3 also marks the release of CONNX new FTL technology, which provides transparent optimization of non-optimal queries created through reporting tools or direct user entry. This technology is expected to provide users with significant performance gains when issuing queries against CONNX data sources. Benchmark testing has revealed performance increases of greater than 400% on the optimized queries. CONNX 8.3 also shipped with several new Java and Visual Basic-based sample applications designed to assist users in developing their own CONNX-based applications.
"CONNX 8.2 allowed organizations to integrate most backend data sources seamlessly. This latest version builds on that capability by allowing access from virtually any platform - making CONNX truly universal across client and backend systems," stated Jon-Jacques Umphrey, senior product manager for SolutionsIQ's Software Products Division.
"Many businesses have either intentionally or inadvertently adopted a 'best of breed' approach to systems. Integrating those systems in order to leverage their most accurate, up-to-the-minute data and create a complete picture of the organization is necessary to allow informed fast decisions. Technologies like data warehousing, XML and MOM (Message Oriented Middleware) all attempt to solve this problem by incrementally moving data. CONNX allows this to happen virtually, in real-time with out having to create and move data files around," Umphrey added.
CONNX announces new support for DB2 databases with the unveiling of CONNX® 8.2
Bellevue, WA, March 8, 2000:
CONNX today announced the launch of its new edition of CONNX® data access middleware - CONNX 8.2 - which will add support for IBM's recent and current versions of DB2 database on the following platforms: Linux; OS/2; Warp Server 4.0;Windows 95, 98, and NT 4.0; OS/400; MVS; and OS/390.
CONNX functions as a single, master data access engine that gives PC users instant access to data from multiple enterprise sources - in real time and without expensive programming or disruption to existing systems. CONNX is more than just an ODBC driver because it presents data from multiple databases as one relational database. In addition to support for DB2, CONNX also supports native access to Digital RMS, Digital DBMS, Oracle Rdb, Oracle RDBMS on all platforms, and DataFlex/PowerFlex. More than 3,000 organizations worldwide use CONNX products to reduce the development time and maintenance costs associated with using disparate databases.
The CONNX 8.2 DB2 Module can transform dynamic SQL statements into pre-compiled static SQL statements. This is a distinct advantage to system and database administrators, who can limit queries to only include static SQL statements, thereby ensuring faster and more secure database access.
The introduction of the dynamic SQL Cacheing feature also separates CONNX 8.2 from its competitors. Over the life of a connection, CONNX collects every SQL statement that has been executed at least once. If a statement is used again, CONNX can easily recognize and swiftly re-execute the statement. As the use of a statement increases, so does its performance and execution speed.
CONNX 8.2 supports stored procedure execution across all DB2 platforms. The stored procedures can be implemented in compiled languages such as IBM Assembler, COBOL, FORTRAN, PL/I, and RPG, or in interpreted languages such as Java or OS/400 CL. CONNX 8.2 for DB2 provides full support for stored procedures which return one or more result sets.
CONNX 8.2 implements the X/Open DRDA AR (Distributed Relational Database Access Application Requester) functionality. A full range of connectivity options is supported, including native TCP/IP via the Winsock API; APPC / LU 6.2 via third-party SNA vendor software, including Attachmate EXTRA!; IBM Communications Server 5.0 and 6.0; Microsoft SNA Server 4.0; Novell NetWare for SAA 4.0; and Wall Data RUMBA allowing IT departments the choice of connectivity option.
CONNX 8.2 supports OS/400 Command-Line execution from an ODBC client. When connected to an OS/400 target via any ODBC-compliant application and CONNX 8.2 for DB2, authorized users can submit OS/400 commands to the target host.
Because CONNX is open-standards based, it can be used by common PC applications such as MS Access, Excel, Word, Lotus, Cognos, Brio and Crystal reports, or development tools such as Visual Studio.
"One of the most complex challenges that businesses are faced with is finding a technology that allows them to leverage their most accurate, up-to-the-minute data so they can make smart, fast decisions and increase their business savvy," said Jon-Jacques Umphrey, product manager for CONNX.
"With CONNX, businesses don't have to limit themselves to the tools they use to access their DB2 and legacy data," Umphrey added. "CONNX allows enterprise users secure, transparent access to the data they need in real-time, regardless of its origin."
Because of the CONNX Common Data Dictionary®, CONNX allows end users to use their tool of choice to access data, and have it instantly presented as if it were all coming from a single, enterprise spanning, relational database. The Data Dictionary contains metadata about the source information and provides a GUI (Graphical User Interface) screen for easy management of metadata, security and views.
CONNX not only respects existing database security, it provides an additional level of security through individual user, group, row, field and table security options. Additionally, the CONNX Data Dictionary is encrypted to secure sensitive information.
CONNX is currently available for Digital RMS, Digital DBMS, Oracle Rdb, Oracle RDBMS on all platforms, SQL Server and DataFlex/PowerFlex. A recently released OLEDB Adapter Module provides support for any OLEDB or ODBC compliant data source for which a CONNX module does not already exist. Direct Support for Sybase, Informix, CISAM and VSAM databases is scheduled for release in April 2000.
Azure, RMS, Oracle Rdb, VSAM, IMS, C-ISAM, D-ISAM, Micro Focus, DB2, Oracle, Oracle DBMS, Dataflex, POWERflex, SQL server and any OLEDB or ODBC data source.
CONNX is used by more than 3000 organisations world-wide to enable web/application development, data warehousing, business intelligence, ETL, replication, data synchronization, enhanced reporting and data migration.