Release Announcement April 2021 - CONNX

CONNX offers 150+ database adaptors that helps you access data from multiple data bases and multiple platforms in real time. It offers data virtualization, ETL and data replication solutions so you can meet demand for your high-value data. With CONNX, you can provide secure self-service access from desktop tools, support real-time dashboard reporting or move/replicate your data to analytic platforms or data lakes in the cloud. With CONNX’s direct database integration, you can get up and running fast within hours of connecting your source and target.

The CONNX 14.5 release features a new easy-to-use web interface for its data replication tool – DataSync. While this will replace the original Windows GUI (now called DataSync Classic), both versions are included in this release to give you a little time to make the transition.

This release is now equipped with a REST Interface that can be called from the new DataSync web GUI or from any REST application. The functions Transformation Export, Import and Duplicate are now included in DataSync as well as the ability to support nested comments in SQL Queries. For those looking for more flexibility, you can now change server name and port from a script and command line with CDDMove.exe.

If you are looking to take advantage of the hottest new data lake in the cloud, this release of CONNX offers a new DB Adapter for Snowflake®. Now you can easily replicate your data from 150+ data sources on any platform to the cloud and keep them both in sync, empowering you to truly operate in a hybrid environment. To build on a hybrid data lifestyle, you can now use a replicator controller for LUW in the cloud while the Admin is on premises.

SQL Server 2019 is now available as a source for InstantdbSync and open systems Event Replicator.

CONNX 14.5 Feature highlights

CONNX   CXA 14.5  
  • New easy to use web-based interface for DataSync
  • Full REST API access to DataSync functions for application integration
  • New Snowflake Adapter so you can easily sync 150+ data sources with the leading data lake in the cloud
Add-on for Excel    
  • New configuration setting EXCELADDINNOSAVEPASSWORD - when set to 1, the ability to save the password to the ODC connection file is disabled. The user will have to log in every time a connection is loaded or refreshed
Data Dictionary    
  • Enhanced CONNX Data Dictionary includes a new Null Suppression to the list of information about each column
  • Added CURRENT_USER and SESSION_USER functions
  • Optional Registry setting under CONNX\DATASYNC - ONDEMANDCONNECTIONONLY, if it is not there or set to 0 then DataSync operates as it always has by doing a full connection when a CDD is chosen to see if it is valid.
  • If the Software AG ONDEMANDCONNECTIONONLY is set to 1 then DataSync will never do a full connection, only an on-demand connection.
  • Optional JDBC connection string syntax: ADADBIDLIST=(:,:,…)
  • New JDBC connection string syntax: ADADBIDLIST=(:,:,…)
Connectivity & Movement Additions    
  • 3 new functions for trimming all whitespace characters not just spaces: LTRIMWHITESPACE, RTRIMWHITESPACE and TRIMWHITESPACE
  • Configuration setting ADABAS\JOINMUDESC to permit the old (incorrect) join behavior of allowing joins on MU descriptors
  • New packed complement data type
  • New function called REMOVENULL will remove any embedded nulls from a string value - this works for both Unicode and ANSI character sets
  • AutoBulkUpdate feature
  • Log new connections to the console for CICS
  • Packet Tracing feature
  • Optional setting ALLOWTRAILINGSPACEINVARCHAR to enable VARCHAR to accept trailing spaces as in CONNX 8
  • Ability to specify a view clause during Adabas DDL imports
  • Full support for replicating source tables to different owners for target tables in a database. Previously, separate owners in replication was partially supported - only for existing tables. Now Target tables in replication can be created under different owners in a database.
  • Support for AIX sha256 and AIX sha512
  • EntireX driver added a registry setting called MAX_WAIT_MILLISECONDS that defaults to 1000000 milliseconds (1000 seconds) as the longest to wait for a slow transaction to complete