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.
Discussion posts and replies are publicly visible
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?
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.
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.
Thanks again for your valuable inputs Helzle. The main core thing here i think "How to fetch/store data via the API". Will explore the possibilities.
I'd also suggest reaching out to your database team to determine how they expect you to send data to them. Keep in mind that for this to work, someone on your Oracle team will need to set up one or more endpoints that will be available to you in Appian. Then, you can call that endpoint and send / receive the information that you need.
Once you have the endpoint available, I'd suggest looking at the documentation for creating integrations. Keep in mind that when you do this you are bypassing the typical data management lifecycle that uses data stores; instead you would use a CDT directly with your integration to perform the read / write.