Connect to an Oracle Database

  • 1
  • Question
  • Updated 1 year 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 1 year ago

  • 1
Photo of Bill McCullough

Bill McCullough, Champion

  • 12,436 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,200 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?