CONNX Version 13 is loaded with features that we believe give our customers even more capabilities and greater control of your data, wherever it resides.
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 uptodate information available.
InstantdbSync replication now includes MySQL as a realtime source on Windows® as well as Linux®. With a new native CONNX Driver for MySQL, as a user of MySQL you can now benefit from all the realtime tools provided by InstantdbSync. In addition, you can selectively undeploy replications using the Deployed Replications Tab.
ACD Replications is a special type of replication that tracks 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. New in CONNX 13 is added ACD support for MySQL and Adabas as a source.
Add-on Pro for Excel
The 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 Addon 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.
New in CONNX 13, Addon for Excel now allows editing of filtered data sets. More specifically data sets generated with SQL Statements containing "where" criteria.
Our Mobile BI Application CONNX 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 cloudbased solution.
You also can send mail when a KPi is pushed or if an error occurs using the new SMTP feature.
SQL Server 2016 Support
CONNX offers full support for the new SQL Server 2016 that helps you 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. Additionally CONNX supports SQL Server 2014, SQL Server 2012, SQL Server 2008, SQL Server 2005, SQL Server 2000, including clustered index support on supported SQL Server versions.
Database 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.
- Descending/ascending indexes for DataFlex®
- Relational databases on Intel® Itanium®
- Added IBM® z/OS® passphrase support
- ES17649allows user to bypass cap in JDBC® server
Changes to Adabas Support
- InstantdbSync ACD support for Adabas as source
- Support for Adabas SSX security on LUW
- Mixedcase FDTs and schema timestamp, when importing tables
- Adabas timestamp with timezone support
- New support for building Adabas sample tables
Many, many, more
Several smaller features have been added to CONNX 13 as well. Please read the Release Notes for a full description.