A Library for XML Data Standards

Uli Bethke XML, XSD

First things first. Before we dive into the various data standards let's first explain what XML is. XML is short for Extensible Markup Language. It is used to describe data. The XML standard is a flexible way to create information formats and electronically share structured data via the Internet, as well as via corporate networks.

As in life in general, in XML we need to follow a set of rules. Those rules are called schemas (.xsd). They ensure that XML files are valid.

A set of (nested) XSD schema files makes up an XML standard. This brings us to the point of this article.

We have created a library of XML Standards per Industry. Now all of you XML lovers have all of the XML data standards in one place. We will add to this list over time.

Where relevant we have also added a link to a blog post. Each post shows how XML files can be converted to a database, text, or Hadoop using Flexter our XML converter. Everything happens automatically. Not a single line of code is needed. Any XML industry data standard is handled no matter the complexity.

Have we missed an Industry data Standard? Contact us or leave a comment.

Finance

Standard Name Business Description Converting the standard
Interactive Financial eXchange (IFX)

Download

IFX XML

The IFX standard is a content-rich, well-designed Business Message Specification (BMS), built by financial industry and technology leaders with decades of combined experience. These experts have painstakingly defined, modeled and incorporated real-life use cases to produce relevant and useful business data objects. The result is a consistent framework incorporating best-of-breed design principles and a common object model with carefully defined data definitions.
OFX - Open Financial Exchange

Download

OFX XML

OFX XSD

Open Financial Exchange is a broad-based framework for exchanging financial data and instructions between customers and their financial institutions. It allows institutions to connect directly to their customers without requiring an intermediary.
AS4 Profile of ebMS 3.0 Version 1.0 ( OASIS)

Download

AS4 XML

AS4 XSD

While ebMS 3.0 represents a leap forward in reducing the complexity of Web Services B2B messaging, the specification still contains numerous options and comprehensive alternatives for addressing a variety of scenarios for exchanging data over a Web Services platform. The AS4 profile of the ebMS 3.0 specification has been developed in order to bring continuity to the principles and simplicity that made AS2 successful, while adding better compliance to Web Services standards, and features such as message pulling capability and a built-in Receipt mechanism.
ESMA

Download

ESMA XSD

An independent EU authority that contributes to safeguarding the stability of the European Union’s financial system. Convert ESMA XML to Snowflake
FpML

Download

FpML XML

Fpml XSD

An XML message standard

for the OTC Derivatives

Industry.

Convert FpML XML to BigQuery
ISO 20222

Download

ISO XML

ISO XSD

The ISO 20022 message dashboard gives an overall picture of the five financial business domains in scope of ISO 20022. Its purpose is to show which business processes are already supported either by existing ISO 20022 message definitions or by candidate message definitions covered by an approved Business Justification. Convert ISO 20022 XML to Text (TSV/CSV) without code
FIXML FIXML is the XML vocabulary for creating FIX messages. Uses the same FIX data dictionary and business logic. Focuses primarily on the FIX Application Messages and does not provide a session layer. Can be encapsulated within the FIX Session Protocol or within another protocol like, MQ Series, TIBCO, SOAP, etc Convert FIXML XML to Excel
IRS

Download

IRS XML

IRS XSD

System that allows IRS to exchange tax payer information with foreign tax authorities. Convert IRS XML to PostgreSQL using Flexter Enterprise
CRS

Download

CRS XML

Allows the reporting of information under the CRS in an IT-based and standardized manner. Convert CRS XML to TSV

Healthcare

Standard Name Business Description Converting the standard
Medline Plus

Download

MedlinePlus XML

The MedlinePlus XML, represents library of all Health articles that are on MedlinePlus website. It accepts keywoard search and returns relevant health topic. Converting MedlinePlus XML to QlikView
FHIR

Download

FHIR XSD

FHIR aims to simplify implementation without sacrificing information integrity. It leverages existing logical and theoretical models to provide a consistent, easy to implement, and rigorous mechanism for exchanging data between healthcare applications. Convert FHIR XML to Excel
Clinical Trials

Download

Clinical Trials XSD

A registry and results database of publicly and privately supported clinical studies conducted around the world. Querying XML files with Tableau via Flexter
HL7

Download

HL7 XSD

