Embedding Images in XML


One of the really cool features added to XMLSpy a few years ago based on customer requests is the ability to embed external files – such as images – directly in an XML document as encoded text. This gives you the option to package all required data from various external files together in one large XML document. The functionality is also available for embedding images in JSON documents. 

Let’s take a look at how easy it is to accomplish this in the XML and JSON editor in just a few steps.

Photo for embedding images

 

Read more…

Tags: , , , ,

Version 2020 Revolutionizes JSON Editing


We’re introducing several exciting new tools for JSON development in Altova Software Version 2020, but there’s much more too. Support for the XULE XBRL standard, comparing CSV against database content, and updated database support are just a few of the new features introduced across the product line.

Let’s take a look at the highlights.

Altova Software v2020 announcement
Read more…
Tags: , , , ,

MapForce Tutorial (Video)


Altova MapForce is an any-to-any data transformation, conversion, and ETL tool for integrating data.

A graphical data mapping tool, MapForce has an intuitive drag-and-drop interface that lets you easily convert data between any two formats, such as XML, JSON, relational databases, EDI, and more. It also features an extensive library of conversion functions that can be chained together to form custom functions that can be reused throughout your projects.

Data translated by MapForce can be pulled to or pushed from any relational database and all data management products, and it can be adapted to customize in-house data management solutions.

The MapForce tutorial video below covers all major features offered by the data integration tool and shows example mappings between several different types of files.

You can try MapForce yourself with a free, 30-day trial.

Tags: , , , , , ,

How to Generate CbC Correction Reports


Altova’s Country by Country (CbC) Reporting Solution makes it easy for multi-national companies to generate valid XML reports to meet the filing requirements mandated by the OECD. Now, in Version 2.0, the CbC Reporting Solution includes new functionality for generating correction reports, as well as the ability to import existing reports for easy analysis.

Let’s take a look at how these new tools make it even easier for customers to meet filing requirements without having to deal with the underlying CbCR XML syntax.

Country by Country Reporting Solution for XML
Read more…
Tags: , ,

Generating a Schema from Multiple XML Instances


I was recently talking with one of our Support Engineers about common questions he receives from customers. One that comes up a lot is schema generation, specifically, “How can I generate an XSD?” The answer, of course, is to use your favorite XML editor. XMLSpy will generate a valid XSD from a DTD, a relational database structure, a JSON Schema, and of course, an XML instance.

But what many customers don’t know is that the XML editor will also create an XML Schema based on a group of related XML files – and this is a common requirement. Let’s take a look at how it works.

Read more…

Tags: , , ,

Job Distribution on FlowForce Server


FlowForce Server is Altova’s high-performance engine for automating workflows of XML processing, data integration, report generation, and more. It integrates with other Altova server software products to automate their functions, such as executing complex data integration processes, including ETL projects, designed in MapForce; running  StyleVision report generation jobs; or validating XML, XBRL, or JSON files with RaptorXML Server.

Starting with Version 2019, FlowForce Server offers new options for distributed execution and load balancing to improve availability and performance. Let’s take a look at how configuring multiple FlowForce Servers to run as a cluster can help improve data throughput and provide redundancy.

Job distribution for high availability on FlowForce Server

Read more…

Tags: , , , ,

Data Mapping Protocol Buffers (Protobuf)


MapForce 2019 supports data mapping protocol buffers with other structured data formats as mapping sources or targets. In the constant quest for more efficient ways to transfer, manipulate, and manage large structured data sets, Google has created a language- and platform-neutral data format similar to XML, but smaller, faster, and simpler than even JSON data. Tools are available to generate and work with protocol buffers (often abbreviated as protobuf) using Java, Python, C++, C#, Ruby, and other programming languages.

The structure of any protocol buffer message is defined in a .proto file that defines each field name and value type. Altova MapForce lets users drop these .proto files into a data mapping as a source or target along with any other data, including XML, JSON, relational databases, Excel, flat files, REST and SOAP web services, and other data formats. MapForce supports data mapping protocol buffers using .proto files versions 2 and 3.

A MapForce protocol buffers data mapping creates compatibility between existing XML, JSON, database or legacy data formats and new applications leveraging the efficiency of protocol buffers.

Read more…

Tags: , , , ,