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

Description

Obtain information from FileMaker via JDBC and store it in a MySQL database.

Available Actions

Download Data with Datetime Parameters

Download data from a FileMaker database via JDBC using an SQL query and the date range parameters specified. Store the results in a table in a MySQL database.

Variables

Source Parameters
source_db required

Credentials to use to access FileMaker via JDBC.

sql_query required

SQL Query to select the data to download.

user_params

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


Destination Parameters
mysql_connection required

Credentials to use to access the MySQL database.

target_table required

MySQL table name, in schema.table format.

create_table_if_dne required

If the specified table does not exist, enable to automatically create it.


Range Parameters
range_start_point required

Datetime stamp 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

SQL Query to use to determine the end point of the data to process.

process_increment required

This Task will retrieve and load data in increments. This field determines the size of each increment.


Download Data with Integer Parameters

Download data from a FileMaker database via JDBC using an SQL query and the integer range parameters specified. Store the results in a table in a MySQL database.

Variables

Source Parameters
source_db required

Credentials to use to access FileMaker via JDBC.

sql_query required

SQL Query to select the data to download.

user_params

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


Destination Parameters
mysql_connection required

Credentials to use to access the MySQL database.

target_table required

MySQL table name, in schema.table format.

create_table_if_dne required

If the specified table does not exist, enable to automatically create it.


Range Parameters
range_start_point 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 use to determine the end point of the data to process.

process_increment required

This Task will retrieve and load data in increments. This field determines the size of each increment.


Reconcile Data with Date Parameters

Compare a FileMaker table to a MySQL table using the date range parameters specified. 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 FileMaker via JDBC.

source_table required

FileMaker table name.

source_id_column required

Column containing the primary key of the FileMaker table.

source_compare_column required

Column used to find a range of records to reconcile.

sql_query

Optionally replace the default SQL Query used to select missing rows to copy from the FileMaker table.

user_params

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


Destination Parameters
mysql_connection required

Credentials to use to access the MySQL database.

target_table required

MySQL table name, in schema.table format.

target_id_column required

Column containing the primary key of the MySQL table.

target_compare_column required

Column used to find a range of records to reconcile.

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


Range Parameters
buffer required

Amount of time prior to the current datetime to include in the examination.

process_increment required

This Task will retrieve and load data in increments. This field determines the size of each increment.


Reconcile Data with Integer Parameters

Compare a FileMaker table to a MySQL table using the integer range parameters specified. 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 FileMaker via JDBC.

source_table required

FileMaker table name.

source_id_column required

Column containing the primary key of the FileMaker table.

source_compare_column required

Column used to find a range of records to reconcile.

sql_query

Optionally replace the default SQL Query used to select missing rows to copy from the FileMaker table.

user_params

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


Destination Parameters
mysql_connection required

Credentials to use to access the MySQL database.

target_table required

MySQL table name, in schema.table format.

target_id_column required

Column containing the primary key of the MySQL table.

target_compare_column required

Column used to find a range of records to reconcile.

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


Range Parameters
buffer required

Amount of rows before to the most recent row to include in the examination.

process_increment required

This Task will retrieve and load data in increments. This field determines the size of each increment.