Windward has native support for SQL (via ADO.NET & JDBC), JSON, XML, OData, & Salesforce. The SQL support means any datasource that has an ADO.NET or JDBC connector can be accessed by Windward. This is not only every SQL database, but many non SQL datasources that have a connector.
Windward has been thoroughly tested using the Skyvia OData connectors - which provide a connection to over 150 custom datasources from ACT to NetSuite to Zoho. This delivers full native Windward support for each of these vendors. You can also connect to many of the same using an ADO.NET & JDBC connector using CData.
If you've just discovered us, we're excited. Learn more about Windward document automation software now.
Try Windward with our 30-day free trial and start creating documents in quick time with our low/no code solutions.
Define all variables that will be passed in when run in production. With the defined variables, they can then be used in a drag/drop manner when crafting queries in the wizards.
The query editor has color coding and type ahead to help in writing queries for advanced queries that the wizards cannot do. Or if you just prefer writing queries direct.
A dataset is a defined subset of data from a datasource. Datasets provide a simplified model of the data to the template designer, reducing each down to only the data fields the designer is interested in. In addition a dataset can combine data from multiple tables/nodes to present it as a single simplified table/node. The created dataset is then treated as a distinct datasource and can be used in queries the same as any datasource.
If you've just discovered us, we're excited. Learn more about Windward document automation software now.
Try Windward with our 30-day free trial and start creating documents in quick time with our low/no code solutions.
Windward provides a simple mechanism to run Ad-hoc reports. If you have a template designed to generate a sales summary for a location, you can use this API to then set it to a rangle of locations, change the date range, etc. When generating a report, lists of values or select criteria can be passed to the engine to have it apply that ad-hoc query in the select for the identified tag.
This does not require designing the template to handle any combination of Ad-hoc queries. The Windward Engine will adjust the queries on the fly as you specify.
All URL & file operations, including reading a file based datasource (XML, JSON, OData, etc.) use a Windward access provider. Access providers exist for all the common protocols (file servers, basic, digest, OAuth2, etc.). And if you need something different, you can write your own access provider - once. And it then handles any access of files using that protocol. (ref: Ohana)
The key value here is if you need to write your own access provider. If so, you write it once and it is then used anywhere Windward needs to access your datasource using your protocol. And of course, if you use one of the standard protocols, we have it covered.
If set, when a report is generated, all data placed in the generated report is also written to a data.xml file. That file is then included in the generated DOCX, PPTX, or XLSX report.
The SQL Wizard will automatically determine the joins between tables in the select (if the database metadata has the foreign key - primary key relationships).
SQL Schema is a method to reduce the schema of a database to just the tables/columns of interest. It also speeds up loading the database. Only needed for databases with a large schema - and a life saver for gigantic schemas.
Want to learn more? Need a demo? Why not start a free trial?
With no hidden implementation fees, it's a breeze to start with Windward.
Contact our friendly Sales Team at success@windward.net or call 1-303-499-2544.
We can’t wait to help you with your document automation needs!
