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.
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.
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.
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, and combined into a single table. Here is the final output:
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.