Linux/Unix
Product Overview
SmartLoader is an ETL Component designed to simplify the loading of CSV files into a database. It has advanced capabilities that includes analyzing the input file(s) structure and generating corresponding configuration scripts to be used for loading the data into a database. It supports reading compressed and uncompressed files. It also supports the Groovy scripting language that lets you implement a wide range of data transformations. It is a must-have in environments that require FAST and SCALABLE loading of CSV files.
Key Features:
- Parsing and loading of plain CSV files into a database
- Automatic creation of destination table if it does not exist
- Auditing of loaded files via generating detailed data loading logs
- Automatic archiving loaded files
- Identification and placement of rejected files into a separate folder
- Advanced file parsing capability for files with same content but different filenames
- Setting of data loading speed
- Support for Groovy scripting language for advanced data transformations
- Support for data loading into Vertica and MySQL databases (support for additional databases being added)
- Run component as needed or schedule it for regular execution intervals