We have a requirement to use tab separated file in identity collector.
Did anyone used TAB Separated File before? If Yes, please provide me example
The csv driver guide has an option to specify other file extensions.
installation.html - HXTT Text (CSV) JDBC Drivers for raw data, flat text, CSV file, TSV file, PSV file, fixed-length, an…
Look for the option:
I haven't tried this, but it looks like it's what you're searching for.
The url itself already states:
HXTT Text (CSV) JDBC Drivers for raw data, flat text, CSV file, TSV file
You can use connection url, something like below.
CSV_Separator value should equal to tab space (on a notepad press tab copy the space and paste after '=' sign)
rest other configurations remains same.
Tried this on 6.9.1 P19
I believe this should also works for IDC as well. Hope this helps!
Thanks for your help but we have a file with format(.tsv), not (.csv)
In that case, I'm not aware of OOTB functionality that supports tsv files. Lets hears from others.
custom solution would be to read the tsv in Java program and either convert to csv files or dump the data into staging database table and fetch it from there.
I haven't worked with tsv files but are they different than any other text file?
I mean csv is a comma delimited text file.
Is tsv a regular text file delimited by tab?
Did you try to collect using the approach suggested by Tahir?
We tried Tahir approach but the collector looks for .csv format, not .tsv
Yes, it is text file seperated by tab space but the format is .tsv
It worked :)
The URL should be something like this : jdbc:csv:////home/oracle/ftp?_CSV_Header=true;_CSV_Separator=\t;csvfileExtension=tsv
Retrieving data ...