The Ultimate Database Creator for Non-Programmers

Business rules determine how a company functions and what objects it uses to conduct its business. For example, accepting/denying credit, hiring/firing employees, ordering/selling inventory are rules that state how to process information relating to such business objects as 'Accounts Payable', 'Accounts Receivable', 'Personnel', and 'Inventory'.

With help of CentriQS database creator you can design a new database for your business and configure it according to your business rules. You can create database entities that relate to your business objects. CentriQS lets you customize your database according to the business model of your company.

Business workflow determines how a business object relates to a certain process. It creates progression of interdependent steps or actions that comprise the process and set associations with the object. Business workflow also identifies people who participate in the process and deal with the object.

For instance, when you want to sell something, you need to complete certain steps of the sales process in order to reach success in dealing with your prospective client. Your sales workflow will identify dependency between the business object 'Client' and the sales process. Then you will need to determine the steps needed for completing the process.

By embedding tables in a business object it is possible to arrange additional information in rows and columns. This capability of database creator software allows users to organize objects and workflows so that it can be easier to retrieve and navigate through the business data.

CentriQS lets you add tables to your database entities. For example, to keep track of your customer orders you can create the table 'Purchase History' for the entity 'Client'.

Database creation often involves use of OLAP cubes to design and manage complex analytics services. OLAP cubes allow users to create special views that display business data in multiple dimensions which create cells. Each cell represents some measure of the business, for example you can create an OLAP cube analytics view that shows your sales (measure) by customers, region, salesperson, date (dimensions). Pivot table is the best representation of OLAP cube data, so you can use pivot tables to create an analytical report on your sales.

In CentriQS Configurator you can verify and commit database changes. When you make changes to your database, the system highlights the modified items with bold font so it will be easier for you to track your modifications, especially if you change multiple items at once. Before you save or commit your changes to the database, CentriQS validates the changes for errors. In case there is an error found, the system shows an appropriate message, and you can see what’s wrong in the Validation Results log. After the validation procedure is successfully completed your changes are applied to the database.

Navigate with Ease

To start managing your business data in CentriQS db, you can use the Go To menu that lets you navigate across the database. The software also enables easy navigation through reference fields, for example you can use the Links column to open entities linked to your tasks right in the Tasks view.

Creating new entities in your database is made quicker as CentriQS enables you to add "hot" buttons to the Ribbon. This capability lets you add database records in several clicks. You can also the Favorites option to choose the views you want to be displayed on the Navigation bar for quicker access.

Every change made to your database can be tracked, and appropriate users can be notified of that change. CentriQS features a system of subscriptions that enables you to receive notifications of entity changes. For example, when your task is created or changed a notification will be sent out directly to your inbox or internally in the Notifications view. You will receive a bubble alert that tells you what has been done with your task.