Kar K Posted April 21, 2019 Share Posted April 21, 2019 Hi I am new to Spotfire, trying to establish connection with oracle SQL developer. Can anyone share their inputs please Link to comment Share on other sites More sharing options...
Khushboo Rabadia Posted April 22, 2019 Share Posted April 22, 2019 When you setup Spotfire server you must have provided Oracle database to use for Spotfire. You can connect to that Oracle database used by Spotfire from Oracle SQL Developer. But you cannot connect Spotfire server through Oracle SQL Developer Link to comment Share on other sites More sharing options...
Kar K Posted April 23, 2019 Author Share Posted April 23, 2019 Thanks for reply. I have installed spotfiredesktop version 7.8. Is it possible to establish connection Link to comment Share on other sites More sharing options...
Kar K Posted April 23, 2019 Author Share Posted April 23, 2019 Thanks for reply. I have installed spotfiredesktop version 7.8. Is it possible to establish connection Link to comment Share on other sites More sharing options...
Khushboo Rabadia Posted April 23, 2019 Share Posted April 23, 2019 Once you install oracle client driver in your machine, oracle data connector will get enabled on your spotfire desktop (After installation of oracle driver, relaunch spotfire desktop). You can check that through Add > Connection To > Oracle, as seen in attached screenshot. Through that Oracle data connection, you can connect to your oracle database. https://community.spotfire.com/wiki/how-install-odac-enable-oracle-connecto... Link to comment Share on other sites More sharing options...
Kar K Posted April 27, 2019 Author Share Posted April 27, 2019 Hi Khusboo,Sorry for the delay to reply. Here are two things, first the above link provided turned out to be access denied, second please find the attached screenshot below and accordingly plug in inputs. [[{"fid":"166851","view_mode":"media_original","fields":{"format":"media_original","field_file_image_alt_text[und][0][value]":false,"field_file_image_title_text[und][0][value]":false,"height":"","width":""},"type":"media","field_deltas":{"2":{"format":"media_original","field_file_image_alt_text[und][0][value]":false,"field_file_image_title_text[und][0][value]":false,"height":"","width":""}},"attributes":{"class":"file-media-original media-element","data-delta":"2"}}]] Link to comment Share on other sites More sharing options...
Khushboo Rabadia Posted April 30, 2019 Share Posted April 30, 2019 You can click on that Yellow warning sign (the detailed error will get copied) and paste to notepad to see the error. Also, you have mentioned localhost in oracle server url. Is your oracle installed on the same machine You can open your Oracle SQL Developer tool to check the connection details which works for your Oracle database and then insert the same in spotfire. Link to comment Share on other sites More sharing options...
Recommended Posts
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 accountSign in
Already have an account? Sign in here.
Sign In Now