Aiolos has the capability to export forecasts through SQL statements. This is done through ADO, the export protocol in AioConfig. You can define a configuration file that describes how the export should be done. This configuration file contains the ADOconnectstring, and the SQL statements needed to do the export. Since a SQL database can be constructed in many different ways this way of exporting can not be used with all database designs. It is currently designed with the schema “one value – one record” in mind. Future versions might be able to handle other designs, like “24 values – one record”
Note that since the definition file is XML, greater than (>) and less than (<) can not be used directly in the SQL statements, instead you have to use the “token” notation; > for “greater than” ( > ) and < for “less than” ( < ).