New Data Integration Engine for Synchronization. Expression Editor Improvements
We are glad to announce that our new data integration engine is finally available for Synchronization packages. With this update, you can benefit from Agent connections and other engine improvements in all kinds of data integration packages: export, replication, import, and synchronization. Additionally this update includes significant improvements for expression editor.
The new data integration engine is yet in beta status and is not used by default. You need to explicitly enable it in your packages, by selecting the Use New Runtime check box.
However, if you want to switch an existing package that uses expression mapping to a new runtime, you will need to review the expressions used and rewrite them to the new syntax.
Expression Editor Improvements
Expression editor has became more functional than it ever was. Now it allows you not only to design your expressions, but also to validate them and check them against test data. You can check if your expression is valid with a single click of a button. Editor not only immediately displays whether the expression is valid, but also underlines parts of your expression that cause errors. You can point at these parts and see error messages and quick fixes, if they are available.
Additionally, you can now immediately try your expressions with test data. Just click the Preview button and specify test values for columns used in the expression or select the null check box for them, and immediately see the expression result. You can thus check your expression and see whether the expression results correspond to your expectations without running the package.
Expression editor is now available for synchronization packages, using new runtime as well as for import packages.
Agent Connection Support
Agent connections greatly simplify connecting to on-premise databases in local networks, using a secure locally installable Agent application as a tunnel for loading data. And finally, you can use agent connections in all kinds of integration packages, including synchronization packages, using new runtime.