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 SQL	SQL DW	MySQL	PgSQL	Oracle	DB2	NuoDB	Snowflake	SQLite	SQL CE
Schemas
xls	✓	✓	✓	✓	✓	✓	✓	✓	x	x
Roles
xls_developers	✓	✓	x	✓	✓	✓	✓	✓	x	x
xls_users	✓	✓	x	✓	✓	✓	✓	✓	x	x
xls_formats	✓	✓	x	✓	✓	✓	✓	✓	x	x
Tables
xls.columns	✓	✓	✓	✓	✓	✓	✓	✓	✓	✓
xls.formats	✓	✓	✓	✓	✓	✓	✓	✓	✓	✓
xls.handlers	✓	✓	✓	✓	✓	✓	✓	✓	✓	✓
xls.objects	✓	✓	✓	✓	✓	✓	✓	✓	✓	✓
xls.translations	✓	✓	✓	✓	✓	✓	✓	✓	✓	✓
xls.workbooks	✓	✓	✓	✓	✓	✓	✓	✓	✓	✓
Views
xls.queries	✓	✓	✓	✓	✓	✓	✓	✓	✓	x
xls.users	✓	✓	✓	✓	✓	✓	✓	x	x	x
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_role_permissions	✓	✓		✓
SaveToDB Framework Extension (a separate installation package)
Views
xls.view_columns	✓	✓	✓	✓	✓	✓
xls.view_formats	✓	✓	✓	✓	✓	✓
xls.view_handlers	✓	✓	✓	✓	✓	✓
xls.view_objects	✓	✓	✓	✓	✓	✓
xls.view_queries	✓	✓	✓	✓	✓	✓
xls.view_translations	✓	✓	✓	✓	✓	✓
xls.view_workbooks	✓	✓	✓	✓	✓	✓
Platform-Specific Procedures
xls.xl_actions_set_extended_role_permissions	✓	✓		✓
xls.xl_actions_revoke_extended_role_permissions	✓	✓		✓

Note: In version 10.4 xl_actions_set_framework_10_mode has been renamed to xl_actions_set_extended_role_permissions and xl_actions_set_framework_9_mode has been renamed to xl_actions_revoke_extended_role_permissions.

See detailed descriptions of framework objects: