Search code examples
kylo

How to change Hive Database to Oracle Database as Primary Database in Kylo?

I'm kylo platform for my tool. I need the Oracle database instead of the hive database on the kylo platform.

Solution

  • Yes, you can use Kylo to land data in Oracle as the destination database instead of Hive.The (data ingest template) that comes with Kylo uses Hive by default. Some features in Kylo also depend on Hive (e.g. Validation, Profiling).

    However, you can create your custom template in NiFi that uses Oracle as the destination database. NiFi has some processors that can help you design your template. One example is PutSQL processor. All available processors are documented here.

    The steps to use this flow via Kylo are:

    1. Create the template in NiFi and test that it works.
    2. Register the template in Kylo and configure properties that should be exposed to a feed creator.
    3. Create a feed out of the registered template and provide feed-specific values for the properties exposed in step 2.
    4. Schedule the feed to run on a cron or time-based schedule. Kylo will show feed executions via the Operations Manager UI.

    Kylo has some useful video tutorials that can help you with configuring the above steps (template registration, feed creation, feed monitoring).