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

Description

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

Purchasing Options

FileMaker to MySQL Replicator - $99.99 / month

Available Actions

Replicate Data

Compare data in a FileMaker table to data in a MySQL table. New and updated lines in the FileMaker table will be copied to the MySQL table. Lines that have been deleted from the FileMaker table will be marked in the MySQL table.

Variables

Source Parameters
source_db required

Credentials to use to access FileMaker via JDBC.

source_table required

FileMaker table name, in schema.table format.

sql_query required

SQL Query to select the data to replicate.

user_params

Parameters to use in your SQL Query, if any. Refer to slide out help for more information.

filemaker_id_column required

Column containing the primary key in the row.

filemaker_last_modified_date_column required

Column containing the last modified date of the row.


Destination Parameters
mysql_connection required

Credentials to use to access the MySQL database.

target_table required

MySQL table name, in schema.table format.

target_sql_query required

SQL Query to select the data to compare.

mysql_id_column required

Column containing the primary key in the row.

mysql_last_modified_date_column required

Column containing the last modified date of the row.

mysql_deleted_column 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.

filemaker_to_mysql_map

Shared Config containing mappings between FileMaker column names and MySQL column names.


Range Parameters
pointer required

Integer where the processing of your sequentially sorted data should begin. This field will automatically be updated after each increment is processed.

buffer

Amount to adjust the Next Run Start Point.

end_point_query required

SQL Query to execute against the FileMaker table to determine the end point of the data to process.

process_increment

This Task will process data in increments. Set a value in this field to determine the size of each increment.