CONNX Version 12.5 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 can be made. If you're basing decisions on stale data your company will always be a few steps behind. Likewise BI reporting and analytics tools are most useful if they provide access to the most up-to-date data and information.
InstantdbSync replication now includes MySQL as a real-time source. We created a new native CONNX MySQL Driver. Users of MySQL can now benefit from all the real-time tools provided by InstantdbSync. Along with MySQL, we've added support for selectively un-deploying replications from the Deployed Replications Tab.
ACD (Add, Change, Delete) 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 defined, 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 for Excel Pro
The Add-on Pro for Excel tool allows for a 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 capability to view and extract data with full Excel capability without any worry of altering the source data. The CONNX wizard will allow a streamlined connection and data selection for 150+ supported db/platforms. Enhanced Excel reporting allows for connection to multiple data sources and allows joins between tables from different data sources. Just open Excel, and in two clicks you'll have streamlined accessibility wherever your data resides.
For CONNX Version 12.5 we've added Read/Write capability. In previous versions users only had the ability to import their 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. While this feature is still in place, we've added the write function which allows higher lever users the ability to make changes to your data, safely and easily using Excel.
Our Mobile BI Application CONNX KPiSync helps users Visualize Key Business Metrics on any device in real time. For CONNX Version 12.5 we've added a new granular licensing option. The new functionality allows the customer to create quotas for users and usage, so you can regulate the number of pushes, number of users, or number of KPis by users.
CONNX KPiSync keeps you in touch with your critical business information from any corporate application or data store, any time, all the time, 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 which will query your enterprise data. These indicators are then pushed to your desktop, laptop, tablet, or mobile devices, using our secure hosted cloud based solution.
We've also added an SMTP mail feature to allow mail to be sent when a KPi is pushed or if an error occurs.
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 Adapter.
- Enhanced support for Teradata
- Improved support for Adabas mixed case FDT's and schema timestamp when importing tables.
- IMS Enhancements
- Descending/ascending indexes upgrade for DataFlex.
- Greater support for RDB on Itanium systems.
Many, many, more
Several smaller features have been added to CONNX 12.5 as well. Please read the Release Notes for a full description.