SaveToDB Framework Diagrams
|Diagram X01||SaveToDB Framework Tables|
Diagram X01. SaveToDB Framework Tables
SaveToDB Framework allows customizing Excel applications using database configuration tables.
The xls.objects table contains the configuration how to save data changes back to a database.
For example, you may specify the target table for any view or stored procedure.
Also, you may supply stored procedures or SQL codes for INSERT, UPDATE, and DELETE operations.
The xls.objects table also is a source of the xls.queries view that is used in the SaveToDB Connection Wizard and Query List.
You may add new objects based on SQL codes, HTTP queries, or text files.
Add SQL codes, URLs, and text files into the TABLE_CODE field.
The xls.handlers table contains the handler configuration.
You may use handlers to configure drill-down queries, cell change handlers, validation lists, parameter values, column formulas, and much more.
The xls.translations table contains translations of database objects, columns, and parameters.
The SaveToDB add-in uses this table to translate names within Microsoft Excel depending on the selected data language in the SaveToDB Options dialog box.
So, you may translate database names to business names in any language.
The xls.formats table contains Excel table formats including sets of table views.
The SaveToDB add-in applies these formats in the first connection to database objects.
Users can save and reload table formats using SaveToDB Table Format Wizard or Save Table Format and Load Table Format menu items.
The SaveToDB add-in uses the xls.workbooks table in the Application Workbooks wizard.
You may add workbook definitions and templates for your applications.
These tables are the required run-time framework for Excel applications.
These tables are common for SaveToDB Framework 8 and SaveToDB Framework 9.
You may install SaveToDB Framework 8.11 in production databases, if you do not need advanced features of the SaveToDB Framework 9.