Validating and Debugging Data Transformations


Software developers and other data professionals often need to transform data from one format to another. These transformations can be simple one-to-one conversions or may require more complex manipulation. For instance, relationships must be generated when importing flat CSV files into a database, or source data may need to be split for the target, as in full name vs. first, middle, last, and optional suffix. Validating data transformation is critical to prevent data loss or corruption.

In an earlier post on Web service data integration, we combined a string value for GMT time with a numeric offset in seconds to generate the local time for weather forecasts. We created a user function that performed all the steps required to complete this operation. MapForce includes a powerful interactive data mapping debugger that can easily trace and validate this transformation. Let’s take a look at how it works.

A software developer working on a computer
Read more…
Tags: , , , ,

Benefits of an XML Schema Manager


Developers working with XML often need to deal with multiple DTDs and XSDs that define industry-standard vocabularies. Whether it’s DITA for technical writing, HL7 for healthcare data, CbCR for financial reporting or any number of examples, it becomes a challenge to manage the various schemas—and numerous versions thereof—on a day-to-day basis.

Altova recently introduced a new XML Schema Manager integrated in its XML-enabled products. This provides a centralized utility that makes it easy to download and manage industry schemas for use across the product line. Let’s see how it works.

Developer working at a computer
Read more…
Tags: ,

ESEF Tools


The ESEF acronym has been top of mind for finance professionals across the EU and UK since mid 2019, when an upcoming reporting mandate from the European Securities and Markets Authority (ESMA) was announced.  

ESEF, which stands for European Single Electronic Format, is a digital financial reporting standard based on XBRL. As of early 2020, companies on EU regulated markets are mandated to prepare their annual reports in accordance with ESEF rules.

What exactly is ESEF compliance, and what does it take to meet reporting requirements? Let’s take a look at the basics and some tools that make it easy.

Finance pros
Read more…
Tags: , , , ,