Installing and configuring a database for EFM
Learn how to install a database and configure it with your Edge Flow Manager (EFM) to manage, control, and monitor dataflows.
By default, Edge Flow Management is preconfigured with an embedded H2 database. But when setting up Edge Flow Management, you have the option to install and configure an external MySQL or PostgreSQL database to use with EFM.
The H2 database that is preconfigured in the default efm.properties file. The contents of the embedded H2 database are stored in a file on your local file system. The H2 database location is specified by he JDBC URL property: Edge Flow Management JDBC URL (efm.db.url) – jdbc:h2:./database/efm
If you plan to use the embedded H2 database, you can skip the steps for installing and configuring an external database. Alternatively, you can install an external MySQL or PostgreSQL database. To proceed with external database installation, review the following steps.
For a list of supported MySQL or PostgreSQL databases, see System requirements for EFM.
Installing MySQL
Learn how to install a MySQL external database to support Edge Flow Management (EFM). If you have already installed a PostgreSQL or an Oracle database, you can skip these steps, as only one of the databases is required.
Ensure that you have installed the JDK. For installation instructions, see Installing the JDK.
Once you have completed the MySQL installation, configure it for use with Edge Flow Manager.
Configuring MySQL
MySQL offers the option to use an externally located database that supports high availability. Learn how to set up a MySQL database for use with the Edge Flow Manager.
Ensure that you have installed a MySQL database. For instructions, see Installing MySQL.
When you have completed the Edge Flow Management database configuration, proceed to installing Cloudera Manager and your CDP Private Cloud Base cluster.
Installing PostgreSQL
Learn how to install a PostgreSQL external database to support Edge Flow Management (EFM). If you have already installed a MySQL or an Oracle database, you can skip these steps. Only one of the databases is required.
Ensure that you have installed the JDK. For installation instructions, see Installing the JDK.
When PostgreSQL is installed, configure the database for use with Edge Flow Management.
Configuring PostgreSQL
PostgreSQL offers the option to use an externally located database that supports high availability. Learn how to set up a MySQL database for use with the Edge Flow Manager.
Ensure that you have installed a PostgreSQL database. For instructions, see Installing PostgreSQL.
When you have completed the Edge Flow Management database configuration, proceed to installing Cloudera Manager and your CDP Private Cloud Base cluster.
Installing Oracle
Learn how to install an external Oracle database to support Edge Flow Management (EFM).
Follow the Oracle documentation to install the database. This step is required only if you do not have the Oracle database installed in your data center or environment. If you are using an existing Oracle database, you can skip this step. If you have already installed a PostgreSQL or a MySQL database, you can also skip these steps. Only one of the databases is required.
For a list of supported Oracle databases in Cloudera Edge Management, System requirements for EFM.
Once you have installed Oracle, configure the database for use with Edge Flow Management.
Configuring Oracle
Learn how to configure a Oracle database to integrate with Edge Flow Manager.
Oracle provides the option to use an externally located database that supports high availability.
You have installed an Oracle database. For details, see Installing Oracle.
When you have completed the Edge Flow Management database configuration, proceed to installing Cloudera Manager and your CDP Private Cloud Base cluster.