Created 09-05-2018 12:35 AM
I am completely new to nifi. But as i found it is very interesting to learn.
I am trying to migrate the MongoDB Data into sql server using NIFI.
Is it possible.
If yes, please suggest me what are the steps that i need to follow.
Created 09-05-2018 01:27 AM
Yes, it's possible.
Use GetMongo processor to read the data from the mongo collection and Use PutDatabaseRecord processor to store the data into SQL server.
In PutDatabaseRecord processor Configure the RecordReader controller service to read the incoming Mongo data then the processor will store the data into SQL server.
Refer to this and this links for usage/Configuring of PutDatabaseRecord processor.
If the Answer helped to resolve your issue, Click on Accept button below to accept the answer, That would be great help to Community users to find solution quickly for these kind of issues.
Created 09-05-2018 04:17 AM
Created on 09-06-2018 08:00 PM - edited 08-18-2019 02:08 AM
Thanks for the reply @Shu.
I tried what you have suggested but i got struck.
I ll give you the screen shots of what i have done..
Please correct me where i was doing mistake.
I have mentioend
Record Reader -- avroreader
statement type - INSERT
Database connection pooling service - DBCPCONNECTIONPOOL
schema name - dbo
Table Name - Locations
Rest is as they are
And then i created upstream connections and started.
But i am authentication error which is something weird for me as the same user id and credentials i am using in other applications to get the data from sql also.
Can not create pooling connection factory (login failed for user pbiuser).
Can you please help me with this.
I have tried for every possibility with that userid and password.but it didnt worked.
My sql server, and nifi server both are in same machine.
Created 09-08-2018 02:10 PM
NiFi not able to create connection pool as it is failing to login with the username/password.
Please check is there any firewalll blocking and make sure all the connection details and db drivers are configured correctly.
Created on 09-11-2018 01:58 PM - edited 08-18-2019 02:08 AM
@Shu Im still having the same issue.
I checked the firewalls and they are off.
And i have downloded the jdbc drivers for sql and put it onto C:\Program Files\Java\jre1.8.0_171\lib\ext this directory
Driver Location:- E:/Software/sqljdbc_6.0/enu/jre8/sqljdbc42.jar
Im running my nifi onto production system.
And the sql server is SQL Server Enterprise Edition 2016 and Windows Server 2012 R2.
Please help me.
I have been struck here from last one week.