Generix
telephone +44 (0) 1924 500 151
products
evaluation
faq
support
contact
news
solutions
home
News

  • 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 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 Announces Support for Oracle Rdb and Codasyl DBMS for OpenVMS on HP Integrity Servers.

  • Generix Limited showcases CONNX at DECUS DE symposium.

  • CONNX Solutions Announces Continued Commitment To OpenVMS on HP Integrity Servers.

  • CONNX 10.5 enables Real-time IMS Data Access and Unlocks Enterprise Data on the z/Linux Platform.

  • CONNX 10.0 enables Real-time UNIX/Linux Data Access.

  • CONNX 9.0 enables additional support for .NET, D-ISAM, MicroFocus COBOL and Adabas.

  • CONNX 8.9 enables additional support for VSAM files and the CONNX Data Synchronization tool, for Enterprise Data Replication.

  • CONNX 8.8 enables support for VSAM files on VSE platforms. A native CONNX OLE DB provider and the CONNX Data Synchronization tool, for Enterprise Data Replication.

  • CONNX 8.7 enables support for C-ISAM files

  • CONNX 8.6 enables support for VSAM files

  • CONNX 8.3 enables support for JAVA

  • CONNX 8.2 enables support for DB2 databases



    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.
    February 2008

    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 for C-ISAM

  • CONNX for D-ISAM

  • CONNX for DB2

  • CONNX for Micro Focus

  • CONNX for Oracle


  • 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
    August 2007

    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 Servers
    CONNX 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:

  • CONNX for RMS

  • CONNX for Oracle Rdb

  • CONNX for Oracle Codasyl DBMS

  • CONNX for Oracle


  • Expanded CONNX Support of Microsoft SQL Server 2005 with the following functions:

  • SQL Server Integration Services (SSIS)
    Users are now able to transfer data to and from CONNX supported databases and Microsoft SQL Server 2005, using SSIS capabilities, including data transformation. Please note that if complex data transformations are required, SSIS is the suggested tool. However, if high speed incremental data synchronizations are required, CONNX Data Synchronization is still the tool to use for incremental updates from legacy data sources.
  • Analysis Services
    CONNX now supports the creation of dimensions and cubes, which enables users to take advantage of Microsoft SQL Server 2005 data mining capabilities.

  • Linked Servers
    In addition to running an in-process linked server, CONNX can now function as an out-of-process linked server.

  • “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:

  • Alternate Index Support for CONNX for IBM® VSAM when Running as a Started Task
    Along with IBM VSAM alternate indexes through IBM® CICS®, CONNX now supports IBM VSAM alternate indexes when running as a Started Task on OS/390 or z/OS.

  • TextDBMS Support
    CONNX now supports compressed Text data encoding for IBM VSAM, often used by legislative software packages.

  • Enhanced COBOL Copybook Support
    CONNX has extended computational fields support within the COBOL FD import.

  • Expanded Support for CONNX for IBM® IMS
    CONNX for IBM IMS can now import metadata directly from PSBs, DBDs and ACBs.
  • 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
    August 2007

    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:

  • CONNX for RMS

  • CONNX for Oracle Rdb

  • CONNX for Oracle Codasyl DBMS

  • CONNX for Oracle


  • Generix showcases CONNX at DECUS DE symposium.
    March 2007

    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:

  • Web/Application Development

  • Data Warehousing

  • Business Intelligence

  • Data Synchronization

  • Enhanced Reporting

  • Data Migration


  • CONNX Solutions Announces Continued Commitment To OpenVMS on HP Integrity Servers.
    February 2007

    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
    September 2006

    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:

    • Native Java™ and WebSphere® support.
    • GUI based import of PSBs (Program Specification Blocks) into CONNX metadata.
    • Multiple PSB support of joins across multiple IMS hierarchies.
    • RACF/Top Secret security
    • Full transaction support that performs inserts, updates and deletes in a complete unit of work.

    “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:

    • perform seamless joins between IMS and one or more of the CONNX supported disparate databases using ODBC, OLE DB, JDBC and .NET. In addition, those adapters allow CONNX to provide secure, real-time, read/write access to IMS data.
    • view data as if it existed in a single federated relational database, in which secure read/write real time access to enterprise data sources is provided.
    • be security conscious, because CONNX respects all existing database security and the 128-bit encrypted CONNX Data Dictionary (CDD) guarantees the security of sensitive information.

    This release also includes:

    • a native z/Linux implementation of the powerful CONNX SQL Engine, enabling deployments of all of the CONNX technology on the mainframe under z/Linux, including both JDBC and ODBC support.
    • significant enhancements for users of the Adabas SQL Gateway, including improved use of descriptors (indexes), and multi-fetch technology, which results in greater performance.

    “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
    November 2005

    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
    November 2004

    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.

    "This release demonstrates continued efforts to enhance our software for our customers and to address the expanding requirements of the Enterprise Information Integration (EII) marketplace," says John Andrews, V.P. of Sales and Marketing at CONNX Solutions, Inc.

    The CONNX .NET Data Provider is officially included in this release.

    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.

    New Data Types
    CONNX now has more than 400 data types, some of which have been custom-made to customer specifications.

    New Data Sources Supported
    CONNX 9.0 includes support for Adabas, a high-speed Software AG database system.The new product is called the Adabas SQL Gateway, also known as CONNX for Adabas.Through the Adabas SQL Gateway, Software AG's Adabas customers will be able to boost productivity by accessing data directly from Adabas through popular PC-based SQL reporting tools such as Business Objects, Crystal Reports, or Excel spreadsheets.The initial release of the product supported Adabas on IBM OS/390 and z/OS platforms, as well as Adabas for Windows. The second release, which will be available by the end of the year, includes support for the 64-bit AIX platform and many new features, including a precompiler (Adabas users only) and support for Dynamic DDL.

    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 versions.

    CONNX Data Synchronization Tool for Changed Data Capture
    The CONNX Data Synchronization Tool for Changed Data Capture was introduced with CONNX 8.8. This software system allows for automatic creation of reporting servers, load balancing, and heavily automated database migrations, as well as many other potential uses. In CONNX 9.0, many performance enhancements have been added that increase functionality and speed.



    CONNX Solutions Announces 8.9 Release
    July 2003

    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.

    CONNX facilitates the access of data regardless of where it physically resides. CONNX enables organizations to unlock legacy, relational and desktop data sources so business decisions can be made. CONNX provides real-time read/write access to disparate data sources from a single point of connection as if it were a single database.

    The list of new features in CONNX version 8.9 includes the following:

    - Support for access to VSAM files under Batch Job / Started Task

    Prior to CONNX 8.9, access to VSAM was limited to CICS. In some cases, however, during nightly batch processes, the CICS regions are brought down for maintenance. Now, with the support of VSAM using MVS Started Task technology, companies can provide 24/7 access to VSAM data.

    - CONNX Enterprise Server Service


    The CONNX Enterprise Server Service technology simplifies the deployment of CONNX in both small and large organizations. In cases where CONNX uses the vendor’s native database driver to access data (for example, in Oracle or SQL Server databases), configuration and setup of those drivers takes place on a single middle-tier server, instead of on each client PC. With the Enterprise Server Service, CONNX seamlessly provides a single client-install solution for data access needs throughout the enterprise.

    - Performance and GUI enhancements to the CONNX Data Synchronization tool

    The CONNX Data Synchronization software enables users to easily move enterprise data from any source location to any target data source. This Windows-based application employs a unique proprietary technique to quickly detect when records are updated, deleted, or inserted. After detecting altered data in the data source file, the CONNX Data Synchronization tool performs incremental updates to the target without ever having to reload the entire data source file. This time-saving technology demonstrates unbeatable performance gains over similar tools as it enables data to be moved up to 10 times faster than a typical complete reload of the data.

    - Accelerated performance

    CONNX has been further fine-tuned to provide faster performance when accessing flat-file data sources, such as C-ISAM running on Linux, AIX, HPUX, SCO, Tru64 or Solaris operating systems.

    - XML-based query tool

    CONNX 8.9 includes Infonaut Professional, which has unique query analysis and optimization features, making it ideal for use during the development cycle. Infonaut exports query results in XML, Microsoft Excel, CSV, or text files.

    Since the release of the CONNX Data Synchronization tool, customers have been using the product to build relational-to-relational as well as nonrelational-to-relational data marts and data warehouses. The CONNX Data Synchronization tool is optimized to operate efficiently over wide area networks (WANs), a requirement when pulling data from different locations into centralized target databases. The CONNX Data Synchronization tool also plays an integral role when migrating data from one data source to another.

    "CONNX Solutions has leveraged its flagship CONNX technology of integrating all of the information within an organization under a single common methodology, and now has added an extremely useful tool to take advantage of that power and ease of use, making the CONNX Data Synchronization tool an instant hit with our customers," says Douglas D. Wright, President/CEO of CONNX Solutions.

    "Our customers are moving 142 million rows of data in a little over 2 hours. They are avoiding expensive and lengthy custom coding cycles and are integrating our unique capabilities with the major ETL tool vendors, such as Ascential, Informatica, and Embarcadero. Estimated savings include one dedicated technical resource, 4 months of time, and thousands of dollars on the initial setup," says Shirley M. McKinney, Director of Sales, for CONNX Solutions.

    CONNX Solutions also reconfirms its commitment to open technologies, such as Web Services, XML, JMS, and SOAP. CONNX customers are actively using the product in a wide range of open technologies, and CONNX is constantly ensuring easy integration and compatibility with various technologies.




    CONNX Solutions Announces 8.8 Release
    December 2002

    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
    April 2002

    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
    August 2001

    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.

    CONNX SUPPORTS
    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 enhanced reporting, business intelligence, web/application development, data warehousing, synchronization and migration.


    Click here to request an evaluation and realise how your organisation can benefit from using CONNX
    overview
    architecture
    details
    case studies
    info request
    e-Vantage
    KEA!
    nu/TPU
    TeVISTA
    C-ISAM
    D-ISAM
    DataFlex
    DataSync
    DB2
    Desktop Adapter
    OLEDB Adapter
    infonaut
    informix
    microfocus
    Oracle
    DBMS
    Rdb
    powerflex
    RMS
    SQL
    Sybase
    VSAM