< Back to Windward Use Cases

Reporting with Multiple Datasources

Reporting with Multiple Datasources

Working with a ton of data?  If you’re like many of our customers, you’re probably working with important corporate information that’s stored in dozens of different databases.  Windward can help you create a single, comprehensible report drawing from these distinct datasources.

Windward has a powerful feature where items from two or more datasources (tables or nodes) can be correlated with one another to create a single integrated list or table. The entries in the final list or table would share at least one common item of data, such as a customer number.  

But what if the data sources are not only distinct, but of different types, say SQL and XML? As long as the data sources contain a common data element, datasources of different types can be combined into a single list or table using Windward’s solution.

Windward’s online Wiki article describes how to combine data from distinct datasources of the same type; however, did you know Windward can also combine data from separate data sources of heterogeneous types?

Here’s how it works.  Below is an example report template and output, where we create an outer ForEach Tag loop that retrieves company IDs and names from an XML data source.  

XML and SQL ForEach

XML and SQL Output

Those values are then used in an inner ForEach Tag that pulls data from a different datasource to group together product IDs and unit prices retrieved from a SQL data source. The resulting output will first return the data value (company name) for the outer loop and then return all the related data values (product ID, unit price) for the inner loop before advancing to the next data value returned by the outer loop.

In the outer ForEach Tag loop, we query an XML data source for company names and IDs:

Then we create an inner ForEach Tag loop, where we query an XML data source, using the customer ID retrieved by the outer loop stored in a variable:

The outer and inner loops are combined into a single table, which will display order product IDs and unit prices grouped by company name.  Remember, this displayed data has been pulled from two distinct datasources, combined into the single table below:

Which produces this output:

In an era where companies are moving away from monolithic, on-premise data sources to cloud-based microservices, each with their own data storage systems, combining data from heterogeneous data sources becomes ever more important. It’s easy to add Windward’s solution to your existing Microsoft Office software and get started quickly.  Windward is also compatible virtually every data repository, so it fits with your already-existing data structure.

Let Windward be your bridge between today’s legacy reporting requirements, and the reporting requirements of the future. Learn more about how Windward works.

Windward Studios reviews sourced by G2 Crowd

Reporting for high-volume output and a familiar user-friendly design environment

Start your FREE trial!
Call us with questions at 1.303.499.2544

For over 10 years, Windward has lead the industry with our world-class document generation platform that creates visually stunning, data-powered documents designed exactly the way users want and are created in a fraction of the time and cost compared to existing solutions. Proudly located in Boulder, Colorado, Windward Studios is the premier solution for developers and business users adding reporting and document generation capabilities to their applications in over 70 countries around the world.