File Importer - (CSV to SQL Serv

Background

More and more data need to be imported into DWH DB with high quality and speed, thus need to use one consolidated tool to import the data.
Current version of Flexter not support customized column delimiter, which could not 100% solve the problem with DMS data files.

Basic Function

-- Support CSV;
-- Support unzip the CSV file, with password;
-- User could define the encoding value;
-- User could define the column delimiters;
-- User could define the quotes;
-- Configurable parameters for DB connections;
-- Configurable parameters for File Name/File Path;
-- Analysis the file structure before each loading;
-- Validate the volume after each loading;
-- Writing logs for each loading;
-- Meta data support, log each file changes;
-- Set up the loading batch window to avoid use up of the memory;
-- Support batch files loading with right order (File ordered by timestamp);