Change Data source from excel to Oracle

[Manjunath Jannu]

Hi All #dr Spotifre or Spotfire expertise

I have spotfire report created with excel data with 5 different (sheet) table. Now client wants to connectsame report with oracle database

Oracle Databasealso having 5 different table Please help me with this best process to complete this task

1) How to change connection from excel to oracle data base

2) Is there any way to create information Link and connect that link to entire report

2) How i can create information link for this this report

[Harshith Reddy Musku]

Hi,

You can replace the existing tables with the tables in Oracle by creating an Oracle Data connection or creating a data source for Oracle in Information designer andthen information linksfor those tables. You can use data panel or data canvas (which ever applicable to the version you are using), and select 'Replace data source' as mentioned in the document, so that transformations or any other steps will still be intact. But version you are using is prior to 7.11, then the only option would be to select 'Replace data table', and add any transformations again.

 

For 7.11 and above->https://docs.tibco.com/pub/sfire-analyst/7.11.1/doc/html/en-US/TIB_sfire...

 

For 10.x ->https://docs.tibco.com/pub/sfire-analyst/10.2.0/doc/html/en-US/TIB_sfire...

[Manjunath Jannu]

Harshith M Thanks ton for your quick help.

 

I need one more clarification which step is help for the performance of the dashboard ( I have 4 to 5 m recrds in each table )

 

Either replacing table from data source or creating information link for those tables from information designer.

[Harshith Reddy Musku]

Regarding performance, there will be one additional step when using IL. Information Links have to interact with Spotfire Server. i.e Client -> TSS -> Data source . Where as when using Data connection, is just client and data source communication client->Data source and it also depends on resources being used. However both these methods has it's own benefits.

 

https://docs.tibco.com/pub/sfire-analyst/7.11.1/doc/html/en-US/TIB_sfire-analyst_UsersGuide/id/id_what_is_the_information_designer.htm

 

https://docs.tibco.com/pub/sfire-analyst/7.11.1/doc/html/en-US/TIB_sfire-analyst_UsersGuide/connect/connect_what_is_a_data_connection.htm