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:

  • MYOB AccountRight Live
  • MYOB AccountRight Classic range including Standard, Plus, AccountRight Premier and Enterprise
  • Reckon’s QuickBooks QBI versions
  • Sage Pastel Evolution
  • MoneyWorks for Windows
  • Xero

Say something here:

  • Graphical Process Workflows
  • Graphical Web Dashboards
  • Web Services, Email Services, Mobile Access and Tablet Remote Users
  • Customised Data Entry Screens with Remote Synchronisation
  • EDI and eCommerce
  • Alerts, Reminders and Daily KPIs and Key Business Statistics
  • Inquiry Screens, Statistics, Analysis, Pivot and Chart Views for all History
  • Report Writer and Advanced Scripting Engine
  • Ostendo Script Scheduler and Queue Services
  • Modifiable Windows Graphical User Interface
  • Drag and Drop Items in Frequently Used Screens
  • Document and Image Management
  • Spreadsheet with SQL Query Tool
  • Data Import and Export

Back to Ostendo ERP Solutions


Month/Year End


Harewood, Christchurch, New Zealand

© aboutBusiness 2016