Skip to main content
R
ravip0005
November 26, 2021
Question

How do we do CRUD Operations on Oracle Database Via API Calls.

  • November 26, 2021
  • 5 replies
  • 0 views

Due to security reasons my Organization does not allow to do CRUD operations on Oracle Database directly. Iam allowed to do via API Call. Iam not sure how do i perform CRUD operation via API to the Database. Request you to suggest your thoughts or please share me the links by any chance if you have. Thanks in advance.

    5 replies

    stefanhelzle0001
    stefanhelzle0001
    Brainy
    November 26, 2021

    This is a very broad question. Is the API available? Is this SOAP or REST? Do you have credentials? Did you already try to connect?

    R
    ravip0005Author
    November 26, 2021

    Thanks Helzle for your quick response. At present i build the interface . Now i need to build API which should able to perform CRUD operations on Database. I have credentials. I stuck at this point. How do i build API which should perform CRUD operations on Database? What details we need from database end? In normal practice we develop interface --> CDT --> DataStore --> Store/retrieve to/from Database. The current approach via API is new to me.

    stefanhelzle0001
    stefanhelzle0001
    Brainy
    November 26, 2021

    OK. I am doing that already for a while. First, set up the "Connected System", base URL and credentials. Do you have an OpenAPI/Swagger file? Use that if possible.

    Next set up an integration to investigate how to fetch data and learn the details of the API.

    Terms & ConditionsAccessibility statement