Page History

...

Before you actually set up your ODBC connection on the Sage server, You you will have to set up your Staging DB database on your database server. This staging db database acts as an intermediary database for the data being exported/imported to Sage. As we use Sage inbuilt in-built mechanism to export and import data, in and out of sage i.e , a visual integrator which has no control over the data being moved. All the data mashing happens in this database so that duplicate records are not processed to in Sage.

The database script attached is of MYSql, you . You can download the following attachment and import it in your mysql database - as explained the latter sections.

or Alternatively, if you are using any other database databases, you will need to download the schema of  in the same in an HTML version to create a database as per your choice.

Steps To Import Staging

...

Database Script:

The below are Follow the steps that need to be followed while setting to set up your staging db database in your database server. 

1. Open SQL yog with you user name username and password, . Make sure your user has all the permission for creation of to create tables and its objects.
2. Create a database with the name of your choice.
3. On the database which you had created, Right click and go to option Option Import → Execute Executing Sql Script will open a file dialog box.
4. Select the script from your download Download folder and Click click Execute for successful to import successfully. 
5. Expand the tables. Then, view , trigger to see for the tables and its objects to make sure items have been successful successfully imported.