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

[enojardi]

Very weird. Do you have the latest update set (from Share) installed? Does an import set get created at least? (that's one of the first steps of the execute method on JDBCFileLoader script include) After that it goes to create the probe (output ECC record) - are you saying this is not happening either? Could you send some screenshots of the Data source configuration?

[adarsh-homepage]

Hi Jonatan,

We get a CSV file which gets added to a location everyday. Would you please let me about the steps to achieve this through JDBC file loader. We have file loader installed in our instance.

[enojardi]

Hi

Did you download the PDF instructions from Share? Basically, all you need is to set up a JDBC file source, give it a MID server, the location of the file and that's it.

Also, ensure you already have an Import Set Table to load the records to (i.e. preload manually the file directly in the instance, the usual way). A transform map is also required, unless you just want to do "Load only" to start with.

Cheers,

Jonny

[adarsh-homepage]

Hi,

Thank for the steps:

Whatever I select it always gives me "java.sql.SQLException: Directory not found: "

We are on Geneva: It used to work before the upgrade. But after upgrade it never works

[enojardi]

That error is from the csv-jdbc driver, so that tells me that it is running, but somehow doesn't have access to read the directory / or it doesn't exist.

Try another location, start with placing a sample file within the MID Server installation folder to rule out access issues (could be the user running the MID service).

FYI, I have tested in Geneva and Helsinki and it works fine for me.