Altova MissionKit Enterprise Edition 2020

Adds new JSON Grid Editor, Chart creation from JSON data and XULE support for XBRL.
October 09, 2019 - 10:47
New Version

Features

Altova XMLSpy XML Editor

  • Revolutionary new JSON Grid Editor.
  • Chart creation from JSON data.
  • JSON Lines and JSON Comments support.
  • XULE support for XBRL.

Altova MapForce

  • Support for OAuth 2.0 in Web services calls - OAuth 2.0 is an open standard for authorization that provides a way to provide client applications secure, delegated access to web resources using access tokens rather than passwords. In response to popular demand, it is now possible for MapForce mappings to call Web services that require OAuth 2.0 authorization. This is enabled in the Credentials Manager (opened by right clicking in an active mapping project). OAuth authorization details can be transferred to other execution environments such as MapForce Server and FlowForce Server with the help of credential objects.
  • Support for JSON Lines - Mapping data to / from JSON is now also supported for files in JSON Lines format (see a description of JSON Lines in the XMLSpy section above). Developers are increasingly choosing JSON Lines as a data export format and support in MapForce enables them to integrate it seamlessly.
  • Value Map configuration via copy/paste - The Value Map component lets you replace one value with another (such as replacing 1, 2, 3 with January, February, March) using a predefined look-up table. Starting with MapForce 2020, it’s possible to paste tabular data (key-value pairs) from external sources such as CSV or Microsoft Excel into the Value Map table.
  • Extended options for Value Map component - The Value Map component allows you to define an “Otherwise” value to map to the target when an input value is not found in the pre-defined look up table. Now, in addition to providing defining a specific value to map in this case, you can select Original Input Value to simply pass the original source value, unchanged, to the target. This is helpful, for instance, when you only need to transform a few of the input values and want to leave all the rest unchanged.
  • Database schema independency - If a user has multiple similar database structures isolated under different database schema names, it is now possible to reuse a mapping designed with one schema for another.
  • Extended support for Oracle packages - For database mapping, MapForce supports stored procedures as input components (procedures that provide results) or as output components (procedures that insert or update data). Or, stored procedures may be inserted as a function-like call allowing users to provide input data, execute the stored procedure, and read/map the output data to other components. In the case of Oracle databases, stored procedures or functions may be standalone or part of Oracle packages. Now, you can add both categories to the mapping.
  • Support for additional database versions - MapForce supports mapping data in any of the most popular databases, and in this release support is added for new versions of:
    • Microsoft SQL Server 2019
    • Microsoft Access 2019
    • Oracle 18 and 19

Altova StyleVision

  • XPath Debugger and new XPath dialog - Defining and testing XPath expressions in StyleVision just got even easier with a redesigned XPath dialog and new XPath Debugger. The new XPath dialog offers a streamlined view of data sources, XPath operators, and XPath functions for point-and-click expression building and testing. An integrated XPath Debugger makes it easy to test and troubleshoot complex XPath expressions during report creation to save time and reduce frustration. New toolbar buttons let you go step by step through the evaluation of each XPath expression and examine the results returned for each step.
  • Support for additional database versions - StyleVision and all database-enabled Altova products now support the latest version of the following databases:
    • Microsoft SQL Server 2019
    • Microsoft Access 2019
    • Oracle 18 and 19
  • Integration with latest IDE versions - StyleVision supports seamless integration with Visual Studio and Eclipse with support extended to include:
    • Microsoft Visual Studio 2019
    • Eclipse 4.11 and 4.12

Altova UModel

  • Support for C# 8.0 and C++ 17 - UModel now provides code generation and reverse engineering for C# 8.0 and C++ 17.
  • Enhanced .NET binary support - Starting with v2020, when importing .NET binaries, UModel will automatically choose all parameters to reflect the user’s installation. Previously, completing this process manually required several steps and could be error prone.
  • Enhanced support for .NET Core
  • Code generation for Microsoft Visual Studio 2019 - Generated code is now compatible with Visual Studio 2019.
  • Support for additional database versions - UModel now supports connecting to the latest version of the following databases:
    • Microsoft SQL Server 2019
    • Microsoft Access 2019
    • Oracle 18 and 19
  • Support for Eclipse 4.9, 4.10 - In addition to integration with Visual Studio 2019, UModel supports the most recent versions of the Eclipse IDE.

Altova DiffDog

  • CSV/CSV and CSV/database comparisons - CSV is often used for exporting database data, and the ability to compare such data - either with another version of a database dump or to the data in the database itself - is a common requirement. DiffDog now supports CSV as a native format for comparison and cannot only compare CSV to CSV, but also supports mixed comparisons of CSV and database data. To start a CSV comparison, click Compare Database Data to open the Database Connection Wizard to connect to your CSV files and/or databases. A database or CSV comparison is similar to file comparisons showing left and right components. A "component" is just a representation of the CSV or database structure from where you can conveniently select the tables or columns that are to be compared. After comparing data, you can optionally merge differences either from left to right, or from right to left. You can either merge all differences as one batch, or you can display the differences for each table in a data grid, and then review and merge each difference individually at row level. This new functionality is extremely helpful for anyone working with databases. Automated comparison of CSV and database data is now supported by DiffDog Server 2020.
  • Support for additional database versions - For database comparisons, DiffDog now support the latest version of the following databases:
    • Microsoft SQL Server 2019
    • Microsoft Access 2019
    • Oracle 18 and 19

Altova DataBaseSpy

  • Export to Microsoft Excel - DatabaseSpy makes it easy to export database data to formats such as XML, CSV, HTML, and now Excel. You can export data either directly from specific tables or views, or via SQL SELECT statements. At the table level, you can choose which columns should be exported, as well as whether or not to include column headers. Export is compatible with Excel versions 2007 and later (.xslx).
  • Support for additional database versions - DatabaseSpy and all database-enabled Altova products now support the latest version of the following databases:
    • Microsoft SQL Server 2019
    • Microsoft Access 2019
    • Oracle 18 and 19
JSON Editor

Altova MissionKit Enterprise Edition

A suite of XML, SQL, and UML Tools.

Got a Question?

Live Chat with our Altova licensing specialists now.