Features by Products

Features by Products

FeatureVersionEditionSaveToDBDBEditODataDBDBGate
Client platformExcelDesktopBrowserBrowser
Server platform.NET.NET
Getting Data
Query listsFree
Getting data from tables and viewsFree
Getting data from stored proceduresFree
Getting data from SQL queriesFree
Getting data using ODataFree
Getting data using REST API10+Free
Getting data via DBGate8+Free
Getting data via ODataDBFree
Getting data from the webFree
Getting data from text filesFree
Getting data from Excel and DBF8+Free
JSON forms10+Free
Dynamic columns8+Enterprise
Many-to-many relations8+Free
Related queries8+Free
Named cells as parametersFree
Named cells as fieldsFree
Keeping formulas8+Free
Keeping comments10+Free
Converting formulas8+Free
Converting hyperlinks9+Free
Configuring column properties9+Free
Windows, Forms, Basic authenticationFree
OAuth1 and OAuth2 authentication10+Free
Table formats from databasesFree
Application workbooks from databasesFree
Saving Data
Saving changes to tablesStandard
Saving changes to viewsStandard
Saving changes using stored proceduresStandard
Saving changes using custom SQLStandard
Saving changes using cell change handlersEnterprise
Saving changes using JSON parameters8+Standard
Saving changes using ODataStandard
Saving changes using REST API10+Standard
Saving changes via ODataDBStandard
Saving changes via DBGate8+Standard
Merging data to tables and viewsStandard
Merging data using stored proceduresStandard
Merging data using custom SQLStandard
Disabling saving data8+Free
Updating changed cells only8+Free
Encoded parametersFree
Context parametersFree
Saving formulas8+Standard
Saving comments10+Standard
Change Handlers
Change handlers using stored proceduresEnterprise
Change handlers using custom SQLEnterprise
Change handlers using tablesEnterprise
Change handlers using viewsEnterprise
Change handlers using REST API10+Enterprise
Change handlers with OData10+Enterprise
Change handlers with ODataDB8+Enterprise
Change handlers with DBGate8+Enterprise
Context parametersEnterprise
Protecting rows8+Free
Value Lists
Validation listsFree
Selection lists8+Free
Parameter valuesFree
Filtered and dynamic lists8+Free
Dependent lists10+Free
Value lists using tables and viewsFree
Value lists using stored proceduresFree
Value lists using custom SQLFree
Value lists with fixed valuesFree
Value lists with REST APIFree
Value lists with ODataFree
Value lists with ODataDBFree
Value lists with DBGateFree
Context Actions
Actions menuFree
Context menuFree
Double-click handlersFree
Selection change handlersFree
Handler output targetsFree
Converting output using RegEx9+Free
Running macrosFree
Running CMD commandsFree
Translating Data and UI
Translating object namesFree
Translating columns and parametersFree
Translating dataFree
Translating user interfaceFree
VBA Integration
SaveToDB methods from VBAFree
SaveToDB Framework
xls.queriesFree
xls.objects8+Free
xls.handlersFree
xls.columns10+Free
xls.translations8+Free
xls.formatsFree
xls.workbooks8+Free
xls.usersFree
Supported Database Platforms
SQL ServerFree
Oracle DatabaseFree
DB2Free
MySQLFree
PostgreSQLFree
NuoDBFree
Snowflake8+Free
SQL Server CompactFree
SQLiteFree
HTTP and File Data Sources
JSONFree
XMLFree
CSVFree
HTMLFree
Plain textFree
HTTP Authentication Schemes
BasicFree
WindowsFree
FormsFree
OAuth110+Free
OAuth210+Free
Operating Systems
Windows 11
Windows 10
Windows 8
Windows 7
Windows Vista7/8
Windows XP7
Linux
.NET Framework
.NET Framework 4.7.2
.NET Framework 4.5.27/8
.NET Framework 4 Client Profile7
.NET 8.0