After adding a new datasource from the Datasources view, I cannot use it with the Data Ingestion templatem as the password is not taken into consideration.
Not sure if it's an issue in fact with the NIFI DBCPConnectionPool, as I tested with one added directly and it cannot be used in Kylo GetTableData Processor, without setting manually the password in the properties file.
I needed to manually add the password entry nifi.service.test-mariadb.password=$PASSWORD in /opt/kylo/kylo-services/conf/application.properties and to restart kylo-services, which is not mentioned anywhere
The system will now first look for the values in the properties file. If no match is found it will lookup any matching user defined datasource and get those properties.
Thanks for the fast fix. Can you tell me if there are any plans on exporting/importing the datasource? I don't find any options in the UI or Rest API