Converts the content in PDF's stored on S3 to JSON data stored in a MySQL database.
Executes the query specified against a source MySQL database to obtain a list of PDF's to process. S3 location and other metadata returned from the query is used to locate and read the PDF's, convert their content to JSON data and store that converted data in a destination MySQL database.
Select the MySQL database where the query will be executed to find PDF's to process.
Specify a primary key value. Conversions will begin with the row containing a primary key value that is after the value specified in incremental sort order. Leave this field blank to process all rows in the query result. This field will be automatically set to the primary key value of each row processed during Task execution.
Specify the SQL query to obtain the list of primary keys and S3 bucket paths for the PDF's to process.
Select the AWS Access Keys to use to access the S3 bucket where the PDF's are stored.
Specify the name of the S3 bucket where the PDF's are stored.
Select the MySQL database where the JSON output will be stored.
Specify the name of the table, in schema.table format, where the JSON output will be stored. If the table does not exist, it will be created.
Specify the name of the column in the destination table where the primary key for each converted PDF will be stored.
Specify the name of the column in the destination table where the JSON data from each converted PDF will be stored
Specify the name of the column in the destination table where a success message or error information about the conversion will be stored.
If enabled, existing entries in the destination table with the same primary keys as the PDF's being processed will be overwritten.