Customer Banners (Ads) - SpiceUp. AX and SpotfireX Disclaimer



If you find this site useful and you want to support, buy me a coffee   to keep this site alive and without ads.

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;

3 comments:

Jolene Robertson said...

Hey Jose, do you think it's possible to create something similar for an oledb connection?

klata said...

Hi Jose, I think , that there is a pre-requisite needed, the jdbs odbc driver, can you please post how did you added it to Spotfire template?

Jose Leviaguirre said...

Hello Klata, thanks for your comments. I am not sure if the driver is built in on 6.5 and previous versions. It's an old driver and it is not recommended for production environments and seems not to be there since 7.0