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 6.0✓✓