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

Description

Obtain data from Excel Spreadsheets stored in S3 and load it into a MySQL database.

Purchasing Options

Excel Spreadsheet Loader - S3 to MySQL - $99.99 / month

Available Actions

Load Data

Read data from Excel Spreadsheets and store it in MySQL.

Variables

Source Parameters
aws_token_connection

Select the AWS Access Keys to use to access the S3 bucket where the files are stored.

iam_role

Optional. ARN of an IAM role to use for S3 bucket access.

bucket_shared_config required

Select the Shared Config that contains information about the S3 Bucket where the files are stored.

s3_folder_path

Path from the starting folder in the S3 Bucket Configuration to the folder where the files are stored.

process_subfolders required

If enabled, data in Excel spreadsheets within subfolders under the Folder Path will also read and loaded.

file_lookback

Specify the number of load records to examine, from most recent and going backwards, when comparing to determine which files have not yet been loaded. If no value is specified, all load records will be examined.

sheet_name

Optionally specify a unique name to use to locate the sheet.


Destination Parameters
mysql_connection required

MySQL database where the data from the Excel spreadsheets will be loaded.

target_table_name required

Table name, in schema.table format, where the data from the Excel spreadsheets will be stored.

source_file_column required

Column within the Target Table where the path to the spreadsheet that was the source of the data will be stored.

header_row

Enable if the Excel spreadsheets contain a header row.

mappings required

Mappings between the columns in the Excel spreadsheet and the columns in the Target Table.