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

How can we join an excel with an oracle connection?


Recommended Posts

Hello!

How can we join an excel with an oracle connection? 

When I add the first data source (excel) in a Spotfire project, the system allows me to join other source (excel, oracle..) but when I add first a Oracle connection, I can not join a new data file or connection.

I mean, in the data designer, there re no the "+" button (images attached).

THANKS!!!!

excel1st.thumb.PNG.8549d2affc3431d6d38ec08476748585.PNG vs

oracle1st.thumb.PNG.2549ee404e72a2263ffcec71dc0cecd2.PNG

Link to comment
Share on other sites

Hello,

A likely explanation could be that your connection to Oracle is set as external (i.e in-database).

You can read about the various restrictions/considerations when using in-database database in the manual:

https://docs.tibco.com/pub/sfire-analyst/12.5.0/doc/html/en-US/TIB_sfire-analyst_UsersGuide/data/data_working_with_in-database_data.htm

If you use internal (in-memory) instead, you should get the missing button/functionality.

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