Data source passwords should be passed securely to Spark apps running in NiFi:
Virtual catalog app
Data transformation app
This should be either a secure property on the ExecuteSparkJob (or another) processor or a controller service under the feed's process group.
Create the necessary Kylo services API to execute the dataset job and make the connection