Question

K2 Cloud to SQL Connection

  • 14 November 2019
  • 3 replies
  • 329 views

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:

  • SDA – additional license fee; we would like to avoid this option if possible
  • Site to Site VPN
  • Opening Network Firewall Ports
  • Placing Systems in a DMZ

 

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:

  • Create an Azure SQL Database

 

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


3 replies

Good day  @Jimmy11 

 

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/111006.

 

Best,

Sunrise

 

Hi @Jimmy11


 


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


 


-Sello

Below is the options you have.

1) Host the SQL db in Azure.
2) Site to site VPN (Additional costs)
3) SDA (Additional costs)

IMO Hosting the db in Azure is best and has many advantages with regards to eliminating Latency, possible network connectivity issues etc.

HTH
Vernon

Reply