Withdata FileToDB imports YAML (*.yaml, *.yml) files into DB2 locally — one file into one table, several files into one table, or bulk import many files into many tables. 100% local, secure, and cross-platform.

YAML is a human-readable data serialization format.

Download Free Trial

Why Choose Withdata FileToDB as the YAML to DB2 Importer?

🔒 100% Local & Secure

Your YAML files and DB2 credentials are used only on your own computer. Nothing is uploaded to any cloud server.

⚡ Fast Streaming Import

Millions of rows within a minute. Large files are streamed with low memory usage.

📁 Batch & Merge

Import several YAML files into one DB2 table, or bulk import a whole folder into many tables.

🔄 Nested YAML → Table Columns

Nested mappings become address.city-style column names that can be mapped to table columns.

🗃 6 Load Modes + Auto Create Table

Append, Replace, Update, Upsert, Insert Ignore and Delete. The destination table can be created automatically from the source columns.

⏱ CLI & Scheduled Tasks

Save an import configuration and run it automatically from Windows Task Scheduler or crontab.

Full Feature Comparison

Feature	Supported details
Source file	Local YAML (`.yaml`, `.yml`), batch YAML, merged YAML
Destination database	DB2 (connect with host / port / user / password; SSL where the server supports it)
Load modes	`Append` · `Replace` · `Update` · `Upsert` · `Insert Ignore` · `Delete` — with a multi-column key for Update / Upsert
Import mode	One file into one table · several files into one table · bulk import into many tables
Running mode	GUI wizard · command line · scheduled tasks
Source options	Format-specific parsing for YAML, encoding
Destination options	Schema, table name, create table if missing, column mapping, update key, encoding
Platform	Windows, macOS, Linux (native, 64-bit)

All YAML to DB2 Import Options You Need

Import one YAML file into one DB2 table — step by step in the GUI wizard
Import several YAML files into a single DB2 table
Bulk import many YAML files into many DB2 tables
Insert new rows, or Update/Upsert existing rows using a multi-column key
Run the import from the command line, and schedule it as a scheduled task
All YAML tools and all DB2 tools

YAML to DB2 Import Notes

A top-level sequence of mappings is read as a table — each mapping becomes one row.
Nested mappings are flattened into dotted column names, e.g. address.city, address.zip.
Those column names can then be mapped to the columns of the destination table.
Both .yaml and .yml files are accepted; UTF-8 (with or without BOM) is detected automatically.
Not supported: anchors and aliases (& / *), tags (!!) and multi-document files (---).
Six load modes are available: Append (insert all rows), Replace (truncate then insert), Update, Upsert, Insert Ignore and Delete.
Update and Upsert can use a multi-column key to match existing rows.
The destination table can be created automatically from the source columns, or an existing table can be used.
The destination schema and table can be chosen, and source columns can be mapped to table columns.
The file encoding is detected automatically and can be overridden.

How to Import YAML into DB2 (4 Steps)

Open Withdata FileToDB and connect to your DB2 database (host, port, user, password).
Choose the YAML file to import (or a folder / list of files for batch importing).
Choose the destination schema and table — create it from the source columns if it does not exist — and pick the load mode (Append, Replace, Update, Upsert, Insert Ignore or Delete).
Check the preview and column mapping, then click Import. Save the configuration if you want to run it again from the command line.