A recent mandate from the OECD called on large, multinational companies to report financials annually for each country in which they do business to their local tax authority. The OECD specified that this detailed Country by Country (CbC) Report be filed in an XML document according to their reporting schema. But for tax departments that work largely in Excel or other accounting software, this presented a significant stumbling block – and companies found themselves scrambling to meet the requirements by the deadline.
What was needed is a way to automatically generate valid, properly formatted CbC XML reports based on existing data. Altova created the Country by Country Reporting Solution to do just that, either based on manually entered data or figures imported directly from Excel. Let’s take a look at how it works.
Data mapping projects often mirror software development
efforts with distinct phases for design, testing, and deployment. This is
especially true for ETL (Extract Transform Load) projects when repeated data
mapping execution is required as new data becomes available, and the stakes
increase higher with large data sets. The Altova MissionKit and Server Software
products provide Global Resources to define configurations for each project
phase and smoothly transition between them.
Let’s take a look at an example based on a MapForce data mapping from a source file to a database.
With the right tools, a low code approach to development doesn’t mean a sacrifice of functionality or sophistication of the end result. On the contrary, low code app development frameworks like MobileTogether make advanced programming functionality more accessible and faster to implement.
Whether you’re building apps for iOS, Android, Windows, the web – or all of the above – the latest release of MobileTogether adds a mix of features that elevate programming on the platform to the next level and give developers easy access to the latest mobile device trends.
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
(Extract Transform Load) 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.
Altova XMLSpy and MapForce JSON tools have long supported
JSON and JSON5 for editing and data mapping. As new JSON formats arise in
response to real-world usage, the support in these tools is expanding.
This article will help explain the advantages of two newer formats – JSON with Comments and JSON Lines – and show how to use them in XMLSpy and MapForce.
XBRL (eXtensible Business Reporting Language) is an open,
XML-based standard for the electronic submission of business and financial
data. Though XBRL specifies what data must be reported and provides a
standardized way of doing so, companies and regulatory agencies need a way of
ensuring data quality through business rule validation. XULE is one method that
is growing in popularity.
Let’s take a look at what XULE is and how it works.
We’re introducing several exciting new tools for JSON
development in Altova Software Version 2020, but there’s much more too. Support
for the XULE XBRL standard, comparing CSV against database content, and updated
database support are just a few of the new features introduced across the
product line.
CbC Reporting Made Easy
A recent mandate from the OECD called on large, multinational companies to report financials annually for each country in which they do business to their local tax authority. The OECD specified that this detailed Country by Country (CbC) Report be filed in an XML document according to their reporting schema. But for tax departments that work largely in Excel or other accounting software, this presented a significant stumbling block – and companies found themselves scrambling to meet the requirements by the deadline.
What was needed is a way to automatically generate valid, properly formatted CbC XML reports based on existing data. Altova created the Country by Country Reporting Solution to do just that, either based on manually entered data or figures imported directly from Excel. Let’s take a look at how it works.
Read more…
Transitioning Data Mapping Projects from Development through Testing and Production
Data mapping projects often mirror software development efforts with distinct phases for design, testing, and deployment. This is especially true for ETL (Extract Transform Load) projects when repeated data mapping execution is required as new data becomes available, and the stakes increase higher with large data sets. The Altova MissionKit and Server Software products provide Global Resources to define configurations for each project phase and smoothly transition between them.
Let’s take a look at an example based on a MapForce data mapping from a source file to a database.
Accelerate Low Code App Development with MobileTogether 6.0
With the right tools, a low code approach to development doesn’t mean a sacrifice of functionality or sophistication of the end result. On the contrary, low code app development frameworks like MobileTogether make advanced programming functionality more accessible and faster to implement.
Whether you’re building apps for iOS, Android, Windows, the web – or all of the above – the latest release of MobileTogether adds a mix of features that elevate programming on the platform to the next level and give developers easy access to the latest mobile device trends.
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 (Extract Transform Load) 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.
Tools for JSON Comments and JSON Lines
Altova XMLSpy and MapForce JSON tools have long supported JSON and JSON5 for editing and data mapping. As new JSON formats arise in response to real-world usage, the support in these tools is expanding.
This article will help explain the advantages of two newer formats – JSON with Comments and JSON Lines – and show how to use them in XMLSpy and MapForce.
Learn about XULE for XBRL
XBRL (eXtensible Business Reporting Language) is an open, XML-based standard for the electronic submission of business and financial data. Though XBRL specifies what data must be reported and provides a standardized way of doing so, companies and regulatory agencies need a way of ensuring data quality through business rule validation. XULE is one method that is growing in popularity.
Let’s take a look at what XULE is and how it works.
Version 2020 Revolutionizes JSON Editing
We’re introducing several exciting new tools for JSON development in Altova Software Version 2020, but there’s much more too. Support for the XULE XBRL standard, comparing CSV against database content, and updated database support are just a few of the new features introduced across the product line.
Let’s take a look at the highlights.