Withdata Software

Import data from multiple JSON files to a single DB2 table

Want to import multiple JSON files into a single DB2 table?

Using Withdata software FileToDB, a JSON importer for DB2, you can import multiple JSON files into a single DB2 table in one go.

Download FileToDB

Import multiple JSON files into a single DB2 table

Login to DB2 -> Choose JSON files -> Set DB2 table -> Import JSON files to DB2 table

Choose DB2 and logon.

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

Select the “JSON” file type.

then show the wizard.

1. Select a folder that constains JSON files.

Support large ( > 4GB ) JSON file.

2. Config first JSON file importing options.

3. Select a DB2 table and config fields.

4. Preview data will be in DB2 table.

5. Import multiple JSON files to the DB2 table.

View imported data in DB2 table

You can schedule and automate this converting task by:

1) Save session and create .bat (Windows) or .sh (Linux/macOS)

2) Set scheduled task.


More about FileToDB – JSON to DB2 converter

30-day free trial