How to setup a OracleDB Connection

[FilipeFreitas]

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 

[Anuhya-Y]

@FilipeFreitas Have you whitelisted Adobe's IP address ?

https://experienceleague.adobe.com/en/docs/experience-platform/sources/connectors/databases/oracle#i... 

https://experienceleague.adobe.com/en/docs/experience-platform/sources/ip-address-allow-list

[FilipeFreitas]

Hi Anuhya-Y!

The IP whitelisting is something I missed. I will have a talk to the IT team to set it up accordingly. Once this is sorted out internally, I will confirm it here, so it may help the Community in the future.

I appreciate your help and prompt response. Thank you very much indeed.

best!

Filipe

[FilipeFreitas · Accepted solution]

Hi Community!

Just to share with all of you what the problem was: after talking with the IT Team, it was brought to my attention that the Oracle Database our organisation uses is setup not to connect to third-party application; therefore, the string connection would never work. We will need to find out alternatives internally.

Best!

Filipe Freitas

[Anuhya-Y]

@FilipeFreitas 

Thanks for sharing the update. I've typically seen these restrictions, especially with clients in the finance domain. Could you share the domain of the client where you're experiencing this restriction, if possible?

As an alternative solution, export bulk data to SFTP or cloud storage solutions and then import it into AEP for batch communications. For real-time use cases, consider using middleware to bring in small chunks of data incrementally to AEP.

[FilipeFreitas]

Hi, Anuhya-Y!

Sure! We are in the educational services industry. Our use cases are primarily related to students academic progress, student academic services, and student payments.

We talked to our Adobe technical account manager, who helped us out in finding alternatives, which ended up following the same approach you suggested here: we are likely to use a S3 connection, or data lading zone feature for now. This sould address our need.

I appreciate your support!

Best,

Filipe C. Freitas 

[Sukrity_Wadhwa]

Thanks a lot @FilipeFreitas for sharing the update with the Community. It's immensely helpful!