Advanced ETL Processor can load whole file content into database BLOB fields and store useful file metadata at the same time. That is useful for images, documents, attachments, and the occasional folder full of files nobody wants to manage manually anymore.
What You Will Learn
- Use File System Reader to read whole file content.
- Load file data into database BLOB fields.
- Capture file metadata such as name, size, and dates.
- Test exported BLOB data after loading it into the database.
Before You Start
Start with a small sample folder. Loading every file in a directory is easy; explaining why the database grew overnight is less fun.
File System Reader Docs For BLOB Loading
The File System Reader loads the content of an entire file into memory so it can be transformed or written as one unit. For this tutorial, the target is a database BLOB field.
The documentation also shows how File System Reader can load metadata such as directory, file name, size, created date, modified date, accessed date, and file attributes. That metadata is often as useful as the file content itself when someone asks where a document came from six months later.
After loading BLOB data, export a few records back out and compare the files. It is the simplest practical check that the database write preserved the content correctly.
Need Advanced ETL Processor First?
Download the Advanced ETL Processor trial before following the tutorial, or review Enterprise if you need scheduled unattended execution.