Certified Tools for xBRL-JSON & xBRL-CSV


XBRL International has finalized the sunrise period for its important new OIM (Object Information Model), which includes the xBRL-JSON and xBRL-CSV standards. In turn, it has completed the software certification process. Any product awarded the XBRL Certified Software designation has been thoroughly tested by XBRL International for conformance with the current XBRL specifications.

OIM represents a years-long effort of the XBRL community to modernize the financial reporting standard, providing a model for easily transforming XBRL data between XML and other popular formats like CSV and JSON. This way, organizations can take advantage of the functionality of XBRL and at the same time have XBRL documents written in the format(s) most convenient for them.

Altova XMLSpy and RaptorXML Server were some of the very first tools on the market to support xBRL-JSON and xBRL-CSV and are now officially named XBRL Certified Software for the OIM standards (in addition to being certified for a variety of other core XBRL technologies).

Learn more:

Colleagues collaborating on computers in an office
Tags: , , , , ,

Build No-Code Database Apps with RecordsManager


We are excited to announce availability of a new product in the Altova app development framework: RecordsManager.

Altova RecordsManager offers a completely visual, no-code interface for quickly creating custom database apps. RecordsManager is perfect for any app that handles data in records: think contract management, a customer database, an invoicing system, a database of local attractions or collections – the sky is the limit.

Your RecordsManager app will automatically be available on desktop devices as well as on mobile using native iOS and Android apps and provides tons of features that make it easy for end-users. Let’s see how it works.

Promotional image announcing RecordsManager
Read more…
Tags: , , , , ,

MobileTogether Gets a Major Update


Version 8.0 of MobileTogether adds several exciting new features to the innovative platform for building enterprise and mobile apps, giving existing customers a major upgrade and paving the way for new customers to create full-featured apps even faster than before.

Major additions to the platform include a brand new way of interacting with relational databases, support for modularization, and much more.

Version 8.0 also coincides with the launch of Altova RecordsManager, a new offering that gives system administrators a completely no-code option for creating business database apps in MobileTogether Designer.

Let’s take a look at the highlights.

Announcing MobileTogether 8.0
Read more…
Tags: , , , ,

Working with Avro Big Data in Your Favorite XML Editor


Big Data trends have developers working with XML alongside other data protocols such as JSON and Apache Avro, and XMLSpy supports both of these with dedicated editing views and functionality.

Let’s see how specialized Avro support in XMLSpy makes visualizing and searching Avro files, as well as editing Avro schemas, uniquely easy. We’ll also look at some of the advantages of utilizing RaptorXML Server for high-performance Avro processing.

shutterstock_88166515

Read more…

Tags: , , , , , ,

Automatically Convert EDI to XML


Electronic Data Interchange (EDI) has proven to be a durable business-to-business communication technology in use today with history dating to the 1960s and even earlier. Efficient EDI data encoding reduced transaction payload size and improved data transfer speeds at a time when messages were sent over teletype at speeds equivalent to a 300 baud modem. EDI standards bodies promote wide acceptance among enterprises, and systematic evolution of new EDI formats extends support across industries. EDI improves profitability and is a dominant format for e-commerce data exchange.

Despite the advantages, EDI files are barely human readable and need to be translated and mapped for compatibility with other business technologies. Altova MapForce is a graphical EDI mapping tool with native support for all major business data formats in use today, including XML, JSON, databases, flat files, Excel, and Web services, as well as the EDIFACT, X12, HL7, NCPDP SCRIPT, IDoc, PADIS, and SWIFT EDI transaction sets. MapForce can even automatically convert EDI to XML without the need to specify a target XML Schema or perform any manual mapping.

Read more…
Tags: , , ,

How to Compare CSV Files or Compare a CSV File to a Database Table


CSV files are a quick and convenient way to record structured data in a generic format. Because CSV files are so easy to create, multiple similar versions of very large CSV files can quickly proliferate. Often it becomes necessary to compare CSV files to find the desired version. In an ETL scenario, a data analyst may want to compare a CSV file to a database table for validation or to update data.

DiffDog, the unique XML-aware diff / merge tool from Altova, supports CSV as a native file format for comparison and can compare and selectively merge data CSV to CSV, or between a CSV file and database table. Let’s look at an example.

Read more…
Tags: , , , ,

Analyze JSON Data with Filters, Formulas, and Charts


Software developers and other data professionals often need to examine new data instances before designing processes for efficient production. As JSON becomes a more popular format for data exchange, the tradeoff for smaller data payloads can be loss of clarity of the underlying data structure.

XMLSpy has supported viewing, modeling, and editing JSON files since 2010 and includes rich tools to analyze JSON data, including applying filters, formulas, and charts.

Let’s take a look.

Read more…
Tags: , , , ,