With ODBClink, you can create and use advanced queries and stored procedures to shape the data during the get data or auto upload process. This is useful to provide the best performance as the data can be pre-shaped and stored in tables.
Simply create queries with a name starting with GETDATA_ and ODBClink will know to execute these during the get data process. The queries will get executed in alphanumerical order.
For Microsoft Access, the following statements are supported:
- ALTER statements
- CREATE statements
- DELETE statements
- DROP statements
- INSERT statements
- UPDATE statements
For Microsoft SQL Server, most type of stored procedures should be compatible.
The ability to use advanced queries and stored procedures is available in ODBClink Pro Edition.