proDacapo Connect

proDacapo Connect is our Extract-Transform-Load (ETL) tool.

Connect enables quick and easy system integration. It can be used to "cut & paste" data directly to / from MS Excel or a Text file and to import or export data from other databases.

Better still, Connect enables total integration to other systems, data warehouses or other data sources. Connect ODBC (Open DataBase Connectivity) makes it easy to update and maintain proDacapo and deliver management information on a daily, weekly, monthly or other on-going basis.

Connect runs pre-defined update routines, which can be supplemented by your own SQL commands. For example, Connect will update the Chart of Accounts by removing old accounts, uploading new accounts, combining some accounts, and excluding other nominated accounts such as balance sheet accounts.