One of the most common activities following the download of a fixed-length flat file (the kind we used to write in COBOL) is to import it into a modern database.
A second common file transfer activity is to parse a fixed-length file transfer log, such as a Sterling NDM usage report.
Today we released a free command-line utility called “Simple ETL for JDBC” to import fixed-length flat files like these into relational databases such as SQL Server, Oracle, MySQL and H2 using a JDBC connection.
Our “Simple ETL for JDBC” utility is:
- Multiplatform: Written in Java, it can run under Windows, Linux and other platforms that support Java.
- Simple to use: A ZERO CODE approach to column/field mappings is supported. If can you understand phrases like Name=(54,62), you can use this utility.
- Fast: Flat files are read line-by-line and database inserts are performed as lines are parsed.
- Automation-Friendly: 3 verbosity modes and 9 return codes let your scripts, workflows, and operators figure out exactly what did or didn’t happen with every run.
At File Transfer Consulting we use this utility to help us make sense of log files from many different file transfer systems during consolidation surveys and performance analysis. We also deploy it when customers want to quickly upload flat files into databases…and don’t want to have to call a programmer if something changes.
Download your own FREE copy today!
- Simple_ETL_for_JDBC.zip (version 0.9 – PUBLIC BETA)