Hi Everybody! I'm thinking about make a generic ingestor with Apache NiFi but I found some difficulties because of the DataBase Connection Pool controller. It doesn't accept flowfiles parameters for its properties, specially connection string, username and password (for security reasons, some sensitive parameter name instead password itself).
This is important because, as a generic ingestor, I might have hundreds of different connection strings, and I had a lot of problems when I tried to put 50 DBCP controllers in a Process Group. I wouldn't like to create a flow for each ingestion, but one flow for each database vendor. Does anyone have any suggestions on how I can achieve this? Would it be easy to create a parameterized DBCP controller? (That I could do it myself) Best regards. Eduardo Fontes Data Eng / System Analyst Sr.
