How to Build a Database-driven App


We’ve updated our demo series on building an app that connects to a backend database using MobileTogether. The low-code approach to app development in MobileTogether extends to database connectivity: the Database Wizard includes a visual SQL statement editor that makes it easier than ever to connect to and work with backend database data in your apps.  

This how-to video series takes you through the process of developing a sample Books Catalog app with rich functionality for searching, adding new database records, working with images, and more.

man working in an office
Read more…

New App Development Tools


Altova releases new versions of its app development framework multiple times a year to introduce new features added in response to customer requests and feedback, as well as to add support for newer OS and database versions as they become available.

The latest release of MobileTogether and RecordsManager introduces important new functionality for building low-code and no-code apps.

Introducing the latest MobileTogether release
Read more…
Tags: , , , ,

How to Get EBA XBRL from Excel


Like other regulatory agencies around the world, the European Banking Authority (EBA) has standardized on XBRL for the transmission of data submitted by filing entities. Benefits of using XBRL include increased accuracy and efficiency of supervisory practices and risk identification. The use of XBRL benefits filing organizations as well, because the now-standardized data can be easily validated and then used further for automated report generation and other common requirements.

However, the challenge lies in getting backend data into a valid XBRL format according to the EBA Taxonomy, especially since the employees recording the data are generally financial professionals and not familiar with XBRL syntax.

Let’s take a look at how EBA reporting tools can make it easier.

EBA XBRL from Excel

Read more…

Tags: , ,

Learn About XQuery Update Facility


XQuery Update Facility is an extension of the XQuery language that allows you to make changes in an XML document using “update expressions” that insert, delete, replace, or rename nodes. This extension provides a convenient way to make intelligent updates to XML documents, and XMLSpy has a unique implementation that makes it even easier. Let’s see how it works.

News about XML find / replace

Read more…

Tags: , , ,

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