We are working on the best option for connecting K2 Cloud to an premise SQL server or potentially Azure SQL server . At a high-level, we are designing a process for the client that will engage an OCR reader to extract data from an invoice then a bot verifies the information on the invoice is correct and approves and pays invoice if correct. If it is not correct, the bot will toss an exception to K2 with data from the invoice along with a pdf copy for a manager to update information or approve the invoice. We are now looking to leverage an intermediary SQL database where UiPath can enter the data for the exception and then K2 can read the details from there for the manager to update or approve.
We need K2 assistance with determining the best approach for connectivity to the intermediary SQL database. Below are my thoughts/questions on our options for connecting K2.
On-premise SQL connectivity options:
If we were to decide on any of the three options besides SDA, how does the data get transferred to and from K2? Is there any API option or secure data transfer to help protect data in flight?
Azure SQL connectivity options:
How would the communication work between client and K2?
Bottom line, we need a secure method of connecting and transferring data from K2 Cloud to the client environment
Please have a look into the following.
How K2 Cloud Secure Data Access Works: https://help.k2.com/kb002739,
Download a PDF Document here about on “K2 Cloud On-Prem Data Connections”: https://www.k2.com/k2-cloud-on-prem-data-connection,
Connecting to On-Premises Data from K2 Cloud: https://help.k2.com/kb002939,
Overview, Installation, and Configuration of K2 Cloud Secure Data Access: https://help.k2.com/kb002738.
“Securing cloud to cloud communications in K2 Cloud”: https://community.k2.com/t5/K2-Cloud/Securing-cloud-to-cloud-communications-in-K2-Cloud/td-p/108837,
“K2 Connect to an Azure sql database and one table only”: https://community.k2.com/t5/K2-Cloud/K2-Connect-to-an-Azure-sql-database-and-one-table-only/td-p/111....
For the best possible recommendations & expert advice regarding this, I suggest you reach out to our Remote Services team as they are best equipped for these types of requests.
You can simply log a remote services ticket here: https://portal.k2.com/ticket/rsrequest