The objective of this document is to present an Implementable Technology Specification (ITS) for the encoding rules for HL7 Version 3 messages based on XML (Extensible Markup Language). Several XML encoding methods could serve as a messaging syntax for HL7 V3 messages Convert HL7 XML to Text (TSV/CSV) without coding
Structured Product Labeling Resources

Download

SPL XSD

Structured Product Labeling (SPL) is a Health Level Seven (HL7) standard based on Clinical Document Architecture and HL7 Reference Information Model (RIM) accredited by the American National Standards Institute (ANSI) for the exchange of product information. Structured Product Labeling documents include a header and body. The header includes information about the document such as the type of product, author and versioning. The body of the document includes product information in both structured text and data element formats. The United States Food and Drug Administration (FDA) uses SPL documents to exchange information covering a growing number of product related topics.

Transport

Standard Name Business Description Converting the standard
GS1 Xml Transport

Download

GS1 XSD

GS1 XML

GS1 standard gives accurate up to date information about where your shipments are at any time, where they have come from and when and where they are due to arrive.
EPC/RFID

Download

EPC/RFID XSD

EPC/RFID XML

By providing a machine-readable framework for validation and translation of EPC identifiers, Tag Data Translation is designed to help to future-proof the EPC Network and in particular to reduce the pain / disruption in supporting additional EPC identifier schemes that may be introduced in the future, as the EPC Network is adopted by additional industry sectors and new applications. The EPC Tag Data Standard (TDS) also describes in terms of human-readable encoding and decoding rules for each coding scheme, how to translate between three representations of the electronic product code (EPC), namely the binary format and two formats of uniform resource identifiers (URI), one for tag-encoding and another for pure identity.
TransXML

Download

Trans XSD
Trans XML

XML Schemas for Exchange of Transportation Data examines a proposed common framework for exchange of transportation data in eXtensible Markup Language, known as TransXML. The framework is designed to be used for developing, validating, disseminating, and extending current and future schemas. The report also explores the benefits that might be achieved by the adoption and expansion of TransXML, and highlights efforts designed to help ensure its success.

Infrastructure

Standard Name Business Description Converting the standard
LandXML

Download

Land XSD

Land XML

LandXML is a specialized XML data file format containing civil engineering and survey measurement data commonly used in the Land Development and Transportation Industries.

Automotive

Standard Name Business Description Converting the standard
Star - Standards for Technology in Automotive Retail

Download

STAR XSD

STAR XML

Standards for Technology in Automotive Retail (STAR) is a nonprofit, dues-paying organization whose members include dealers, manufacturers, retail system providers, and automotive-related industry organizations. The goal of STAR is to use non-proprietary technology (IT)standards as a catalyst in fulfilling the business information needs of dealers and manufacturers while reducing the time and effort required to support related activities. Collectively, STAR develops voluntary industry standards and researches emerging technologies for the benefit of dealers. STAR is considered the IT standards organization for the retail automotive industry. STAR Objectives * To define the open, standard XML message formats for dealer-to-OEM communications (e.g, Parts Orders, Sales Leads, and Credit Applications). * To define an open, standard architecture to support the delivery of messages between dealers and OEMs. * To standardize the dealership IT infrastructure.

Legal

Standard Name Business Description Converting the standard
LEI-CDF Format

Download

LEI XSD

The Legal Entity Identifier (LEI) connects to key reference information that enables clear and unique identification of legal entities participating in financial transactions. The International Organization for Standardization (ISO) 17442 standard defines a set of attributes, or legal entity reference data, that comprises the most essential elements of identification.

Daily reporting of LEI and legal entity reference data is conducted by the LEI issuing organizations using the Common Data File (CDF) formats. The CDF formats provide the specificity needed for the operational implementation of the ISO standard. External standards have been included in the CDF formats, where appropriate, to promote data quality

Telecommunications

Standard Name Business Description Converting the standard
oneM2M: ETSI TS 118 104 V2.7.1

Download

oneM2M XSD

The oneM2M architecture is resource-based (ETSI TS 118 101 ). The functionality of the system is exposed by means of APIs over all reference points specified in ETSI TS 118 101. Operations upon resources hosted by a CSE are carried over an established channel that constitutes the communication on the reference points Mca and Mcc. All resource operations could be fulfilled with the considerations in terms of scalability, extensibility, fault tolerance and robustness, energy efficiency, and self-operation.

Each resource operation comprises a pair of primitives: Request and Response. The Request and Response primitives

