4 easy steps to import XML data to Redshift

by

Posted on by

Want to import data from XML file to Redshift?

Using File To DB, an XML to Redshift converter for Windows, MacOS, and Linux, you can import XML data to Redshift in 4 simple steps.

  • Can run in GUI mode, Step by Step, just a few mouse clicks.
  • Can run in Command line, for Scheduled Tasks and Streams.
  • Convert locally and privately, avoid uploading large or private file(s) to online services.

Download FileToDB Download FileToDB

Import data from XML file to Redshift in 4 steps

Choose XML file -> Set Redshift table -> Preview -> Import

Choose Redshift and logon.

convert XML file to Redshift table - Choose Redshift and logon

Click “Wizard – 1 File To 1 Table” at task dialog.

convert XML file to Redshift table - task window

Select the “XML” file type.

Import file data to database table - select file type

then show the wizard.

Step #1. Open an XML file.

Import XML Data To Redshift - open XML file

Step #2. Select a table and config fields.

Load Data From XML To Redshift - select table

Step #3. Preview data.

Transfer Data From XML To Redshift - preview

Step #4. Import.

Convert Data From XML To Redshift - import data

Import XML to Redshift in command line

Save session, and then create .bat file for Windows command line, or .sh file for Linux / macOS.

Set scheduled tasks for importing XML to Redshift

You can schedule and automate this converting task by:

1) Save session and create .bat file.

2) Set scheduled task.

FAQ

More about FileToDB – XML to Redshift converter