How many times have you thought? I wish I could use JDBC to connect and extract data from a flat file instead of a database.
Well… This application (first release / beta version) does exactly that… and more:
* Connect using JDBC to a file via the MID Server
* Support for any flat file (CSV, TXT, etc)
* Support for zipped (.zip) files (containing a flat file)
* Choose any column separator you like
* Choose header row number or no header row at all
* Support for wildcard (*) and dynamic (scripted) file names
* Support for processing multiple files at once (using * wildcard)
* Load all rows from the file or execute your own "SELECT" SQL statement
* Select Import Set mode: Load only or Load & Transform (if a map is available)
* Bonus (experimental): onComplete file action: Copy, Move, Rename or Delete the file!
Link to App in Share: ServiceNow Share
