CSV/TSV driver is not bundled with Querona, and needs to be installed before use.
Here are the following drivers available:
- ODBC (free)
- CData (commercial).
We recommend to first try the ODBC Text Driver, and if its capabilities are insufficient for your use case, then consider switching to commercial CData driver.
CData Driver installation¶
Follow these steps to install the Windows driver for JSON:
- Go to the CData website.
- In the ADO.NET Provider Download section, select Download Trial or Download Full, depending on your use-case.
- In the list CData Software - Downloads that displays, register or sign-in.
- Download the ADO.Net driver and install the driver.
Custom delimiter in CData driver¶
Let’s assume that we want to connect to a CSV file that:
- has a header,
- is delimited by semicolon character “;”
The following connection string can be used:
DataSource=[ServerName]; IncludeFiles="CSV"; FMT="Delimited(;)"; HDR="Yes";
For different delimiter change the ‘FMT=”Delimited(_put_your_delimited_here_)” property and replace the placeholder _put_your_delimited_here_ with your desired character.