Want to import data into Redshift from mongodb exported JSON file?
Using File To DB, a native GUI tool for Windows, MacOS, and Linux, you can import MongoDB exported JSON data into Redshift easily and fast, just a few mouse clicks!
Download FileToDB
Windows 64 bit
Windows 32 bit
Linux .deb (For Debian, Ubuntu) 64 bit
Linux .rpm (For Red Hat, Fedora, SUSE) 64 bit
MacOS 64 bit
Import data into Redshift from MongoDB exported JSON file
Choose Redshift and logon.
Click “Wizard – 1 File To 1 Table” at task dialog.
Select the “JSON” file type.
then show the wizard.
1. Open a MongoDB exported JSON file.
2. Select a table and config fields.
3. Preview data.
4. Import.
You can schedule and automate this converting task by:
1) Save session and create .bat file.