FLAT FILE PROCESSING.
COST-EFFICIENT PROCESSING AND LOADING OF FLAT FILES INTO LEADING DATABASES
SmartLoader takes the complexity out of the daunting task of ingesting flat files into production database environments
Advanced capabilities that includes automatic analysis of input file(s) structures and generating corresponding configuration scripts
Support for scripting to deliver advanced data transformation capabilities
Viable cost-efficient alternative to exiting ETL platforms
Support for structured flat files (.csv, .txt) as well as compressed .zip files
Input files are automatically archived once ingested and rejected files are identified
Destination tables are automatically created according to configuration settings
Support for Groovy scripting language to deliver advanced data transformation
Input file structure is automatically detected and corresponding configuration files created
Log files are produced for each loaded file that contain various statistics
Smartloader currently supports MySQL and Vertica. Support for additional databases are being added
SmartLoader is a lightweight yet powerful flat file ingestion tool. It has been used in high data volume production environments and can be deployed in minutes. Ideal for small prototyping projects as well as large data volume production projects. It is a key component for analytics and data integration projects. It comes at a fraction of the cost of comparable ETL tools.
Contact us to learn more and to schedule a demo