SaveToDB Framework
The SaveToDB Framework consists of tables, views, and stored procedures that configure the SaveToDB, DBEdit, DBGate, and ODataDB products.
You can easily install, update, and remove the SaveToDB Framework.
SaveToDB Frameworks 8 and 9 include the following tables and views:
SaveToDB Framework 10 adds these tables and views:
Additionally, SaveToDB Framework 10 includes pair views for each configuration table, such as xls.view_objects
for xls.objects
. These views select configuration data from the underlying tables for objects in schemas where the user has permissions.
Note: You can create SaveToDB Framework objects in your schemas without installing the entire framework. Simply copy an object declaration and adjust the schema to your own.
All products identify framework objects by field and parameter signatures, not by object names.
Below are the table structures:
|
|
|
|
|
|
SaveToDB Frameworks are available on all supported database platforms.
Here’s a diagram of the available objects:
MS SQL | SQL DW | MySQL | PgSQL | Oracle | Snowflake | SQLite | |
---|---|---|---|---|---|---|---|
Schemas | |||||||
xls | ✓ | ✓ | ✓ | ✓ | ✓ | ✓ | x |
Roles | |||||||
xls_developers | ✓ | ✓ | x | ✓ | ✓ | ✓ | x |
xls_users | ✓ | ✓ | x | ✓ | ✓ | ✓ | x |
xls_formats | ✓ | ✓ | x | ✓ | ✓ | ✓ | x |
Tables | |||||||
xls.columns | ✓ | ✓ | ✓ | ✓ | ✓ | ✓ | ✓ |
xls.formats | ✓ | ✓ | ✓ | ✓ | ✓ | ✓ | ✓ |
xls.handlers | ✓ | ✓ | ✓ | ✓ | ✓ | ✓ | ✓ |
xls.objects | ✓ | ✓ | ✓ | ✓ | ✓ | ✓ | ✓ |
xls.translations | ✓ | ✓ | ✓ | ✓ | ✓ | ✓ | ✓ |
xls.workbooks | ✓ | ✓ | ✓ | ✓ | ✓ | ✓ | ✓ |
Views | |||||||
xls.queries | ✓ | ✓ | ✓ | ✓ | ✓ | ✓ | ✓ |
xls.users | ✓ | ✓ | ✓ | ✓ | ✓ | 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
.
For detailed descriptions of framework objects, see:
- xls.objects
- xls.handlers
- xls.translations
- xls.workbooks
- xls.formats
- xls.queries
- xls.columns
- xls.users
- SaveToDB Framework Roles
Also, check out these additional topics: