Skip to main content
budati
budati
Silver ⭐️⭐️⭐️
September 17, 2019
Solved

NIFI - SQL Server Lookup

Hi,

 

I am in need of SQL Server lookup, found this library https://github.com/mrcsparker/nifi-sqllookup-services-bundle    but there are no good examples especially when dealing with incoming CSV text file.  Appreciate if anybody can point me to an article or sample workflow that does something similar.

 

Thanks in advance

Shu_ashu
Shu_ashuAnswer
Gold ⭐️⭐️⭐️
September 19, 2019

@budati 

i don't think there is a way to combine all 3 processors into one.

 

We still need to use ExecuteSQL -> ConvertAvroToJson -> EvaluateJsonPath to extract the values from the flowfile.

 

If the answer was helpful to resolve your issue, Accept the answer to close the thread 🙂

View in thread

3 replies

Shu_ashu
Shu_ashu
Gold ⭐️⭐️⭐️
September 18, 2019

@budati 

Did you tried using NiFi DBCPConnectionLookup service and we can make Dynamic lookup from RDBMS.

-

Please refer to this link for more details regards to LookupService.

Translate
budati
budatiAuthor
Silver ⭐️⭐️⭐️
September 18, 2019

@Shu_ashu  : Thank you so much for the link, it covers part of my need.

The other thing is to assign the lookup value to attribute so I think the solution is 

ExecuteSQL -> ConvertAvroToJson -> EvaluateJsonPath

 

can we do it in one step instead of 3 like above?  All I am pulling is one field from the database table.

 

Query: select id from table A

 

 

Translate
Shu_ashu
Shu_ashuAnswer
Gold ⭐️⭐️⭐️
September 19, 2019

@budati 

i don't think there is a way to combine all 3 processors into one.

 

We still need to use ExecuteSQL -> ConvertAvroToJson -> EvaluateJsonPath to extract the values from the flowfile.

 

If the answer was helpful to resolve your issue, Accept the answer to close the thread 🙂

Translate
    Terms & ConditionsAccessibility statement