Parse Text to SQL

Overview

This plugin can be utilized to insert the records into table using the MySQL queries generated after plugin is processed,
It can be utilized in any of the business domain which deals with transactional data.

Key Features & Functionality

• Capable of reading any delimiter separated tabular data from various files .txt, .csv & .tsv
• Accepts a file with single/multiple tabular data and generate SQL queries for respective table with column names as per user inputs.
• Validates every record in the table using a value format/regex pattern provided.
• Skips the Record which doesn’t match per validation during the process and generate no SQL query for that particular record.
• Disregards the superfluous text that sits between any two tables.
• With the guidance of the table column’s start and end indexes, fixed positional tables can read ease.