Jump to content

Error connecting to AWS-RDS Oracle

Manoj Chaurasia

Recommended Posts

I am trying to connect to AWS-RDS Oracle from Tibco Spotfire desktop client. But I get below error.

I am selecting Type as Oracle

Please suggest me the correct driver.

Cannot connect to data source 'AWS', due to invalid configuration or that the data source is not running.

Database reported:

Driver is not appropriate for url: jdbc:tibcosoftwareinc:oracle://evnodsp2.ckcrf8amgfih.us-east-1.rds.amazonaws.com:1521;SID=evnodsp2

Link to comment
Share on other sites

  • 2 weeks later...

Hi Balurajan,

From the connection URL, we can see that you are using Oracle Data Direct template which is not recommended for production usage.

You can try using the Oracle template along with the native(Oracle JDBC for e.g: ojdbc8.jar) driver instead and test the behavior.https://www.oracle.com/database/technologies/appdev/jdbc-downloads.html

Place the jar file in the custom_ext folder in the Spotfire Server installation directory and restart the Spotfire server service.

Create a new data source using the Oracle template and test the behavior.

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