How to setup a OracleDB Connection | Community
Skip to main content
F
FilipeFreitas
Level 3
October 4, 2024
Solved

How to setup a OracleDB Connection

  • October 4, 2024
  • 2 replies
  • 1451 views

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/oracle

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 

This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.
Best answer by FilipeFreitas

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

2 replies

Anuhya-Y
Community Advisor
Anuhya-YCommunity Advisor
Community Advisor
October 7, 2024

@filipefreitas Have you whitelisted Adobe's IP address ?

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

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

    F
    FilipeFreitasAuthor
    Level 3
    October 7, 2024

    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

      F
      FilipeFreitasAuthorAccepted solution
      Level 3
      October 18, 2024

      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
        Community Advisor
        Anuhya-YCommunity Advisor
        Community Advisor
        October 21, 2024

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

          F
          FilipeFreitasAuthor
          Level 3
          October 22, 2024

          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 

            Terms & ConditionsAccessibility statement

            Loading footer...