insert data using connector sql server

Q&A
1

hi, 

how i can insert data to my database using connector sql server ?

thanks

2

Hi,

There are 2 kinds of Databases connectors, the ones using a JDBC connection and the one using a Datasource connection (The datasource must be configured at server level).

In order to use them, you’ll need to add the corresponding vendor specific JDBC driver in the process dependencies (eg: sqlserver driver).

Then you can configure a connector on an Activity or a Process and write an SQL query to execute.

HTH
Romain

3

Hi, 

Can you please confirm to me if is it the correct SQL query to insert data enter by user to my database?

INSERT INTO database.[dbo].[USER]

(Mail,Password)

VALUES(?,?)

 

Thanks