2022
SAGE STAGING DATABASE SETUP
Before you actually set up your ODBC connection on the Sage server, You will have to set up your Staging DB on your database server. This staging db acts as an intermediary database for the data being exported/imported to Sage. As we use Sage inbuilt mechanism to export and import data in and out of sage i.e visual integrator which has no control the data being moved. All the data mashing happens in this database so that duplicate records are not processed to Sage.
The database script attached is of MYSql, you can download the following attachment and import it in your mysql database.
or Alternatively if you are using any other database you will to download the schema of in HTML version to create a database as per your choice.
Overview
Content Tools