< Back to Windward Use Cases

Reporting with Multiple Datasources

In an era where companies are moving away from monolithic, on-premise datasources to cloud-based micro services, combining data from heterogeneous datasources becomes ever more important. ...Windward is compatible with virtually every data repository, so it fits with your already-existing data structure.

Working with a ton of data from multiple datasources? 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, comprehensive report drawing from these distinct datasources. With our powerful feature that allows items from two or more datasources to be correlated with one another to create a single integrated list or table, it’s amazingly easy to manipulate, correlate, and manage large datasets regardless of the number of datasources. Is this too good to be true? Read on to learn the details.

What if the data sources are not only distinct, but from 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.

Can Windward also combine data from separate data sources of heterogeneous types?

Yes! 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

These 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 an SQL datasource. 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 datasource for company names and IDs.

Windward's Tag Editor querying a XML datasource for company names and IDs.

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

Windward's Tag Editor showing how to create an inner ForEach Tag loop.

The outer and inner loops are combined into a single table, which will display order product IDs and unit prices grouped by company name.

An example template.

Remember, this displayed data has been pulled from two distinct datasources, and combined into a single table. Here is the final output:

Output of the example template.

Why offer support for heterogeneous datasources?

In an era where companies are moving away from monolithic, on-premise datasources to cloud-based micro services, combining data from heterogeneous datasources becomes ever more important. It's easy to add Windward's solution to your existing Microsoft Office software and Widnward is compatible with 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 on our website.

Windward Studios reviews sourced by G2

Document Automation 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.

© 2019 Windward Studios Inc.