Configuring the Connections
DataSync is required for Sage 300 only if you want to consolidate the data into one database so that Reports from different Companies can be viewed into the same one.
Important
Doing this is also recommended if you do not want to query the ERP database that uses Live Data, and would rather query the copy of this database.
Prerequisites
- A version of Sage 300 supported by Sage
- A destination database (preferably, in the same collation as your Sage 300 Database)
- A valid version of DataSync (refer to Installing DataSync for more information)
Set the Connections
Important
Each database you want to consolidate needs its own source connection.
Important
- No matter how many Sources you have, you only need oneDestination connection.
- Time Zone has to be set to GMT when selecting a Tracking Type by Date.
- Follow the procedure described in Adding a Source and Destination Connection to create a Source and a Destination connection.
Example
You should have a result similar to this for the Source connection:
You should have a result similar to this for the Destination connection:
