Hi Community!
I am a fresh Adobe Journey Optimizer user who is trying to add Oracle DB as a source connection, and failing to do so. I was wondering if someone would be able to help me out with it.
First of all, I am following this docummentation:
https://experienceleague.adobe.com/en/docs/experience-platform/sources/ui-tutorials/create/databases...
I am trying to use my account parameters, as per in its tsnames.ora file:
OCI =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = myhost.com)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = xxx_xxxxxx)
)
Which would make my connection string looks like:
Host=myhost.com;Port=1521;Sid=xxx_xxxxxx;User Id=username;Password=password
Note that I've tried using "User Id" (with space, as per in the docummentation), UserId (with no space); I've also tried keeping/removed the curly braces placeholder. Nothing seems to be working to me, and at this point I don't know what I am doing wrong.
Any help would be highly appreciated.
All the best!
Filipe Freitas