Opera II Enterprise SQL
Opera II Enterprise SQL is designed and built using the most powerful components of Opera II Enterprise; it delivers a wealth of impressive functionality alongside Microsoft's industry-leading database technology, MS SQL Server.
- Automation of tasks
- Online Analytical Processing (OLAP)
- Greater integration with third party software
- Keeping your business healthy
- Sophisticated and flexible analysis
- Financial reporting
- Put yourself in control
- Instant Communications
Automation of tasks
Automation of recurring administrative tasks is a key benefit of SQL Server. Automatic data file size management and automatic memory management are just two functions of SQL Server that save time and money. Backing up and restoring data can also be automated without any disruption to your work activities. These tasks can be monitored and the system administrator notified when attention is required.
Online Analytical Processing (OLAP)
With SQL Server OLAP functionality, your Opera II Enterprise SQL solution can rapidly analyse significant volumes of data, giving you a better and more immediate understanding of key elements of your business. Data is organised in logical categories such as financial periods, sales territories, and product groups. This allows businesses to extract meaningful information and reports that everyone can use. Underlying business trends can be quickly identified, allowing the right decisions to be made at the right time.
Greater integration with third party software
Opera II Enterprise SQL data is stored in MS SQL Server so that business transactions can be easily accessible and used in conjunction with other SQL Server databases or third party applications. This flexibility provides greater control of key business information that might be locked away in various applications throughout the organisation. When brought together, this information can help organisations to develop new marketing strategies, analyse business trends, track and report on key data, improve productivity and make informed strategic decisions that can have a direct influence on profitability or the direction of the business.
Keeping your business healthy
Financial management is at the heart of any business and, when tightly controlled, is one area that can help drive it forward. The financial applications of Opera II Enterprise SQL are designed to do just that.

Sales, Purchase, Nominal, Advanced Nominal, Multi-Currency, Cashbook and Costing provide the integrated tools needed to fully control financial data and processes.
Sophisticated and flexible analysis
The functionality within the Financials effortlessly adapts to the analytical requirements of businesses. Multiple dimensions make it easy to analyse key information, such as expenses or revenues by Nominal Account, Cost Centre, Department or Projects. The financial position is always available and can be analysed and interrogated using definable dynamic view screens.
Financial reporting
Financial reporting is extensive within Opera II Enterprise SQL and includes an Excel-based report writer, XRL (eXcel Reporting Layer). Using XRL, Opera II Enterprise SQL data can be easily manipulated to provide enhanced analytical power, which can assist and simplify even the most complex decision-making processes. Key data from other sources can also be combined to offer complete enterprise reporting. Budget information, stock adjustments and price lists manipulated and maintained within Excel can also be written back into Opera II Enterprise SQL, saving time and effort as well as avoiding re-keying errors.
Supply Chain Management and Payroll & HR
Integrate sales and stock with financial information to automate the delivery of customers' orders with effective stock management. Respond to demand for products and pricing quickly and efficiently, retaining customer loyalty and increasing levels of customer satisfaction, and you have the complete control required to manage the supply chain aspect of your business. Add Payroll & HR, which fully meet HMRC Payroll Standard, and it is clear that Opera II Enterprise SQL delivers a complete financial, supply chain management, Payroll & HR business and reporting solution.
Instant Communications
Pegasus Instant Messenger (PIM) is the intelligent communications application of Opera II Enterprise SQL. It delivers features that go beyond accounting and can actually help grow businesses. Business-critical information can be shared with designated recipients as discreet pop-up messages, e-mails or reports and can be configured by precise business rules, timed events or specific topics. It's easy to set up and use, and puts accounting information to work outside the accounts department — always keeping an eye out for your business.

