Топ-100
 
CerebroSQL

Master Data (MDM)

 

Description of the " Master-data (MDM) " table

Viewing data in tables is possible through the built-in  query editor for "SQLite" databases

The work in the mode with the central database is supported.
To configure the program to work in this mode, use the following instruction

Master data is a structured catalog of data stored in randomly constructed cards of pages created in the master.

MDM - allows you to structuredly store arbitrary information, descriptions of systems, networks, servers, databases, contacts, products, etc.

MDM supports work both with the local storage of the program and in the mode using a single repository. 

 
Starting the Master Data Manager

 

In the main window of the program, click the " Master Data Management " button

CerebroSQL - run master data.jpg
CerebroSQL - master data show.jpg
 
Control buttons
CerebroSQL - master data control button.

Page creation wizard

Creating root entries for the object tree

Adding a node to a tree

Refresh object tree

Card creation

Refresh the structure of the current card and display the data

Card search

Moving a card to another node

Remove card / empty node

 

Create a page to store data

 

Launch the page creation wizard

cerebroSQL - show master create page.jpg
 
Control buttons
CerebroSQL - create page control button.

Create a new page

Create a directory

Add item to page

Move element to another node

Export / import page

Refresh the page list

Remove item from page

​​

  • Click the " Create new page " button

  • In the " Value " field, enter the name of the page

  • Close the catalog editor window

 
CerebroSQL - create new page.jpg
Adding an element to the created page

  • Select a page (element on a page) in the "Page structure" list

  • Expand the "Add new element" menu and select the required elements from the list  

CerebroSQL - add new element in page.jpg
 
Item parameters

To configure the parameters of an element:

  • Select an item in the tree

  • Press the button "Show and edit parameter

  • Save the entered parameters by clicking the "Save" button

 
SPLITTER
CerebroSQL - splitter parameter.jpg

It is an element consisting of 2 connected panels.

Align - the position of the element on the form.

  • Top - press the element to the top of the form

  • Left - push the element to the left edge of the form

  • Right - press the element to the right edge of the form

  • Botton - press the element to the bottom edge of the form

  • Client - the element takes up the entire space of the form

AlignWithMargin - padding along the edges of the element

RealTimeDrag - False, a mask is displayed showing the new position of the strip. True, the bar moves as you move the mouse.

HotSpotVisible - show button to resize panels

Percent - the percentage occupied by the first panel of the total width

Height - the height of the element

Width - the width of the element

LockBar - prohibit changing panels with the mouse using the resize button

Orientation - the orientation of the panels relative to each other.

 
GROUPBOX
CerebroSQL - groupbox parameter.jpg

Panel with additional decoration in the form of a frame around and a title

Align - the position of the element on the form.

  • Top - press the element to the top of the form

  • Left - push the element to the left edge of the form

  • Right - press the element to the right edge of the form

  • Botton - press the element to the bottom edge of the form

  • Client - the element takes up the entire space of the form

AlignWithMargin - padding along the edges of the element

Height - the height of the element

Width - the width of the element

Style name - element style name

Caption - title

Font size - font size

 
LABEL
CerebroSQL - label parameter.jpg

Text label

Align - the position of the element on the form.

  • Top - press the element to the top of the form

  • Left - push the element to the left edge of the form

  • Right - press the element to the right edge of the form

  • Botton - press the element to the bottom edge of the form

  • Client - the element takes up the entire space of the form

AlignWithMargin - padding along the edges of the element

Font size - font size

Layout - vertical arrangement of text on an element

  • Center - in the center

  • Top - press the text to the top

  • Bottom - press the text to the bottom

Caption - text

Style name - element style name

Height - the height of the element

Width - the width of the element

Aligenment - horizontal position of text on an element

  • Left - press the text to the left corner

  • Center - text in the center of the field

  • Right - press the text to the right corner

 
EDIT
CerebroSQL - edit parameter.jpg

Text input field

Align - the position of the element on the form.

  • Top - press the element to the top of the form

  • Left - push the element to the left edge of the form

  • Right - press the element to the right edge of the form

  • Botton - press the element to the bottom edge of the form

  • Client - the element takes up the entire space of the form

AlignWithMargin - padding along the edges of the element

Height - the height of the element

Width - the width of the element

Font size - font size

CharCase - text case

  • normal - text in any case

  • upper - uppercase text

  • lower - lowercase text

TextHint - hint for entering text. The tooltip is displayed in an empty field

NumberOnly - the field contains only numbers

Style name - element style name