Connecting to external database

  • 12 February 2017
  • 5 replies
  • 31 views

Badge +5

Hi Guys,

 

We have a system in place where we store details of our employees in an external server ( in sql server data base).

I got to know that nintex has connectors for this. how can we configure it ? and  What is required form our side to get started ?


5 replies

Userlevel 6
Badge +16

You can use the action named "Execute SQL" . Take a look at >>> Execute SQL 

Badge +6

Hi Kannan,

            You can Query from the SQL by using EXECUTE SQL WF Action of Nintex. Execute SQL  

Have a look in this too...    

Regards 

Bashya Rajan A

Badge +5

Thanks Rajan,

What if we need to connect to an external database using web services ? 

Badge +11

In that case you use "Call HTTP Web Service" action: http://help.nintex.com/en-US/O365/O365WorkFlow/WorkflowActions-STD/CallHTTPWebService.htm

Badge +4

Hi Rinu


 


I have the exact scenario. On premise sharepoint 2013 has execute SQL action and Sharepoint online needs the Database internet accessible. What configurations need to be done. Can you guide here?

Reply