All geek questions in one place

How to add a database source to Kylo

I'd love to create a new Ingest data entry channel in Kylo to import data from an external database into Hive. In the second step of the filing wizard, a drop-down list for connecting the source database, but my database is not specified. How to add my database to this list?

+4
source share
1 answer

Kylo retrieves a list of database connections from Apache NiFi, looking for controller services like DBCPConnectionPool. It uses the database connection URL, the database driver class name, and the controller service database user properties to create its own database connection. The password comes from the Kylos application.properties file.

Kylo:

  • Apache NiFi .
  • jar JDBC Kylos. /opt/kylo/kylo -services/plugin/.
  • Kylos application.properties. /opt/kylo/kylo -services/conf/.
    • : nifi.service.<controller-service-name>.password
    • <controller-service-name> - , .
    • , MySQL Kylos: nifi.service.mysql.password
  • kylo-services : service kylo-services restart
+6

Source: https://habr.com/ru/post/1669177/

More articles:


All Articles