Connect to an Oracle Database

  • 1
  • Question
  • Updated 1 week ago
  • Answered
I need to connect to a database in Oracle from Salesforce. And, it looks like it will need to be done over TCP. Is this possible using Skuid?
Photo of Ashwat

Ashwat

  • 768 Points 500 badge 2x thumb

Posted 2 years ago

  • 1
Photo of Bill McCullough

Bill McCullough, Champion

  • 13,602 Points 10k badge 2x thumb
atlantabadi,

You need to setup your Oracle DB with OData access.  Then you can connect via TCP using Skuid.

Thanks,

Bill
Photo of Amy Dewaal

Amy Dewaal, Official Rep

  • 8,320 Points 5k badge 2x thumb
You can also connect to Oracle through REST.

Thanks!
Photo of Ashwat

Ashwat

  • 768 Points 500 badge 2x thumb
Thank you Bill & Amy.

This is what I have from our Oracle team.

REDACTED =

  (DESCRIPTION =

    (ADDRESS = (PROTOCOL = TCP)(HOST = REDACTED.com)(PORT = REDACTED))

    (CONNECT_DATA =

      (SERVER = DEDICATED)

      (SERVICE_NAME = REDACTED)

    )

  )

How can I proceed?
Photo of SAMJOSEPH

SAMJOSEPH

  • 90 Points 75 badge 2x thumb
Thanks for sharing this information. It's useful. If you face any connection issue you may refer 192.168.100.1 IP Login Panel  guide. 
(Edited)