Features by Products

Features by Products

FeatureVersionEditionSaveToDBDBEditDBGate
Client platformExcelDesktopBrowser
Server platform.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 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 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 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 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✓✓✓
MySQLFree✓✓✓
PostgreSQLFree✓✓✓
Snowflake8+Free✓✓
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✓
Linux✓
.NET Framework
.NET Framework 4.7.2✓✓✓
.NET 8.0✓✓

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.