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.
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.