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.