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: , , , ,

Get Sharp with Altova’s Latest Release


Altova Software Version 2019 introduces over 20 new features to help you sharpen your development game – starting with support for high-res monitors in both XMLSpy and UModel. There are also tools for working with new standards and database versions across the product line, the ability to map and convert data in Google Protocol Buffers format, and much more. Let’s take a look at the highlights.

Altova Version 2019

Read more…

Tags: , , , , , , ,

An Easy Way to Test HTTP Requests During Development


Web and web services developers often need to send HTTP requests – whether for testing APIs, testing REST and SOAP web services, or managing web sites.

XMLSpy now makes it easy to send and receive HTTP requests directly in the XML editor during development with a new HTTP Window and WADL/WSDL Import Wizard.

Read more…

Tags: , , , , , ,