Opera 3 SQL SE is the latest edition to the Opera 3 family, which merges the present with the future. Built on the solid foundation of Microsoft SQL Server, Opera 3 SQL SE gives you the familiar look and feel of the current Opera 3 product with the power, security and reliability that a SQL Server database brings. The design of Opera 3 SQL SE follows Microsoft best practice for modern client server applications.

For those familiar with Opera 3, Opera 3 SQL SE provides both technical and functional improvements with the ability to extend the product further to fulfil customer needs. With the addition of powerful reporting through the use of modern Business Intelligence products, Opera 3 SQL SE takes businesses to another level in terms of data presentation and analysis, for informed decision making.

Latest version

Product

Version

Released

Opera 3

2.61.00

Jul 19

Online Filing Manager

4.01.00

Feb 18

Available modules

Opera 3 SQL SE offers a breadth of functionality in the Financial and Supply Chain Management applications, and includes foreign currencies transactions, reporting for EC VAT transactions and online submission of the VAT100 return.

Opera 3 SQL SE includes these modules:

User experience

The Opera 3 SQL SE is a fully integrated system of financial ledgers and supply chain management solutions that blends the traditional user experience with the new. Every business is unique, with individual requirements and particular challenges. You can buy the applications that you need, when you need them, and expand the solution as your business grows. Additionally, the functionality in each application in Opera 3 SQL SE include options that allow you to tailor how your software works.  You can customise it according to your requirements.

Heavy-duty 'data intensive processes'

Heavy duty ‘data intensive processeses’ are run from the PC workstations but all the processing work is done on the ERROR: Variable (Opera3SE) is undefined. server. As well as minimising the impact on your IT network, this means that your workstations are not used at all for the intensive work that a heavy-duty process is doing. Instead they are available for other tasks. These data intensive processeses are included in all the applications in ERROR: Variable (Opera3SE) is undefined..

Feature

Benefit

Data intensive ‘heavy duty’ processing is completed on the server.

This means that your network is not burdened by unnecessary network traffic so your other work won’t be affected. Also, the PC workstations don’t do the work so you can use them for other tasks whilst the server side processes are working.

Scheduling is built in with desktop notifications or email with attachments.

Scheduling your heavy-duty processes for outside of work hours is a major benefit. This means your other tasks are not affected, and you are given notifications when you get in to work in the morning. Also, scheduling is built in so no additional cost is incurred to use the feature.

Smart file locking used in the Nominal Ledger Transfers means minimal effect on users if heavy duty processes are run during office hours.

You can still run these tasks during normal office hours if you would like to, and with sociable locking method, other people could continue to use the software whilst server processes are working.

Heavy-duty processes can be run in the background.

Some processes are suited to be run in the background so that the workstation PCs are released to run other processes in Opera 3 SQL SE.

Heavy-duty processes can be run with or without a report.

Running a heavy-duty process without a report means quicker processing. You can still get to the information you need using the standard reports in the software.

The user menu access feature can be used to control whether tasks can be run later or run in the background.

You can use the menu access feature to control whether users can schedule tasks to be run outside of office hours or in the background, .

Qualified third-party developers will be able to modify Server side processes.

Heavy-duty processes can be modified by Pegasus Third Party Developers if the processes don't quite do what you need them to.

Technical foundation

Opera 3 SQL SE lays the foundations for the future by using 64-bit Microsoft .NET framework technologies in the latest 64-bit Windows Server and Windows desktop operating systems, with Microsoft SQL Server being used for the data store. This is a client-server application that uses the Pegasus Windows Service to manage the communication between the PC workstations and the server as well as monitoring the users in the system.

Feature

Benefit

Microsoft SQL Server is the preferred data store technology for Opera 3 SQL SE.

Microsoft SQL Server is a very well established and secure database technology that you can trust with your data.

Microsoft .NET Framework is 4.7 + is the software development environment.

Opera 3 SQL SE is built using current Microsoft development technology. Today's technology building today's software.

The Windows Communication Foundation (WCF) feature of Microsoft .NET Framework is used to manage the communication between the workstations and the server.

Windows Communication Foundation makes it possible for secure and reliable communications in client-server applications such as Opera 3 SQL SE.

The Managed Extensibility Framework feature of Microsoft .NET Framework integrates bespoke applications as add-ons to Opera 3 SQL SE.

Bespoke add-on features can be seamlessly added to Opera 3 SQL SE without any further configuration.

The Language Integrated Query (LINQ) feature of .NET Framework allows bespoke applications to query data using object orientation methodologies.

This gives the ability to query SQL Server relational databases and XML data using a query language that is integrated with the C# (C-sharp) programming language.

The Entity Framework feature of Microsoft .NET Framework creates a bridge between the ‘objects’ used in the Opera 3 SQL SE programs and the 'relational' nature of Microsoft SQL Server databases.

Entity Framework manages the database connections and mapping of objects to the Opera 3 SQL SE database. It allows bespoke solutions to be developed against relational databases in terms of application-specific objects instead of the relational database.

Simple and straightforward installation wizards, and purpose built Server Administration & Monitoring software.

Opera 3 SQL SE is simple to install and straightforward to initialise and configure.

For more information, please visit www.pegasus.co.uk.

 Opera 3 SQL SE Guides

Opera 3 SQL SE Latest Updates