Web Service Data Integration


In a previous post we wrote that every data integration and reporting task needs to start with a clear understanding of the source data. Using grid view in XMLSpy, the industry-leading XML and JSON editor, we analyzed JSON data for 5-day weather forecasts retrieved from a Web service.

Continuing with our earlier scenario, we’ll use MapForce, the award-winning, graphical data mapping tool for any-to-any conversion and integration, to map the forecasts for a series of major cargo shipping ports into nicely formatted Excel documents. We’ll want to highlight any predicted high winds or heavy rainfall that could cause delays by interfering with cranes loading and unloading containers, or slowing ships entering and exiting the harbors.

Read more…
Tags: , , , , ,

New Tools to Work with XBRL in Excel


With the importance of accurate, standardized financial reporting enforced through XBRL filing mandates, having XBRL tools you can rely on is a must. What’s more, financial professionals need to be able to generate XBRL reports easily without getting bogged down by the complexities of XBRL syntax.

Altova offers several add-ins for Excel that make it easy for organizations to comply with regulations from the EBA, EIOPA, and other regulatory bodies that mandate reporting in XBRL. These easy-to-use software products integrate directly into Excel so that users can create valid XBRL reports in an environment where they’re already comfortable working. And, the add-ins support importing existing XBRL reports to Excel for easy readability and analysis.

The latest release of the Altova XBRL Add-ins for Excel provides some important new features – let’s take a look.

New tools to work with XBRL data in Excel
Read more…
Tags: , , , ,

How to Convert Legacy Text Files [Video]


It’s a common requirement to convert non-standard or legacy text files to or from structured data formats like XML, JSON, and relational databases. However, many times legacy text files are not in a format that can be readily processed by data mapping tools, especially when they have a complex and unique structure that does not consistently fit into CSV or fixed-length field patterns. Moreover, sometimes you need to extract only portions of useful data from a legacy text file.

MapForce, Altova’s any-to-any data conversion tool, includes a unique utility called FlexText that makes it easy to visually define templates for parsing text files and making them accessible to the data mapping tool.

See how FlexText works in our video tutorial.

The example files referenced in the video are available here and you can try FlexText with a free, 30-day trial of MapForce.

Tags: , ,

Software Design Templates in Mobile Development Projects


Software design templates streamline mobile app development by eliminating implementation of repetitive components. Creating a design template also simplifies revisions and upgrades when a change to the template can roll through an entire project.

MobileTogether supports software design templates for user controls in cross-platform mobile apps to facilitate design reuse and make it easy to build efficient, flexible options for various app requirements.

A Control Template in MobileTogether is a design component that allows developers to specify and group user controls in a way that makes them easily reusable. Control Templates support parameters, and each template can be customized based on parameter values at runtime.

Let’s look at an example.

Read more…
Tags: , , ,

UML Modeling for C++ with UModel


C++ is one of the most powerful and efficient programming languages available, the de facto choice for high-performance computing, server applications, and complex architectures that demand the most powerful language constructs. The Unified Modeling Language™ (UML®) is the standard to design, visualize, and document models of software systems implemented in C++ and other source code languages.

Altova UModel competes with even the most advanced UML modeling tools with complete code engineering support in UML modeling for C++. UModel includes: C++ code generation from UML diagrams, reverse engineering C++ code to generate UML models, and round-trip engineering to update revisions to either C++ code and UML models.

Model transformation even lets developers convert an existing UML model designed for Java, C#, or Visual Basic to support C++.

Read more…

Tags: , , , ,

Handle HTTP Errors During Automated Data Integration


Data analysts and other professionals often need to generate real-time data through automated execution of data mappings that request Web services and save the results. During automated execution it’s important to gracefully handle any unexpected HTTP error rather than terminate the integration task.

In an earlier post we discussed conditional processing of a REST Web service response to handle HTTP errors, where separate output files were generated for a normal response and an error. Now let’s look at a revised mapping solution for the airport status example to generate a single mapping result file that contains either the requested airport status or a description of the error.

Read more…
Tags: , , , , ,

How to Manage GDPR Compliance [Video]


The General Data Protection Regulation, better known as the GDPR, is a set of privacy and data protection rules applying to organizations that process personal data of people residing in either the European Union or European Economic Area. It was built to comply with legislation that went into effect on May 25, 2018 and provides individuals more control of their personal data. The GDPR simplifies the regulatory environment for international business by providing a common set of standards for all businesses working in the EU.

The GDPR requires that data production measures be built into the design of business processes that collect personal data. If a breach occurs, information about this breach must be reported to the supervisory authority. Altova has created the GDPR Compliance Database, a tool that simplifies the storage and access of metadata related to company processes that touch personal data.

The Altova GDPR Compliance Database is a long-term solution for companies looking for a permanent solution to GDPR compliance. It enables companies to respond quickly to any incidents and contains built in mechanisms for change tracking, ensuring compliance measures are well documented.

The video above provides a high-level overview of all the features contained in the Altova GDPR Database.

Learn more about the Altova GDPR Compliance Database and try it free for 30 days.

Tags: , , ,