Information Links with CSV files

On the Spotfire Server Box:

1. Go to Configuration tab> Data Source Template and create a new template called "Text File" on the TIBCO Spotfire configuration Tool
   
   <jdbc-type-settings> 
     <type-name>Text File (*.asc;*.csv;*.tab;*.txt)</type-name>
     <driver>sun.jdbc.odbc.JdbcOdbcDriver</driver> 
     <connection-url-pattern>     jdbc:odbc:&lt;TXT_DSN&gt; 
     </connection-url-pattern> 
     <table-types>TABLE, VIEW, NICKNAME, SYSTEM TABLE</table-types> 
     <ping-command>SELECT 1</ping-command> 
     <supports-catalogs>false</supports-catalogs> 
     <supports-schemas>false</supports-schemas></jdbc-type-settings>
   
   
   
2. Save configuration and restart the server
3. Optionally Create a new "Microsoft Access Text Driver" System DSN from the ODBC Data Source Admin tool and call it, say "TXT_DSN" and Select the directory repository where all the .txt or .csv files will be located.

On the Spotfire Client:

1. Setup a Data Source in Information Designer
   
2. Set the Connection URL as jdbc:odbc:TXT_DSN for the Text File Data Source and Save
   
   
   
3. If your resource is located on a network path, then use a DNS Less connection and use the following Connection URL:
   
   
   jdbc:odbc:Driver={Microsoft Access Text Driver (*.txt, *.csv)};DBQ=\\contoso.com\your\network\share\folder;