Nifi create a connection to MS SQL Server

[#1]

Hi,
I want to insert data to Ms. Sql's server from nifi flow.
Where can I find a sample or a guide?
Also, where have I must install sqljdbc-4.0.jar?

[#2]

You need to create a DBCPConnectionPool service and set the required connection properties. On DataBase driver location you can enter the folder where the jar files are located, this folder must be accesible by nifi service user and must be present in all of the NiFI nodes.

https://nifi.apache.org/docs/nifi-docs/components/org.apache.nifi/nifi-dbcp-service-nar/1.16.0/org.a...

Then you can use a SQL processor, such as PutSQL to insert data into the data base:
https://nifi.apache.org/docs/nifi-docs/components/org.apache.nifi/nifi-standard-nar/1.16.0/org.apach...

[#3]

Thank  you i am taking the below error  have you got an idea what causes this error

[#4 · Accepted solution]

The error says the Connection pool is not able to find configured driver classpath name into provided database client-jar driver. Please check and make sure configured driver classpath name is present on the provided jar file.