Ostendo: Report Writer and SQL Queries
Reporting Writing and Technical
Ostendo runs on an SQL relational database and supports the multi user business from single to 100+ users. Ostendo is multi-company ready.
Database technology has been extensively used for improved performance e.g. triggers, stored procedures, generators and exceptions.
An in-built Graphical Workflows Designer Tool enables you to create graphical representations of your business process flow and then display it within the Ostendo desktop for individual end users. The workflow can then be linked to programs, reports, views or even scripts, therefore providing a simple way of representing an end user’s daily activities.
The integrated high end reporting and analysis capabilities, query design and selection criteria have been stored in the database itself i.e. not in the executable file. The report writer and scripting engine gives you the freedom you need on top of the analysis, pivot and chart views.
Ostendo reports are created by an advanced report writer which comes with more than 250 standard reports, analysis views and inquiry screens to select from. Forms, reports, analysis views and inquiry screens can access any related database information and produce concise documentation for customers, staff, suppliers and stakeholders.
The user can customise the menus to add external programs and files to Ostendo within its security.
The custom scripting engine allows customer specific routines to be created and added as a regular menu option also.
The Ostendo script scheduler allows scripts to be run based on predetermined frequencies and times for example automatically pick up emails and create timesheets and orders.
Opening lists can be customised by the user, as can the quick launch toolbar for commonly used menu options.
System wide alerts and reminders automatically trigger for urgent and important events as defined by the user.
Daily Key Business Statistics are sent by email to the business leaders and decisions makers.
The customer can also define their own compulsory fields for their business that users must input.
A complete transactional change audit log can be activated by user at any time.
Other tools included in Ostendo are an integrated spreadsheet with SQL query tools, general data import and export utilities across the entire database, right click mouse option to print or export data from screen lists, global name and code changing and substitution, image and document management library and graphical calendar views with drag and drop facility for CRM and jobs.
Ostendo uses the Firebird SQL relational database which automatically installs when Ostendo is installed. The Ostendo Database Utility allows the Backup, Restore and Validation (and if necessary, repair) of Ostendo Database files.
The Ostendo application itself can be run as a Web Server and when used with custom scripting the possibilities are endless for Web Services, Mobility, Remote Access and Third Party Software Integration.
Ostendo integrates directly with:
Say something here:
Back to Ostendo ERP Solutions