Hi Team
Service now only support connect oracle by sid, not support by oracle service name, could anyone know how to connect oracle with oracle service name, not oracle sid ?
Hi @kfck ,
Looking at the other fields on the data source table there is another field not displayed called "Connection Url".
This field is populated with the url based on the data entered in the other fields; albeit in the SID style connection.
If that field is added to the display we can see that it is not locked down and can be changed.
You could try changing that to a servcie name style connection and saving. I haven't tested as I don't have an Oracle database to connect to. But I have seen this technique used on a different database.
EDIT:
If it works, consider modifying or cloning the Business Rule that sets the Connection URL field, "Build Connection URL".
It points to a Script Include that builds the url.
Script include
