
Standard data exchange systems play a crucial role in facilitating efficient and seamless communication and collaboration between various entities within an organization or across different organizations. By adhering to commonly accepted formats, protocols, and standards, these systems ensure that data can be easily shared, understood, and processed by different applications, platforms, and users. They enable interoperability and compatibility, allowing data to flow seamlessly across different systems, regardless of their underlying technologies. Standard data exchange systems promote data consistency, accuracy, and reliability, as they provide a common framework for data representation, validation, and transformation. They enhance productivity and reduce errors by automating data exchange processes, eliminating the need for manual data entry and translation. Moreover, these systems facilitate integration and scalability, enabling organizations to connect disparate systems, exchange data in real-time, and adapt to evolving business needs. Overall, standard data exchange systems streamline information flow, enhance collaboration, and drive operational efficiency, thereby empowering organizations to make informed decisions and achieve their goals effectively.
JSON
Acronym:ย Not applicable
Organisation responsible: Not applicable
Official web page:ย https://www.json.org/json-en.html
Description: JSON is a lightweight and easy-to-read format for representing data as key-value pairs. It is commonly used for data interchange between web services and applications.
Current Version:ย 2012-12
Schema location:ย https://www.json.org/json-en.html
Standard:ย Not applicable
Type of data:ย JSON
Primary purpose :ย Data exchange
API available:ย Not applicable
License details:ย No license required / Open format
Data model (Power BI):ย Available on request
XML
Acronym:ย Not applicable
Organisation responsible: World Wide Web Consortiumย (W3C)
Official web page:ย https://www.w3.org/XML/
Description: XML is a widely used format for structuring and representing data in a human-readable and machine-readable format. It allows for the exchange of data between different systems and applications.
Current Version:ย 1.1
Schema location:ย https://www.w3.org/TR/NOTE-xml-schema-req
Standard: https://www.w3.org/TR/xmlschema11-1/https://www.json.org/json-en.html and https://www.w3.org/TR/xmlschema11-2/
Type of data:ย XML
Primary purpose :ย Data exchange
API available:ย Not applicable
License details:ย No license required / Open format
Data model (Power BI):ย Available on request
Comma-Separated Values
Acronym:ย NCSV
Organisation responsible:ย Not applicable
Official web page:ย Not applicable
Description: CSV is a simple format for storing tabular data, where each line represents a record, and the values within the record are separated by commas. It is commonly used for data exchange between spreadsheets and databases.
Current Version:ย 1.1
Schema location:ย https://datatracker.ietf.org/doc/html/rfc4180
Standard:ย RFC4180
Type of data:ย CSV
Primary purpose :ย Data exchange
API available:ย Not applicable
License details:ย No license required / Open format
Data model (Power BI):ย Not applicable
Structured Query Language
Acronym:ย SQL
Organisation responsible:ย Not applicable
Official web page:ย Not applicable
Description:ย SQL is a standard language for managing relational databases. It is used for querying, manipulating, and exchanging structured data in databases.
Current Version:ย 2023
Schema location:ย https://datatracker.ietf.org/doc/html/rfc4180
Standard:ย By 1986, ANSI and ISO standard groups officially adopted the standard "Database Language SQL" language definition. New versions of the standard were published in 1989, 1992, 1996, 1999, 2003, 2006, 2008, 2011,[12]ย 2016 and most recently, 2023.
Type of data:ย SQL
Primary purpose :ย Data exchange
API available:ย Not applicable
License details:ย Not applicable
Data model (Power BI):ย Not applicable
Electronic Data Interchange
Acronym:ย EDI
Organisation responsible:ย x12 (USA)
Official web page:ย https://x12.org/
Description:ย X12 is a specific implementation of the EDI standard, primarily used in the United States for business-to-business transactions.
Current Version:ย Various versions
Schema location:ย Various schemas
Standard:ย There are many EDI standards (includingย X12,ย EDIFACT,ย ODETTE, etc.), some of which address the needs of specific industries or regions
Type of data:ย EDI
Primary purpose :ย Document exchange
API available:ย Not applicable
License details:ย Not applicable / Open standard
Data model (Power BI):ย Not applicable
eXtensible Business Reporting Language
Acronym: XBRL
Organisation responsible:ย Maintained by a consortium
Official web page:ย https://www.xbrl.org/
Description: XBRL is an XML-based standard for the exchange and reporting of business and financial information. It is commonly used in financial reporting and regulatory filings.
Current Version:ย 2.1 - February 20, 2013; 10 years ago
Schema location:ย https://specifications.xbrl.org/
Standard:ย Extended from XML
Type of data:ย XML
Primary purpose :ย Data exchange
API available:ย Not applicable
License details:ย Freely available
Data model (Power BI):ย Available on request
Portable Document Format
Acronym: PDF
Organisation responsible:ย Adobe
Official web page:ย https://www.adobe.com
Description:ย PDF is a file format designed to present documents in a consistent and device-independent manner. Although primarily used for document exchange and viewing, PDF can also contain structured data.
Current Version:ย 2.0
Schema location:ย Not applicable
Standard:ย ISO 32000-2
Type of data:ย PDF
Primary purpose :ย Document exchange
API available:ย Not applicable
License details:ย Open format
Data model (Power BI):ย Not applicable
Resource Description Framework
Acronym:ย RDF
Organisation responsible: World Wide Web Consortiumย (W3C)
Official web page:ย https://www.w3.org/RDF/
Description: RDF is a framework for representing information about resources in a machine-readable format. It is commonly used for sharing and linking data on the web.
Current Version:ย 1.2 - W3C First Public Working Draft 16 May 2023
Schema location:ย https://www.w3.org/TR/rdf12-schema/
Standard:ย Not applicable
API available:ย Not applicable
License details:ย No license required / Open format
Data model (Power BI):ย Available on request