Getting Data from Tables & Views

SaveToDB products can connect to tables and views out of the box.

The set of selected columns depends on the data provider in use. For instance, older OLEDB and ODBC drivers may not support newer data types.

Users can select columns to retrieve and apply as filters. Developers can define these filter columns using the ParameterValues event type in the xls.handlers table. This feature is particularly useful for large tables, as it allows for loading less data by utilizing indexed columns.

DBGate automatically supports paging for tables and views.

See also:

• Saving Data to Tables
• Saving Data to Views