SaveToDB Framework

SaveToDB Framework

SaveToDB Framework is a set of tables, views, and stored procedures used to configure SaveToDB, DBEdit, DBGate, and ODataDB products.

You can easily install, update, and remove SaveToDB Frameworks.

SaveToDB Frameworks 8 and 9 have the following tables and views:

SaveToDB Framework 10 has an additional table and view:

Also, SaveToDB Framework 10 contains pair views for each configuration table like xls.view_objects for xls.objects.

Such views select configuration data from the underlying tables for objects in schemas where a user has permissions.

Note you can create SaveToDB Framework objects in your schemas if you do not need to install the entire framework.

Just copy an object declaration and change the schema to your own.

All products detect framework objects by field and parameter signatures but not the object names.

Below are table structures:

xls.objects
ID
TABLE_SCHEMA
TABLE_NAME
TABLE_TYPE
TABLE_CODE
INSERT_OBJECT
UPDATE_OBJECT
DELETE_OBJECT
xls.handlers
ID
TABLE_SCHEMA
TABLE_NAME
COLUMN_NAME
EVENT_NAME
HANDLER_SCHEMA
HANDLER_NAME
HANDLER_TYPE
HANDLER_CODE
TARGET_WORKSHEET
MENU_ORDER
EDIT_PARAMETERS
xls.columns
ID
TABLE_SCHEMA
TABLE_NAME
COLUMN_NAME
ORDINAL_POSITION
IS_PRIMARY_KEY
IS_NULLABLE
IS_IDENTITY
IS_COMPUTED
COLUMN_DEFAULT
DATA_TYPE
CHARACTER_MAXIMUM_LENGTH
PRECISION
SCALE
xls.translations
ID
TABLE_SCHEMA
TABLE_NAME
COLUMN_NAME
LANGUAGE_NAME
TRANSLATED_NAME
TRANSLATED_DESC
TRANSLATED_COMMENT
xls.formats
ID
TABLE_SCHEMA
TABLE_NAME
TABLE_EXCEL_FORMAT_XML
APP
xls.workbooks
ID
NAME
TEMPLATE
DEFINITION
TABLE_SCHEMA

SaveToDB Frameworks are available on all supported database platforms.

Below are the diagram of the available objects:

MS SQLSQL DWMySQLPgSQLOracleDB2NuoDBSnowflakeSQLiteSQL CE
Schemas
xlsxx
Roles
xls_developersxxx
xls_usersxxx
xls_formatsxxx
Tables
xls.columns
xls.formats
xls.handlers
xls.objects
xls.translations
xls.workbooks
Views
xls.queriesx
xls.usersxxx
xls.view_columnsxxx
xls.view_formatsxxx
xls.view_handlersxxx
xls.view_objectsxxx
xls.view_queriesxxx
xls.view_translationsxxx
xls.view_workbooksxxx
Procedures
xls.xl_update_table_formatxxx
Platform-Specific Procedures
xls.xl_actions_add_to_xls_users
xls.xl_actions_add_to_xls_formats
xls.xl_actions_add_to_xls_developers
xls.xl_actions_remove_from_xls_users
xls.xl_actions_remove_from_xls_formats
xls.xl_actions_remove_from_xls_developers
xls.xl_actions_set_framework_10_mode
xls.xl_actions_set_framework_9_mode
xls.xl_actions_set_role_permissions

See detailed descriptions of framework objects:

See also additional topics: