DataNAV Driver Setup for csv files

3.39K viewsDataLink
0

Hello Mike:

I am trying to set up the data source connection for a csv file. It is fairly large, 1GB. So, I would like to set it up as a JDBC based data source in DataNAV. I have a plug-in (com.subx.jdbc.csv_0.0.3.jar) that Quantrix. What is the JDBC URL for the driver?

Could I use the scrollable emulation driver for the csv file? If so, what is the JDBC URL? Thank you.

HenryS

0

Hi Mike:

I was hoping to use the csv outside the model because I didn’t want to bring in the whole 1 GB of data. I will give that a try. Thanks.

HenryS

0

Hi – I would recommend using the straight Text import in DataNAV. That will populate the internal Quantrix Columnstore DB where you can then fire off SQL queries against it. It might take a bit for it to import but once in I think you can use DataNAV successfully. The CSV driver you mention has not been revised recently. It was more intended for DataLinks against CSV files… so I am not sure how successful it will be with the latest software.