Features
Reading Data
ODBClink allows you to read data into Data Warehouses (e.g. databases).
Writing Data
ODBClink allows you to write data into your accounting packages. See Writing Data for more information.
Workspaces
ODBClink allows you to setup multiple Workspaces
Data Warehouses
ODBClink can download your accounting packages data into different types of data warehouses (databases).
Scheduled Get Data
ODBClink can download your accounting packages data automatically or overnight.
Financial Years
By default, ODBClink is configured to only retrieve a few financial years into it's memory. This is important to reduce the time the Get Data process takes. However, ODBClink can be configured to pull more (or loss) years into memory.
Read the How to change the numbers of financial years available in ODBClink guide for more information.
Archiving
Speeds up get data and allows reporting on purged transactions by storing historical data and only pulling tranactions which have or could have changed
Accounting Products
ODBClink can connect to the many accounting products. For a full list, see the Accounting Software page.
Consolidating Multiple Data Files
It can also consolidate data from multiple data files and accounting software. For more information, see Consolidating data from multiple data files.