DB2 import JSON data

Want to import data from JSON file to DB2 ?

Try Withdata FileToDB, a desktop JSON to DB2 converter for Windows, MacOS, and Linux, Convert JSON to DB2, Easy and Fast.

Can run in GUI mode, Step by Step, just a few mouse clicks.
Can run in Command line, for Scheduled Tasks and Streams.
Import JSON to DB2 locally and privately, avoid uploading JSON file(s) to online services.
Support Windows, Linux, and macOS.

Import data from JSON file to DB2

load JSON data to DB2 table - Choose DB2 and logon

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

import JSON data to DB2 table - task window

Select the “JSON” file type.

Import JSON file data to DB2 table - select file type

then show the wizard.

Support large ( > 4GB ) JSON file.

Import Data From JSON File To DB2 - open JSON file

Here is the file’s content.

Import Data From JSON File To DB2 - source JSON file

FileToDB will parse JSON file.

Load Data From JSON File To DB2 - select table

Transfer Data From JSON File To DB2 - preview

Import Data From JSON File To DB2 - import data

View imported data in DB2 table

Convert JSON to DB2 - view data