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

  • CONNX for Java EE™ enables organisations to create high performance enterprise-wide applications.

  • CONNX 11.5 now includes support for SQL Azure, SQL Server 2012, SAP Hana, SAP Max DB and new platform support.

  • 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 Announces Release of CONNX DataSync Transformation Server.

  • CONNX 11 enables support for 64-bit Windows, Unique 32/64-bit bridge, RM/Cobol ISAM files and On Demand Connectivity.

  • 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 for Java EE™ enables organisations to create high performance enterprise-wide applications.
    January 2014

    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 SQL

    A 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 Sharing

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

    Summary

    CONNX 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.
    February 2013

    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 Support

    CONNX 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 SSIS

    The 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:
  • Saves time – Incremental updates are faster than full loads
  • Allows the target to stay “live” 24/7
  • Removes the limitation of SSIS packages only running during a batch window
  • Enhanced Audit capability – Ability to track changes compared to full dump and load

    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 Support

    CONNX 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 Support

    CONNX 11.5 now provides full support for SQL Server 2012 in addition to SQL Server 2008, SQL Server 2005, SQL Server 2000.

    New Platform Support

    The following platforms have been added to CONNX 11.5:
  • 64-bit Micro Focus server on Solaris
  • 32-bit RMCOBOL server on HPUX and Solaris
  • 64-bit DISAM server on AIX, HPUX RISC, HPUX Itanium, Linux on Intel and Solaris
  • 32-bit DataFlex server on Linux


    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.
    October 2011

    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.

    Metadata Comparison Tool

    One of the key features of CONNX that makes enterprise information integration possible is our unique metadata repository, called the CONNX Data Dictionary (CDD). CONNX 11 SP3 delivers the CDD Comparison Tool, a new metadata comparison tool. The CDD Comparison Tool, quickly identifies differences and changes in metadata and can be used as part of a pro-active change control mechanism as well as a diagnostic facility.

    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

  • Performance when retrieving Oracle data is up to 2X faster.
  • Many queries now perform up to 10% faster.
  • InfoNaut now displays any size result set.
  • Improved compatibility with SQL Server 64 bit.
  • Improved compatibility with MySQL.

    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.
    September 2010

    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

    • Ease of Use – Intrinsic GUI allows users to complete a synchronization build quickly without extensive training.


    • Live Incremental Updates – The Change Data Capture (CDC) technology in CONNX enables replications of complex transformations, including joins, unions, and aggregations, incrementally. This means that data can be updated throughout the day without any disruption of the source tables, or the target tables. The Target tables are not dropped and repopulated, so users can continue to query the data uninterrupted.


    • SQL Data Access Engine – Easily solves the complex problem of accessing and joining dissimilar data stores residing on UNIX, Windows, OpenVMS or Mainframe servers by leveraging our secure, scalable and time-tested SQL Data Access engine.


    • "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.
      September 2009

      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.

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

      Unique 32/64-bit ODBC/OLE DB Bridge

      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

    • Performance for CONNX server components has been increased up to 20%, and a reduction in CPU usage.

    • Infonaut/Professional 64-bit support which includes a new query builder.

      Expanded SQL Support Improvements

    • Expanded SQL Support in CONNX Views
      CONNX Views now supports SQL Distinct, Aggregates, Unions, Subqueries, and Subtables.


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


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


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


    Click on the CD 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