How to connect File-Based Data Sources such as csv/txt through TIBCO Data Virtualization (TDV)
Article ID: KB0076610
Updated On:
| Products | Versions |
|---|---|
| TIBCO Data Virtualization | All Versions |
Description
You can directly connect to File-Based Data Sources like CSV/txt through TDV and pull the desired data into the Spotfire Analyst/Client. To create a File-Based Data source type, you don’t have to install any driver. All you need to do is to create the data source and fill in the necessary values in the dialog boxes.
Issue/Introduction
How to connect File-Based Data Sources such as csv/txt through TIBCO Data Virtualization (TDV) previously known as Advanced Data Services (ADS)
Environment
All Supported Operating Systems
Resolution
Following are the steps to achieve your goal:
1.> Open Data Virtualization/Composite Studio and right click on the shared folder and select “New Data Source”. A new dialog window will pop up. Select the “File Delimited” option.
2.> After selecting the "File Delimited" option, click on the “Next” button. A new dialog window will pop up. You can set the direct path of the .csv/.txt file, or you can choose to pick files from the shared location.
3.> Introspect the data source in studio. You can also directly drop the .csv/.txt file into the right-hand-side screen to make use of it. Publish the TDV view which you have just created.
4.> Open the TIBCO Spotfire Analyst, select "Tools >> Information Designer" from the menu, and create a new Spotfire data source of type "Spotfire Application Data Services".
5.> The format of the database connection string for such an TDV data source is as follows:
jdbc:compositesw:dbapi@<server>:<port9401>?domain=<domain>&dataSource=<data_source>
Enter the desired details and your TDV username/password credentials and save the Spotfire data source. Then you can use it to create a Spotfire information link to pull data into the Spotfire client.
For example, if the name of the server you have TDV installed on is "MyAdsServer" and it is listening for JDBC clients on the default JDBC port for TDV(which is 9401) with a domain of "composite", and the name of your published ADS view is "MyFileDataView", this will be the TDV database connection string you enter in your Spotfire Information Services data source dialog:
jdbc:compositesw:dbapi@MyAdsServer:9401?domain=composite&dataSource=MyFileDataView
1.> Open Data Virtualization/Composite Studio and right click on the shared folder and select “New Data Source”. A new dialog window will pop up. Select the “File Delimited” option.
2.> After selecting the "File Delimited" option, click on the “Next” button. A new dialog window will pop up. You can set the direct path of the .csv/.txt file, or you can choose to pick files from the shared location.
3.> Introspect the data source in studio. You can also directly drop the .csv/.txt file into the right-hand-side screen to make use of it. Publish the TDV view which you have just created.
4.> Open the TIBCO Spotfire Analyst, select "Tools >> Information Designer" from the menu, and create a new Spotfire data source of type "Spotfire Application Data Services".
5.> The format of the database connection string for such an TDV data source is as follows:
jdbc:compositesw:dbapi@<server>:<port9401>?domain=<domain>&dataSource=<data_source>
Enter the desired details and your TDV username/password credentials and save the Spotfire data source. Then you can use it to create a Spotfire information link to pull data into the Spotfire client.
For example, if the name of the server you have TDV installed on is "MyAdsServer" and it is listening for JDBC clients on the default JDBC port for TDV(which is 9401) with a domain of "composite", and the name of your published ADS view is "MyFileDataView", this will be the TDV database connection string you enter in your Spotfire Information Services data source dialog:
jdbc:compositesw:dbapi@MyAdsServer:9401?domain=composite&dataSource=MyFileDataView
Attachments
Feedback
Yes
No
Powered by
