Custom SQL Reports

Custom SQL Reports can be created using either the Overview SQL Data Warehouse, or the Overview Data Export Tool, and any ODBC compliant application, such as Crystal Reports, Microsoft Excel or Microsoft Access. 

Overview SQL Data Warehouse

The Overview SQL Data Warehouse consists of over 40 data tables and is a true relational data warehouse that is created through exports of data from the production database.

Overview's Data Exchange Module (Data Pump)

Overview’s Data Exchange Module enables an automatic feed of data to any pre-defined OBDC complaint database.  

Some of the features are:

• Full SQL (Structured Query Language) access to all data
• Support any ODBC (Open Database Connect Standard) SQL Connection
• Customize queries to build personalized links to any SQL database

Reporting Writing Services

To support your custom report needs, OmniTicket offers both training on the Overview SQL Data Warehouse and Overview Data Export Tool to allow you to create your own reports, as well as custom report writing services by our experts in this field.  Our professional report writers can use the data in the Overview SQL Data Warehouse to produce reports with data, format and graphics specific to your needs, and deliver it in a format that can be easily distributed to the required users.