You can't use this until you register with us!

Description

Update a MySQL table to reflect additions and deletions made in a FileMaker table.

Purchasing Options

everything plan - $0.0 / day

Available Actions

Reconcile Data

Compare a FileMaker table to a MySQL table. Mark rows in the MySQL table that have been deleted in the FileMaker table. Add rows that are missing in the MySQL table.

Variables

Source Parameters
source_db required

Credentials to use to access the FileMaker database.

filemaker_table_name required

Name of the FileMaker table to compare.

filemaker_id_column required

Column containing the primary key of the FileMaker table.

filemaker_extract_query

Replace the SQL Query used to select missing rows to copy from the FileMaker table.


Destination Parameters
mysql_connection required

Credentials to use to access the MySQL database.

mysql_table_name required

Name, in schema.table format, of the MySQL table to compare.

mysql_id_column required

Column containing the primary key of the MySQL table.

mysql_deleted_flag required

Name of the column in the MySQL table where a True value will be placed if the corresponding row has been deleted in the FileMaker table.

mysql_date_tracking_field required

Name of the column in the MySQL table to use to determine when the row was last modified.


Range Parameters
lookback_period

Number of months prior to the current datetime to include, based on the Updated Column value, when determining which rows to compare in the MySQL table.

batch_size required

Number of rows to compare at a time.