Category | Data Integrator 9 | DataConnect 11 |
New Feature | N/A | REST API Invoker 3.0, an easy-to-use and standardized approach for RESTful web service APIs |
New Feature | N/A | Engine execution profiler that provides immediate, interactive performance feedback |
New Feature | N/A | Built-in XML and Text editors for power users to directly modify metadata |
New Feature | N/A | Content assist in the script editor (a.k.a. code completion) |
New Feature | N/A | Reject connection tab that improves ease of use |
New Feature | N/A | Macro enhancements, including optional support for macro sets and encrypted values |
New Feature | N/A | Improvements to the “Search and Replace” functionality and Help system |
New Feature | N/A | Studio SDK for creating your own custom mapper or process designers |
Design Studio | Collection of 32bit VB and Java tools | Consolidated 64-bit IDE built on Eclipse framework |
Design UX | “The standard” | All-around navigation and functionality improvements |
Metadata Repository | Workspaces and Repositories | Workspaces and Projects (terminology only) |
Upgrade / Migrate | Import v8 artifacts directly | Import v9 artifacts directly |
Packaging | Command line interface utility | Graphical User Interface within the IDE |
Management | Limited on-prem server and browser UI | DataCloud Actian Hybrid Integration Manager (on-prem in Q4) |
Versioning | Major version is user defined, Minor version incremented on save. Bring your own version control. | Major version is user defined, Minor version incremented on save. Bring your own version control |
Reporting | Design metadata reports | Search (and replace) is vastly improved. Reporting to come in subsequent releases |
Semi-structured Text | GUI Designer to generate CXL script, Connector | CXL script, Connector |
Joins | GUI and Connector | Use Process workflow |
SDKs | Java, COM, CLI | Java, CLI |
Connector “bitness” | 32bit and 64bit connectors | 64-bit only - requires updating client drivers such as ODBC and MS Access |
Documentation | Separate interface, PDF documents | Integrated Help system |
Process Design metadata | 3rd party library “BLOB” field | Readable XML text using coordinates |
Metadata language | XML | XML |