What’s new in CONNX 12.5

Gain greater control of your data wherever it resides

The latest release of the CONNX is now available! CONNX12.5 is loaded with new features that give you even more capabilities and greater control of your data, wherever it resides.

Issue 1, 2017 Download PDF

Improvements across CONNX portfolio

Make the best decisions based on the latest data. That’s one reason why you’ll like CONNX 12.5. Our real-time replication tool, InstantdbSync, functions even smoother and now allows those with MySQL® to utilize this real-time solution. A new type of replication—Add, Change and Delete (ACD) replication—tracks operations against a database rather than replicating data itself, offering a synopsis of the transaction log, which can be very helpful in some DataSync replication environments.

Use our data visualization tools? You’ll like the Add-on Pro for Excel® which is now equipped with read/write capabilities. A new granular licensing option for KPiSync allows you to create quotas for users and usage.

Of course, we have also added even more databases and platforms to the largest set of database adapters in the industry—CONNX DB Adapters.

New! Full support of SQL Server 2016

CONNX 12.5 now offers full support for Microsoft SQL Server 2016 so that you can build intelligent, mission-critical applications using a scalable, hybrid database platform that has everything built in, from in-memory performance and advanced security to in-database analytics. In addition, CONNX supports SQL Server 2014, SQL Server 2012, SQL Server 2008, SQL Server 2005 and SQL Server 2000, including clustered index support on supported SQL Server versions.

DB Adapter enhancements

Transparent bulk load for DB Adapters is a new, optional feature that improves the performance of the DB Adapter by buffering individual database inserts. Bulk load technology is used to insert the entire buffer with one write.

IMS™ enhancements include a setting change that allows NULLS to be inserted, which is useful for IMS variable length segments, and ROLLBACK works for IMS with DLI (batch) interface. There is also secondary index support for IMS.

Additional enhancements include improved support for:

  • Teradata®
  • Adabas mixed-case FDTs and schema timestamp, when importing tables
  • Descending/ascending indexes for DataFlex®
  • Relational databases on Intel® Itanium® systems

InstantdbSync now includes MySQL as a source

Business today moves at incredible speeds, so the fresher the data, the better the decisions you can make. If you’re basing decisions on stale data, your company will always be a few steps behind. Likewise, business intelligence reporting and analytics tools are most useful if they provide access to the most up-to-date information available.

InstantdbSync replication now includes MySQL as a real-time source. Using a new native CONNX MySQL Driver, as a user of MySQL you can now benefit from all the real-time tools provided by InstantdbSync. In addition, you can selectively undeploy replications using the Deployed Replications Tab.

New ACD Replications

ACD Replications are a special type of replication that track the operations done against a database rather than replicating the data itself. When an ACD Replication is selected, a source table is defined and a special ACD target table is created in the target database. The event producer will now monitor the source database for any transactions against the table specified in the ACD Replication and a record will be inserted into the ACD target table specifying each operation (add, change or delete) that occurs for the transaction. The ACD target table is a transaction log for the specified source table.

Add-on Pro for Excel

Add-on Pro for Excel allows for quicker and easier data access to any data source within Microsoft® Excel®. If you prefer Excel for viewing, reporting and manipulating your business’ data, then this is the perfect solution for fast and reliable access. With Add-on Pro for Excel, any user has the ability to view and extract data with full Excel capabilities without any worry of altering the source data. The CONNX wizard allows a streamlined connection to be established and data selection for 150+ supported databases and platforms.

Connect to multiple data sources and create joins between tables from different data sources using enhanced Excel reporting. Just open Excel, and in two clicks you’ll have streamlined accessibility wherever your data resides.

Expand access to data securely with the read/write capability. In previous versions, you had to import data into Excel and manipulate it. This feature was implemented for security reasons to uphold the integrity of your data and give a wider scope of users in your organization access to your data without worry. In addition to this feature, you can use the “write” function, which gives high-level users the ability to make changes to their data, safely and easily using Excel.


Our mobile business intelligence application, KPiSync, helps you visualize key business metrics on any device, in real time. A new granular licensing option allows you to create quotas for users and usage, so you can regulate the number of pushes, number of users or number of KPis by user.

CONNX KPiSync keeps you in touch with your critical business information from any corporate application or data store, any time, all the time, in real time, whether you are in the office, on the go or at home. KPiSync makes it simple to keep track of your critical business metrics simply by defining a key performance indicator that will query your enterprise data. These indicators are then pushed to your desktop, laptop, tablet or mobile device, using our secure, hosted cloud-based solution.

You also can send mail when a KPi is pushed or if an error occurs using the new SMTP feature.

Learn more

Learn more about why Software AG acquired CONNX to secure access to critical data integration and replication technology to support the Adabas & Natural 2050 agenda in Harpal Gill’s TECHniques article CONNX Data Virtualization: Securing the Adabas & Natural 2050 Agenda and the webinar Data Virtualization: Securing the Adabas & Natural 2050 Agenda powered by CONNX.

Get details about how CONNX products can give you even more capabilities and greater control of your data, wherever it resides with CONNX Data Replication, CONNX Data Virtualization and CONNX Data Visualization,