Oracle Integration

rohann over 7 years ago

I am Trying to integrate oracle with my Appian Cloud System and in the process of adding a additional data source i am getting an error of invalid connection string. The Sample connection string wrote was:

jdbc:oracle://hostname:1521/oracle DB name?useOldAliasMetadataBehavior=true&autoReconnect=true

Any Help please would be appreciated!!

Discussion posts and replies are publicly visible

0 ChristineH
Certified Lead Developer
over 7 years ago

Since you are on the cloud, have you worked with the cloud team to establish a VPN tunnel?
forum.appian.com/.../Cloud_VPN_Integration.html
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 gianninol over 7 years ago

I recently ran into something similar, and the problem was that I was missing the 'thin:' after 'oracle:'. You also appear to be missing an '@'? Try adding either/both of those and see if it works!
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 Tom Ryan
Appian Employee
over 7 years ago

If you are still seeing issues establishing a connection, please go ahead and create a Support ticket so we can assist you with this.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 rohann over 7 years ago

Thanks Guys Issue Sorted out...Changed the connection string
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel