SyncServer Pro Configuration
First refer to article "SyncServer Pro Installation" to install required components.
The configuration process for SSP is done within the SyncServer Pro.fmp12 database (SSP DB). Below is a brief overview of the steps required to prepare your databases for syncing.
Add an account to each of your databases called "SyncServer" with any password, and attach this account to the [Data Entry Only] privilege set. Make sure this privilege set has ODBC/JDBC and XML extended privileges. Choose (or make) one primary database that SyncServer Pro will connect to.
Ensure that every table you wish to include in SyncServer services has a primary key field that uses the Get(UUID) calculation function to auto-enter a universally unique id for all records.
Ensure that every base table you wish to support has a Table Occurrence on the Relationship Graph of the primary database whose name is identical to that of the Base Table.
Open the SyncServer Resource database (link provided within SSP DB) and follow the instructions within to add (3) fields to each of the tables you wish to enable, and (3) tables and (1) script to the primary database.
(optional) Prevent possibility of auto-enter data change during a sync or recovery process. When data is inserted or updated into FileMaker using any method other than Import with auto-entry off, there is a potential for Lookups and Auto-Enter calculations to be re-triggered, which could lead to undesired modification of data.
NOTE: After you collect table data on the Tables page, you will be able to run a routine to process an XML DDR of your solution to create a report detailing exactly what to change.
Copy modified database(s) to the secondary server; install the SyncServer Pro engine on each database server and open access to port 9779 from each server. After installation, use the FileMaker Server Admin Console at each server to enable ODBC/JDBC and XML Web Publishing as well as enable FMSE and WPE to be able use and install plugins. See screenshots below.
- Enable Web Publishing
8. Enable ODBC / JDBC
9. Enable the FileMaker API for XML, use the CLI (Command Line Interface) command:
fmsadmin set cwpconfig enablexml=true