JDBC File Loader (via MID Server)

[enojardi]

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

[arxz]

thanks Jonatan

now working

[stevemac]

Sounds like the required JAR file is not on your ServiceNow instance.  Create the JAR file record, attach the JAR file to it and restart the MID Server agent.  the MID Server will download the file

the image below is from one of our non-prod instances.  FYI - There are newer versions of csvjdbc available, however we have not tested them

regards,

Steve

[Thomas Wright1]

Is there a working link to a share or app for this?

[Kevin Clark1]

Hi @enojardi I've come across an older instance that is running this, and I note that it's no longer on Share.  I'm going to make a recommendation to rearchitect if possible to remove this dependency.  Do you know of any points that would reasons for or against keeping this plugin active in an environment?  

[stevemac]

Would be interested to know how you replace JDBC File loader.  We have decreased usage by increasing updating to ServiceNow tables via API, but still have a significant dependency on JDBC File Loader