Open topic with navigation

# Create a Database Service

If you want to run an Apache NiFi cluster, you must set up a Database Service so that the following information can be shared between nodes in the cluster:

- State information for your NiFi Ingest connectors.
- Dependency information managed by a document registry service (for more information, see Index Documents in the Correct Sequence).

The database service uses standard ODBC and SQL, so you should be able to use any database server. Micro Focus recommends PostgreSQL and MySQL as these have been most fully tested.

To create a database service to communicate with external database

1. Ensure that your external database server is running and create a new, empty database.
2. Open the Apache NiFi user interface in your web browser.
3. Click a blank area of the canvas, to de-select all of the components on the canvas.

4. In the Operate Palette, click Configuration .

   The NiFi Flow Configuration dialog box opens.

5. Click the Controller Services tab.

6. Click Create a new controller service .

   The Add Controller Service dialog box opens.

7. In the Source list, click idol.nifi.

8. In the list, click DatabaseServiceImpl, and click ADD.

   The new service is added.

9. At the end of the row for the controller service, click Configure .

   The Configure Controller Service dialog box opens.

10. Click the Properties tab and set the following properties:

    Connection String | The connection string to use to connect to the external database through ODBC.

11. Click Apply.

    You are returned to the NiFi Flow Configuration dialog box. NiFi validates the connection string. If the connection string is valid, you are able to start the service. If not, NiFi displays a warning:

12. Enable the service. At the end of the row for the controller service, click Enable .

    The Enable Controller Service dialog box opens.

13. Click ENABLE and then click CLOSE.

14. Close the NiFi Flow Configuration dialog box.

    When you configure a NiFi Ingest connector, set the property Database Service to the name of the service you created in this procedure.

    When you configure a DocumentRegistryService, set the property Database Service to the name of the service you created in this procedure.

© Copyright 2018-2019 Micro Focus or one of its affiliates | Send documentation feedback Close Send documentation feedback To open the configured email client on this computer, open an email window. Otherwise, copy the information below to a web mail client, and send this email to swpdl.idoldocsfeedback@microfocus.com. We appreciate your feedback! Product: Topic Title: Help Topic: Feedback:

_FT_HTML5_bannerTitle.htm