Import JSON Files to Oracle

Fast, parallel file import using DuckDBStream

Source

JSON

.json files

FastTransfer

DuckDBStream

Target

Oracle

Terminal

FastTransfer.exe `
  --sourceconnectiontype "duckdbstream" `
  --sourceserver ":memory:" `
  --query "SELECT * FROM read_json('D:\path\to\files\*.*.json', filename=true)" `
  --targetconnectiontype "oracle" `
  --targetserver "your-server" `
  --targetdatabase "your-database" `
  --targettable "your-table" `
  --method "DataDriven" `
  --distributekeycolumn "filename"  `
  --datadrivenquery "select file from glob('D:\path\to\files\*.json')"  `
  --degree -2  `
  --loadmode "Truncate"  `
  --mapmethod "Name"

Related Pipelines

✨ Key Features

•Parallel file processing with DuckDBStream
•Streaming architecture - minimal memory usage
•Wildcard pattern support for multiple files
•Automatic schema detection

🚀 Performance

•DataDriven parallelization
•Configurable degree of parallelism
•Optimized bulk loading
•Production-ready reliability