Use Join to Integrate Data in Any Format


Join is a powerful SQL operation implemented across most database types and familiar to database users. Join is typically used to select and combine information from multiple database tables.

Altova MapForce includes a join component for data mapping that works like a SQL join for database tables and extends data integration functionality by empowering users to join data trees of any data format. Anyone familiar with join operations for database tables will find the MapForce join component especially intuitive. A join operation in MapForce can even combine two different data formats and produce output in a new format altogether.

Read more…

Tags: , , ,

A Typical MapForce Server Use Case


Envision a manufacturing company that controls costs by exploiting a just-in-time assembly process with a very low supply of parts inventory on hand. New customer orders are logged in a sales database and at the end of every day the components needed to assemble that day’s sales are tabulated.

The IT department runs a SQL query to identify the required parts and transforms the list into a purchase order in JSON format to be transmitted to the supply chain.

Sound familiar? Our recent blog series on JSON tools and JSON data mapping were based on this real-life scenario. In this post we describe a MapForce Server use case that automates the repetitive task of generating each day’s purchase order.

Read more…

Tags: , , ,

The Only JSON Dev Tool You’ll Need


The popularity of JSON is ever-increasing, and XMLSpy is keeping pace. Over the past few product releases, we’ve added intelligent functionality for editing and converting JSON data to the product. Most recently, we’ve completed the circle with one-click conversion between XML Schemas and JSON Schemas, as well as sample instance generation and JSON Schema documentation generation.

Let’s walk through some common examples demonstrating this functionality – and see how these time-saving tools make XMLSpy the only JSON development tool you’ll need.

JSON Dev Tools

Read more…

Tags: , , , ,

JSON Data Mapping and Transformation with MapForce


JSON is a popular format for transferring data between systems thanks to its simple markup, small footprint, and heritage based on the JavaScript programming language. MapForce supports JSON as both an input and output format for JSON data mapping and transformation. For instance, MapForce can extract information from any popular database and produce a JSON file ready for transfer.
The Requirement: Here is an example of a typical need for JSON data mapping: A manufacturing company controls costs by exploiting a just-in-time assembly process with very little parts inventory on hand. New customer orders are logged in a sales database, and at the end of every day the components needed to assemble that day’s sales are tabulated via a query into the database. The required parts will be ordered from suppliers via a purchase order transferred in JSON format.

Read more…

Tags: , , ,

Generate PDF, Word, or RTF Documents from a Mobile App


Need to empower mobile users to capture information and generate a document or report from any remote location? MobileTogether lets you build a cross-platform mobile app to do that. You can tailor the app with all the device-specific mobile controls users expect, like check boxes, date pickers, switches and buttons, yet generate output files identical to an existing document, form, or report already familiar throughout the enterprise.

The Actions Dialog in the MobileTogether Designer lets developers define a Print To action to generate PDF, Word, or RTF documents from a mobile app. Once a document is rendered, it is saved on the mobile client for further processing. For instance, a PDF file could be emailed as a file attachment.

Generate PDF, Word, or RTF Documents from a Mobile App

Read more…

Tags: , , ,

Database Features Across the Altova Product Line


We have written previously about database features like SQL Merge for data integration, and summarized database features in the latest release. But if you’ve only used one or two Altova products, you may not be aware of the powerful support for working with relational databases is provided throughout Altova’s tightly-integrated tools.

Database features across the Altova product line

The Altova MissionKit and MobileTogether products include SQL database features with rich functionality for database-related tasks, supporting all major relational databases in their native interface languages.

Read more…

Tags: , ,

Learn About Inline XBRL and XBRL Taxonomy Packages


As adoption of the eXtensible Business Reporting Language (XBRL) for financial reporting increases worldwide, new standards are emerging to meet the needs of filing companies and developers alike. Altova’s line of XBRL-enabled products supports a wide-range of XBRL standards and is updated frequently as new specifications emerge.

Let’s take a closer look at two of the newer XBRL standards – Inline XBRL and XBRL Taxonomy Packages – and explore how they work.

Corporate buildings

Read more…

Tags: , ,