can be represented as XML documents or JSON texts. This process of representing a primitive as XML documents or

JSON texts is denoted serialization in the present document. Serialization translates primitives into a format that can be

stored or exchanged between network entities. This is exploited when transmitting primitives over communication

protocols such as HTTP, CoAP or MQTT.

Media

Standard Name Business Description Converting the standard
TV-Anytime - ETSI TS 102 822-3-1

Download

TV-Anytime XSD

TV-Anytime XML

The TV-Anytime metadata system allows the consumer to find, navigate and manage content from a variety of internal and external sources including, for example, enhanced broadcast, interactive TV, Internet and local storage. It defines a standard way to describe consumer profiles including search preferences to facilitate automatic filtering and acquisition of content by agents on behalf of the consumer. Consumers, as used in the present document, include educators and students, who may use selected programme segments in the classroom or laboratory.

Research

Standard Name Business Description Converting the standard
RIXML - Research Information Markup Language

Download

RIXML XML

RIXML was formed when a number of buy- and sell-side firms came together to discuss a common problem: the amount of investment research that was being distributed had outgrown the tools available to organize it. The consumers of investment research needed better ways to access the precise research they needed, and the creators of investment research needed a better way to ensure that their research was seen by those who would benefit from it.

Learning

Standard Name Business Description Converting the standard
PESC

Download

PESC XSD

Formatting data in the ISO standard format of PDF (Portable Document Format) is an excellent way to

display and view information; however the format was neither designed for nor natively enables the exchange

of data between systems. The PDF Working Group of PESC was challenged to find a means to leverage the

near ubiquitous use and acceptance of PDF documents that would allow such documents to enable data

exchange. By capitalizing on one of the PDF’s capabilities to serve as a container or conveyance, the

Working Group has devised a standard for embedding files within the PDF that can make the PDFs machinereadable.

Also, if embedded files are themselves machine-readable (e.g., another standard XML file), the

PDF joins with the other data PESC formats as a very effective data exchange medium.

Insurance

Standard Name Business Description Converting the standard
ACORD

Download

ACORD XSD

ACORD XML

Used to exchange insurance related information with external partners and within the company. Convert ACORD Insurance XML to Talend Data Preparation

Travel

Standard Name Business Description Converting the standard
NDC(New Distribution Capability)

Download

NDC XSD

Enables the travel industry to transform the way air products are retailed to corporations, leisure and business travelers. Tips for parsing and loading complex NDC XML files in ODI
OTA

Download

OTA XSD

OpenTravel’s mission is to engineer specifications to ensure traveler and supplier information flow smoothly throughout travel, tourism and hospitality. OpenTravel creates, expands and drives adoption of open specifications, including but not limited to the use of XML, for the electronic exchange of business information among all sectors of the travel industry.

Energy

Standard Name Business Description Converting the standard
WITSML

Download

WITSML XSD

Used for sending well site information in an XML document format between business partners. Convert WITSML XML to Excel

Tenders

Standard Name Business Description Converting the standard
Ted XML

Download

Ted XSD

TED (Tenders Electronic Daily) is the online version of the 'Supplement to the Official Journal' of the EU, dedicated to European public procurement. Converting and Analysing EU Tender data in XML with Flexter and Dataiku DSS

HR

Standard Name Business Description Converting the standard
HR Open standard

Download

XML

Founded in 1999, the HR Open Standards Consortium is the only independent, non-profit, volunteer-led organization dedicated to the development and promotion of a standard suite of specifications to enable human resource related data exchanges.

 

Public Sector

Standard Name Business Description Converting the standard
IATI Standard

Download

XSD

XML

IATI Standard is a technical publishing framework allowing data to be compared.

MISC.

Standard Name Business Description Converting the standard
Tableau Workbooks

Download

XML

A .twbx file is a Tableau Packaged Workbook, meaning it is the original .twb file bundled together with the data source in one package. .twbx files can be considered analogous to specialized zip files, in which these “zip” files contain all the information necessary to work in Tableau. The .twb file alone is not enough to perform any analysis because it only contains Tableau’s instructions for interacting with a data source. In actuality, .twb files are XML files specially tailored to interact with data sources. In this walk through, we will process this XML file using Flexter and then load the TSV output into tableau for querying/analysis. Convert XML Metadata of Tableau Workbooks (TWB) to Text

Have we missed an Industry data Standard? Contact us or leave a comment.