...
You need to define a Data Share Connection to all the required TABLES for the relevant GMS database specifying the required Synchronisation Settings. Please use one of the following links for a definition of the required Tables and SQL statements for your selected GMS.
| |||||||||||||
Next create a Job to load the tables and build the data. Right click on Jobs and select New Job. Enter a Name for the Job e.g. Build Addresses. Now you need to add the Data Share Connections that you have just created so click on the green plus to display the list of Available Tasks and this will also include the [DataShare] entries. Select each of the entries in turn to add them to the Job.
| |||||||||||||
Next you need to create a Stored Procedure Task to build the data. Right click on the Build Addressees Job in the Workflow and select New Task and select the Stored Procedure radio button. Enter a name for the Task e.g. Build from Symphony and select the correct stored procedure from the drop down list to match the GMS that you wish to connect to.
| |||||||||||||
Make sure that all Tasks, except for the first one, are Dependant on previous Job. You should end up with a Job similar to the screen shot on the right. Next you need to schedule when to run the update. Simply select the Job in the tree and add a schedule. For more information on how to schedule a job please refer to the Job Scheduler topic. |