Node Functions Simplify Mapping Hierarchical Data Structures


MapForce node functions simplify mapping hierarchical data such as XML nodes or CSV, JSON, EDI, or database fields by permitting users to define a data processing function at the node level and apply it recursively to all descendant items.

Similarly, default values can also be assigned to nodes and automatically applied to descendants.

Defaults and node functions are particularly useful when a data mapping and transformation task requires the same processing logic for multiple descendant items in a structure, for example:

  • Replace null values with some other value, recursively for all descendant items
  • Replace a specific value (for example, “N/A”) with some other value recursively for all descendant items
  • Replace all database null values when reading from a database table
  • Trim all trailing spaces for all values from a source database
  • Append a custom prefix or suffix to all values written to a target file or database
  • Formatting of output values
  • And many others

Defaults and node functions simplify mapping hierarchical data by eliminating need to copy-paste the same function multiple times into a mapping. Repeating the same function unnecessarily clutters the mapping layout and makes it more difficult to understand or revise.

Let’s look at an example.

Read more…

Tags: , ,

How to Speed Up Your XSLT – Automatically


Once you’ve written XSLT code to produce HTML or some other output, optimizing it to deliver the fastest execution is tricky business. Even with the powerful XSLT profiler in XMLSpy, a developer is required to have expert-level XSLT skills to test and fix the bottlenecks that the XSLT profiler identifies. Is the problem in an XPath expression? Is it an XSLT instruction? This can be a frustrating and time consuming task.

To help alleviate this issue and bring the power of XSLT to developers of all skill levels, XMLSpy also includes the XSL Speed Optimizer, which provides fixes to remove bottlenecks automatically, to immediately speed up your XSLT execution – it’s a revolutionary approach to optimizing XSLT performance.

Learn about XSL Speed Optimizer

Read more…

Tags: , , ,

The Only JSON Dev Tool You’ll Need


While XMLSpy might not be the first tool developers think of when they’ve got a JSON development task, XMLSpy includes comprehensive support for working with JSON, JSON Schema, and related technologies.

Over the past few product releases, we’ve added intelligent functionality for editing and converting JSON and JSON5 data to the product. We’ve completed the circle with one-click conversion between XML Schemas and JSON Schemas, as well as sample instance generation and JSON Schema documentation generation. And, most recently, we’ve added support for processing JSON with XSLT,  XPath, and XQuery.

Let’s walk through some common examples demonstrating this functionality – and see how these time-saving tools make XMLSpy the only JSON development tool you’ll need.

Developer using JSON tool

Read more…

Tags: , , , ,

Automate Diff Report Generation


DiffDog Server makes it easy to automate high-volume comparisons and generate diff reports comparing files, directories, and URLs. This high-performance server software is available for Windows, Linux, and MacOS X machines.

Developers have long relied on DiffDog for comparing XML, text, and binary files, as well as directories and URLs. Now, the power of DiffDog is available in lightning-fast server software for easily automating large comparison tasks.

For instance, DiffDog Server is perfect to automate diff report generation for critical files and directories at a given time – every day, once a week, etc.

Read more…

Tags: , ,

Querying Databases with MobileTogether


Databases power nearly every mobile app on the market. MobileTogether Designer allows developers to quickly and easily connect to any database and retrieve information to be displayed back to users. The video tutorial below walks you through creating your first database-powered mobile app.

If you are new to MobileTogether Designer please be sure to check out our getting started video. This video aims to get developers up to speed with the Designer’s interface, common phraseology, and steps through creating a basic app.

Tags: , , , ,

Run Altova Server Software on Azure Cloud


The Altova Server Platform is comprised of the complete family of Altova’s high performance server software for automating data processing and data integration workflows. These cross-platform server software products allow for flexible installation either on premises or in any private or public cloud infrastructure.

For customers utilizing the Microsoft Azure cloud, we’ve created a convenient, free VM template with the Altova Server Platform pre-installed for easy deployment, available on the Azure Marketplace.

Altova Server Platform

Read more…

Tags: ,

The Importance of Choosing Certified XBRL Tools 


Aside from complying with filing regulations, there are numerous benefits associated with adoption of the eXtensible Business Reporting Language. Standardizing information allows data validation as well as simplified comparison of reported data within an organization – from quarter to quarter or year to year, for instance – as well as comparing performance among multiple companies.

Of course, the benefits promised by XBRL  can only be realized through strict standards conformance in the tools organizations use for validating, reporting, and analyzing their XBRL data. Problems have arisen due to lack of consistent interoperability between software tools as well as less stringent validation checks that result in filing errors and diminished data quality.

Altova has always striven to deliver the closest possible conformance with supported XBRL standards and is honored to have received certification from multiple XBRL standards bodies, ensuring conformance and interoperability. Let’s take a look at the specifics and why this is so important for customers.

Financial pros using XBRL

Read more…

Tags: , , ,