Hello, I am also trying same think i am trying to get data from another tool using invokeHttp process but where i need to pass access token and parameter i am not able to understand it if you have resolve it please help me.   Thank you Digambar ... View more

@vidanimegh ,i have changed referral to follow but still users not sync to Ranger also not able to find any error in the usersync.log. Please find below config parameters and request you to pleases suggest if anything needs to be correct.    ldapUrl: ldaps://ad.HWX.COM:636, ldapBindDn: CN=user1,OU=bda,DC=HWX,DC=COM, ldapBindPassword: ***** , ldapAuthenticationMechanism: simple, searchBase: dc=hadoop,dc=apache,dc=org, userSearchBase: [OU=bda,DC=HWX,DC=COM], userSearchScope: 2, userObjectClass: user, userSearchFilter: ((memberof=OU=bda,DC=HWX,DC=COM)(memberof=CN=hdpadmin,OU=bda,DC=HWX,DC=COM)), extendedUserSearchFilter: (&(objectclass=user)((memberof=OU=bda,DC=HWX,DC=COM)(memberof=CN=hdpadmin,OU=bda,DC=HWX,DC=COM))), userNameAttribute: sAMAccountName, userSearchAttributes: [sAMAccountName], userGroupNameAttributeSet: null, pagedResultsEnabled: true, pagedResultsSize: 500, groupSearchEnabled: true, groupSearchBase: [DC=HWX,DC=COM], groupSearchScope: 2, groupObjectClass: group, groupSearchFilter: *, extendedGroupSearchFilter: (&(objectclass=group)(*)(|(member={0})(member={1}))), extendedAllGroupsSearchFilter: (&(objectclass=group)(*)), groupMemberAttributeName: member, groupNameAttribute: cn, groupSearchAttributes: [member, cn], groupUserMapSyncEnabled: false, groupSearchFirstEnabled: false, userSearchEnabled: false, ldapReferral: follow  ... View more

Hello, I am begineer on this topic. I want to connect my dataflow to store data in postgresql and google found your topic in the forum. I am trying all the things you said and the service remains "Enabling". Could you explain exactly the steps to enable this communication. From my side: 1. Download postgresql-42.2.8.jar. 2. Move to C:\Program Files\nifi-1.9.2\lib 3. Restart Nifi. 4. Configure DBCPConnectionPool with the following parameters: URL: jdbc:postgresql://127.0.0.1:5432/nifi Diver Class: org/postgresql/Driver.class Driver Location: file:////C:/Program Files/nifi-1.9.2/lib/postgresql-42.2.8.jar   Is something wrong? Could you help me? The service remains "ENABLING"   Regards, ... View more

Thanks Adrian Oprea ... View more

Thanks Shu ... View more

Thanks Matt Clarke ... View more

Thanks Sonu Sahi ... View more

and please ensure that, there are no columns in salary ( if it is defined as Decimal/integer in Database) ... View more

Hello @Matt Burgess . I am using the CaptureChangesMysql processor to read the events data from mysql but it it failing with the connection error as "org.apache.nifi.reporting.initializationexception can't load database driver" screenshots are attached for the reference . Mysql Driver path: file:////Users/kiran/Downloads/mysql/mysql-connector-java-8.0.17.jar Environment : Aapache nifi :1.7.0 Mysql 8.0.17 OS : MacOS 10.14.4 ... View more

Try three slashes in the Database Driver Jar Url property: file:///post/postgresql-42.1.1.jar ... View more