question Re: Nifi create a connection to MS SQL Server in Support Questions

Nifi create a connection to MS SQL Server

vkotsas — Wed, 08 Jun 2022 12:50:47 GMT

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?

Re: Nifi create a connection to MS SQL Server

gtorres — Wed, 08 Jun 2022 18:29:05 GMT

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.apache.nifi.dbcp.DBCPConnectionPool/index.html

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.apache.nifi.processors.standard.PutSQL/

Re: Nifi create a connection to MS SQL Server

vkotsas — Thu, 09 Jun 2022 11:09:41 GMT

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

Re: Nifi create a connection to MS SQL Server

ckumar — Thu, 09 Jun 2022 13:21:33 GMT

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.