SmartLoader
Inovvo, LLC
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 databaseAutomatic creation of destination table if it does not existAuditing of loaded files via generating detailed data loading logsAutomatic archiving loaded filesIdentification and placement of rejected files into a separate folderAdvanced file parsing capability for files with same content but different filenamesSetting of data loading speedSupport for Groovy scripting language for advanced data transformationsSupport 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
Version: Version 20211127
By
Inovvo, LLC
Categories: Data Integration
ELT/ETL
Data Preparation
Operating System
Linux
Delivery Methods
Container
Supported servicesAmazon ECSAmazon EKS
Highlights: Efficient data integration tool designed for parsing and loading of flat compressed and uncompressed data files into Vertica and MySQL databases. It makes efficient use of CPU and memory resources and it is fast and highly scalable. Advanced users can use the Groovy language to extend its data transformation capabilities Automatic sensing of input data file structures and automatic creation of destination tables. it will automatically generate needed configuration files to properly ingest the data. Advanced file management where input files are automatically archived or flagged in case of parsing errors. It also provides detailed logging for troubleshooting and monitoring purposes.
Category: Infrastructure Software
Delivery Method: Container
Company Information
Company Name: Inovvo, LLC
About Company: Inovvo delivers products and services to help customers with their big data projects. Our suite of tools include a scalable analytics platform, industry-leading web classification database and ETL components to simply data loading and transformation.