Technical Details of How Orixa is created

This section of the Help System is not useful for people usinG an Orixa App, or even for those working on administration of Orixa Apps.
It details the underlaying code-base that builds the system, and is for use by coders of the system.

• 1. The Orixa Server Program
• 2. Creating a new App from scratch in the Orixa DB Utility
• 3. Third party components used
• 4. Making Changes to your App Running Change Scripts
• 5. Restoring a database from a backup file in the Orixa Server Program
• 6. Where Orixa Saves Configuration Settings for different parts of an Application

What is an Orixa App?

Orixa Apps are fully compiled Windows executable files. They are first-class programs, like Word, Excel or Powerpoint. Orixa is not web-based (although data in Orixa Apps can easily be saved / stored and shared via cloud-based systems). Orixa is not a system built on someone else's web-framework. Orixa is not an add-on or extension to other large-scale software tools such as SAP, SAGE or Oracle.

When you buy an Orixa system you are buying your own enterprise level database which you will own and manage, you will not be dependent on a third party for a complex product built on a complex tool-chain which may change at any time. Once you have a working system no random updates or changes will be made that may break or damage it.

Orixa removes most of the complexity of a client-server system by creating a robust framework which minimizes the need for a database admin. However Orixa includes most of the advantages of a client-server database such as multi-user access, detailed audit logs and fall-over recovery / back-up.

Software tools used to build Orixa

Orixa Apps are built using a software tool called Delphi, which can be used to build any type of computer program. Many of the world's largest software products are built with Delphi, and it has a history that stretches back 25 years. While this is old by the standards of modern systems Delphi is an up-to-date product which is in full active development, meaning that as extensions to operating systems like Windows occur, Delphi is kept up to date to cope with these changes.

This means we can quickly build build a main application for you, using the Orixa Framework with its many pre-programmed modules, and then add on additional bespoke functionality such as tablet-computer based Apps, or Android Phone Apps which will link directly into your main database using Delphi.

Orixa also leverages best-in-class software tools so that we do not need to do the hard work of writing every single element of your program. A few of the companies whose tools we use are detailed below.

	Delphi by Embarcadero Delphi is a long-standing development environment which has been used to develop enterprise strength programmes for more than 25 years. While it is one of the programming environments with the longest track-record it is constantly modernized and is capable of producing code that fully conforms to all modern specifications and requirements. The Delphi software eco-system is rich and large, with a good number of skilled coders and many software houses writing code to support the product and add extra features. At Orixa Delphi is used for all App development. Links to Embarcadero: embarcadero.com/products/delphi
	Dev-Express visual components DevExpress are one of the strongest developers of components for visual aspects of Apps. Their multi-award-winning code powers the applications of many of the world's biggest businesses. Links for DevEx: devexpress.com/products/vcl/
	Elevate Software  Elevate have been building database tools for almost 20 years. Their ElevateDB is a powerful "pocket battleship." A fully ISO SQL2003 compliant Client-Server database, Elevates features are fair too complex to summarize in one or two paragraphs.  At Orixa we have been using Elevate since around 2003, and it has remained in constant development and enhancement throughout that time, meaning that today it is still a powerful cutting-edge tool. One of the major advantages of Elevate is that there are no user-fees or licenses for their product, meaning you do not have to pay extra for extra users. Links for Elevate Software: elevatesoft.com/products
	Fast Reports Fast Reports build a full range of reporting tools. Orixa uses their reporting engine for generation of printed reports and PDFs. It is a modern solution for integrating Business Intelligence in your software. Fast Reports incorporates a wide range of reporting capability including generatation of an extremely wide range of reporting formats and full end-user customizabililty. Links for Fast Reports: fast-report.com/en/
	TMS Software Orixa Apps use TMS for provision of: Mapping tools for geolocation. Diagramming tools for system design and management and for adding visualizations such as factory plans to your App. Links for TMS: tmssoftware.com/site/