nliyana | 2023-02-28 17:50:40 UTC | #1
Hi, I'd like to know if it's possible to access Stored Procedures in an external SQL database from Genesys cloud. The current IVR uses stored procedures for data retrieval. If we migrate to Gensys, do we need to create a service that support REST or can we use the existing Stored procedures?
Thanks in advance.
tim.smith | 2023-02-28 18:35:56 UTC | #2
Allowing a cloud service to execute a stored procedure in your database would require you to expose your database publicly on the internet, which is never something we would support. For this use case, you would build a middleware service that sits in your network's DMZ to expose a REST endpoint to the Genesys Cloud Architect Flow. A data action can then be used to send the request as a JSON payload to your middleware, which will then query your DB and return a JSON payload formatted for consumption by the data action. You can read more about data actions here: https://help.mypurecloud.com/articles/about-web-services-data-actions-integration/.
system | 2023-03-31 18:36:06 UTC | #3
This topic was automatically closed 31 days after the last reply. New replies are no longer allowed.
This post was migrated from the old Developer Forum.
ref: 18643