RealTimeToDB User Interface

RealTimeToDB User Interface

RealTimeToDB is a Windows application.

The main application form allows performing service operations and monitoring services.

RealTimeToDB Interface

See the following topics about user interface elements:

Open Configuration File
Opens the RealTimeToDB.exe.config file. You can check or edit application settings.
Open Connection Manager
Opens Connection Manager to edit connection strings in visual mode.
Open Data Provider Manager
Opens Data Provider Manager to edit RealTimeToExcel data provider settings like working hours, refresh intervals, etc.
Exit
Stops all the running services and closes the application.
Start Services
Starts updating databases with real-time data.
Pause Services
Stops the timer that starts updating databases.
Use this button to stop updating temporarily. To start updating, click the Start button.
Stop Services
Stops all the running services.
Reload Database Data
Saves current data to databases and reloads data from databases.
Use this button to reload data when you add new tickers to database tables.
Save Data To Database
Saves current data to databases immediately.
Use this button, if the services have been paused, or you need to update the data before the next timer event.
Help
Displays the local help.
Online Help
Opens the online help web page.
Technical Support
Opens the support web page.
RealTimeToDB Website
Opens the product web page at the official website.
Register Product
Displays the Register Product wizard.
Buy License
Opens the web page to start purchasing.
Check Updates
Opens the web page to download updates.
About RealTimeToDB
Displays the About RealTimeToDB dialog box.

The menu contains links for integrated RealTimeToExcel.

Help
Displays the local RealTimeToExcel help.
Online Help
Opens the online RealTimeToExcel help web page.
Register Product
Displays the Register Product wizard for registering RealTimeToExcel.

Table Columns

Status Image
The image indicates table status: green or red.
Table
The column displays database table name.
Rows
The column displays loaded row count.
Pending
The column displays the amount of pending rows.
Last Topics
The column displays the amount of topics that the real-time server returns on the last data refresh.
Last Notify
The column displays the time of the first data change notification from the real-time server after the last data refresh.
Last Refresh
The column displays the start time of the getting changed data from the real-time server.
The period between the notification and getting the changed data depends on the RefreshTimerInterval value.
Last Save
The column displays the time when the last data have been saved to a database.
The period between the notification and this time shows the maximum delay for real-time data in a database.
Status
The column displays the status of real-time server and database operations.
Topics
The column displays the amount of topics connected to the real-time server.
Usually, this is the row count multiplied by real-time column count.
MSPR
The column displays average speed of saving data to a database in milliseconds per row (MSPR).
ProgID
The column displays RTD server ProgIDs or DDE service names.
Server
The column displays database servers.
Database
The column displays database names.