Jump to content
We've recently updated our Privacy Statement, available here. ×

Change Data source from excel to Oracle


Manjunath Jannu

Recommended Posts

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

Link to comment
Share on other sites

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...

Link to comment
Share on other sites

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.

Link to comment
Share on other sites

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

Link to comment
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
×
×
  • Create New...