SaveToDB Edition Comparison

SaveToDB Edition Comparison

FeatureFree
Edition
Standard
Edition
Enterprise
Edition
Getting Data
Loading data from database tables, views, and stored procedures
Loading data from web data sources (XML, JSON, CSV, HTML)
Loading data from XML, JSON, CSV, HTML, and plain text files
Loading data from Excel workbooks
Loading data from CSV files
Loading data from DBF files
Saving Data
Saving data from Excel to SQLite
Saving database table data from Excel to server databases
Saving data loaded from views and stored proceduresx
Saving data from Excel to OData web services, including ODataDBx
Saving data from Excel to REST API web services, including DBGatex
Saving data to databases and services using cell change handlersxx
Saving data to databases and services using VBAx
Saving data to CSV, HTML, and SQL INSERT
Advanced UI Features with No Coding
The Reports tab to create interactive reports
The ribbon Query List to switch queries
Ribbon controls to change query parameters and WHERE fields
User's table views to apply saved views in one click
Encrypting Excel connection string passwords
Keeping formulas on data refresh
Keeping comments on data refresh
Opening the last opened workbook at startup
Interactive cells to change Excel AutoFilters
Table cursors and interactive fields to view and edit data
Pivot tables as data editors
Task panes to show images
Task panes to edit cell contents
Task panes to select validation list values
Task panes to view and edit row values
Double-click calendars to input dates
Context menus to create Outlook tasks, appointments, and emails
SaveToDB Wizards
Database Connection Wizard
Web Data Connection Wizard
Text File Connection Wizard
Pivot Table Connection Wizard
DB RTD Connection Wizard
Data Publishing Wizard
Data Merge Wizard
Connection Change Wizard
Table Format Wizard
Developer Tools
Application Installer
Application Workbooks
Developer-Customizable Features
Saving changes to target tables and viewsx
Saving changes using stored procedures or SQL codesx
Saving changes using REST APIx
Saving changes using server-side cell change handlersxx
Saving Excel formulas in a databasex
Saving Excel comments in a databasex
Saving bulk changes using procedures with JSON parametersx
Dynamic JSON forms
Data translation
Dynamic column headers for multi-tenant applicationsxx
Dynamic Excel validation lists
Dynamic parameter value lists
Configuring list dependencies
Converting loaded text values to formulas
Converting loaded text values to hyperlinks
Saving and loading Excel table formats
Customizable ribbon action menus
Customizable Excel context menus including drill-down queries
Showing table data, HTML, XML, and images in context task panes
Showing table descriptions in context task panes
Generating application workbooks from a database
Using the add-in as a VBA library
Supported Database Platforms
SQL Server, Oracle Database, MySQL, PostgreSQL
SQLite
Snowflake
Supported HTTP Authentication Schemes
Basic, Windows, Forms
OAuth1, OAuth2
Supported Operating Systems
Windows 7/8/10/11
Supported .NET Framework Versions
.NET Framework 4.7.2+
Licensing
LicenseMITEULAEULA
Commercial Use

Starting with SaveToDB 10, the SaveToDB Personal edition is available only through the upgrade warranty and is not available for new purchases.

Here’s a sample of the cell change handler available in the SaveToDB Personal and Enterprise editions only:

CREATE PROCEDURE [xls17].[usp_sales_change]
    @column_name nvarchar(255) = NULL
    , @cell_value nvarchar(255) = NULL
    , @cell_number_value int = NULL
    , @id int = NULL
AS
BEGIN

SET NOCOUNT ON

IF @column_name = 'licensee'
    BEGIN
    UPDATE dbo17.sales SET licensee = @cell_value WHERE id = @id
    RETURN
    END

IF @column_name = 'product_id'
    BEGIN
    UPDATE dbo17.sales SET product_id = @cell_number_value WHERE id = @id
    RETURN
    END

END

The SaveToDB add-in triggers these handlers on every cell change.

Change handlers can utilize predefined parameters like @column_name, @cell_value, or @cell_number_value, as well as column values using parameters with matching names, such as @id.

These handlers can update underlying tables or raise exceptions to prevent cell changes.

This website is using cookies. By continuing to browse, you give us your consent to our use of cookies as explained in our Cookie Policy.