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

[Nick12]

Hi all, it is possible to load CSV tab separated through JDBC file loader?  

According documentation it should be possible to "Choose any column separator you like", but the tab character is not accepted in the cell to configure the separator, I've tried to configure it a "\t" but it doesn't work. 

Thanks

Hi, could anyone help me to configure the "tab" (horizontal tab) as column separator in JDBC file loader?

Thanks

[Tommaso Tomaiu1]

Seems that the link to the share project is not working, could you please give the correct one?

Thanks

[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

[arxz]

Hello Jonatan,

I installed the update set and created a job using the JDBC File Loader to retrieve a .csv file from the Mid Server.
However, I received this error:

java.sql.SQLException: No suitable driver found for jdbc:relique:csv:C:\MidServer_Data_Qual\IN\TTM\ at java.sql/java.sql.DriverManager.getConnection(DriverManager.java:702) at java.sql/java.sql.DriverManager.getConnection(DriverManager.java:189) at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62) at

Do specific drivers have to be installed on the MidServer?

Thanks

[Richard Hine]

As I recall there was a 'setup' module (under the application menu) that you need to run as a one time activity, have you done that?

Thanks