Export data to a MySQL database
This feature requires additional licensing. Please contact AcctVantage Sales for a quote.
Data from a selection of supported tables can be exported to a MySQL database.
Setup
There are a few setup steps necessary before you can begin exporting data.
1. Install MySQL and create the database
Download and install MySQL then create the database to receive data from AcctVantage. Refer to the MySQL developer's instructions for these tasks.
Currently, remote SQL connections are not supported. The AcctVantage Server and MySQL database must be installed on the same hardware.
Also, an AcctVantage Client will need to be installed on the same hardware in order to complete the setup below.
2. Setup AcctVantage to connect to the MySQL database
2.1. Enter the database settings and test the connection
In AcctVantage, navigate to Administration -> System Setup -> Tools & Custom. Enter the info listed below in the Export Database section.
Click Test Connection to verify that AcctVantage can see the MySQL database.
- MySQL Host: Enter localhost.
- Username: Enter the username you created when setting up the database.
- Password: Enter the password you created when setting up the database.
- Database Name: Enter the database name you created when setting up the database.
- AV License Key: Enter the license key provided by AcctVantage Support.
----------
- Enabled Export (checkbox): Check this setting to enable the export to the MySQL database.
- Table Selection and Export Schedule (button): Click this button to select the tables that will be exported and to set the export schedule.
- Test Connection (button): When all of the above info has been entered, click Test Connection verify that it is working.
2.2. Select the tables to export and set the export schedule
On the left side of this window, select the tables that you want to export to the MySQL database.
On the right side of this window, click Set Schedule to set the export frequency.
Click Save when finished and don't forget to check the Enabled Export box to turn the feature on.
The first time an export occurs, every record from the selected tables will be exported.
Each subsequent export will only include new records and/or existing records that have been modified. The system will also remove data that has been deleted from AcctVantage (e.g. if a line item is deleted from a Sales Order it will be removed from the SQL database).
If you want to completely remove any tables that were already exported to the SQL database, uncheck the table in this list and save. The system will remove any unchecked tables during the next scheduled export.
System Logs
When the system completes an export, an entry will be recorded in Administration -> System Logs. This log summarizes the data that was exported, deleted or modified.
