This primer brings clarity to the often-confusing topic of reporting.
Windward’s wizard-style interface allows you to select and sort only the data you choose in any manner you prefer. With Windward, you can also create and manage an unlimited number of table or query based reports and export them to every common format. There is no limit to what you can do with this DB2 reporting software.
SQL Based Data Sources Support by the Windward Solution
- Microsoft SQL Server Database
- Oracle SQL Database
- MySQL Database
- IBM DB2 Database
- PostgreSQL Database
- Microsoft Azure SQL Database
- ODBC and OLEDB Connections
Why Windward for SQL?
The Windward product suite helps you embed advanced reporting and document generation functionality into your new or existing software application. The Windward Java and .NET engines quickly and cleanly embed into your codebase and connect with your SQL-based data source or sources.
By employing the Windward reporting and document generation solution, you to take advantage of SQL Server’s best features.
The advantages include:
Spend Less Time Programming
The ability to apply your existing queries, views and stored procedures allows you to get started quickly. Views and stored procedures allow you to reuse the queries you have worked so hard to perfect. Using SQL language queries directly in Windward tags enables you to harness the power of the large library of built-in functions. Windward takes advantage of these time-saving SQL features natively, allowing you to focus on template creation, not data selection.
Increase Your Data Selection Options
SQL’s functions provide you with a toolbox full of data selection options. Windward’s ability to use these functions natively extends those options, meaning less time crunching your data and more time using it.
Take Full Advantage of Joins
SQL’s joins are a great feature to link tables together by a common column. Building and perfecting them, however, is a time consuming process. Windward’s SQL wizard has a unique algorithm that will automatically create joins between your tables.
The algorithm scans your SQL Server’s meta data and distills those table relations for you. This is all bundled neatly in Windward’s SQL Wizard creating joins automatically based on the data you select.
Relax with Validated Security
You’ve worked hard to create the security layer of your SQL Server, so why use a product that doesn’t utilize it?
Windward connects and validates against your existing SQL Server security via the internal database or Active Directory enabling you to design and deliver your reports securely. Rest assured that your end users will only have access to the data they are allowed.
Design Templates with Ease
Once your programming is completed, non-developer employees and other end users apply the Windward AutoTag design tool to create report templates in Microsoft® Office®. Novice users can apply Windward’s intuitive SQL wizard to create complex queries with simple drag and drop actions, directly linking their templates to your SQL-based data source.
They can then run and distribute those reports when and where they want, in widely used and widely accepted formats.
Key Benefits for DB2 Database Reporting with Windward
- Accelerated report generation on any platform.
Windward is available for Java (pure Java), .NET (100% managed code) and any other programming language you might want to use. In every platform, report generation is measured in terms of pages per second, not seconds per page.
- Multi-threaded and modular applications.
You can construct your applications in Java, C#, VisualBasic, C++, Python, or PHP, building and runing them on desktop, server and embedded platforms.
- Effortless use and incorporation.
Incorporating Windward into your program can take as little as 14 lines of code. (Note: Template design is in Office but the engine does not use Office.) The SQL Wizard is so intuitive that someone new to DB2 reporting can generate almost any query, simple or complex.
- Targeted and streamlined data access.
Createdatasets of complex views to provide simple tables to access that data. Commands to select data include a large number of equations and functions, and you can easily add your own for more power.
- Template design, quick and easy.
The non-banded design tool lets you do things that are impossible with other DB2 reporting tools. You design reports in Microsoft Word and Excel, so there’s little training or learning curve.
- Significant time savings through reusable elements.
Windward Pods give you a powerful way to drag and drop data tags and complex sub reports – with no limitation on the combination of documents and tags in the Pod. Plus, you can pull in additional text and documents with a single tag, repeat parts of the document, include conditional parts of the document, and more.
- Simple user interface.
You will never get lost using Windward’s UI. It is easy to use and superbly designed for document generation.
- Lightning-fast report generation.
Report generation is measured in pages per second, not seconds per page.
By treating your template as a free-form document and providing you with the most cutting-edge DB2 reporting tools currently on the market, Windward makes DB2 reporting and document generation easier than ever.
Expect Exceptional Support
All Windward solutions include full documentation, 3-minute express training, live or on-demand training webinars, tutorials, examples, code samples, and everything else you might need.
We offer quick and courteous customer support. In the words of our customers at RepLink, “Customer service is outstanding. Windward does just what we need it to do.”
Try Windward Today
Experience firsthand the ease that Windward brings to your DB2 reporting needs.