Create a JDBC Connection

A JDBC Connection is used to connect and get or set data from or to a MySQL database or PostgreSQL database in Hero_Flow.

Create a Connection to a JDBC in Hero_Flow

    1. Open Hero_Flow.

    2. Click Connections from the menu on the left.
        

   3. Click CREATE NEW CONNECTION.
        

   4. Give the Connection a name and select JDBC from the drop-down list for Connection type.
        

   5. The JDBC details screen pops up with fields that need to be configured.
       The first field is labeled Database type. There are two choices:

MySQL

 To acquire a new MySQL database, you can use a docker image and run the following command in your terminal:

docker run --name test-mysql -p 3306:3306 -e MYSQL_ROOT_PASSWORD=password -d mysql

     6. Select MySql for the database type.

     7. Configure your MySQL settings:

  • Host
  • Port
  • Database name
  • Username
  • Password

         

     8. Click TEST CONNECTION. A conformation message is displayed if the connection has been established with your Hero_Flow's.
         

     9. Click OK to finish saving the Connection in Hero_Flow.


PostgreSQL

To acquire a new PostgreSQL database, you can use a docker image and run the following command in your terminal:

docker run --name test-postgres -p 5432:5432 -e POSTGRES_PASSWORD=password postgres

     6. Select PostgreSQL to connect to a PostgreSQL database. 

     7. Configure your PostgreSQL settings:

  • Host
  • Port
  • Database name
  • Username
  • Password

         

     8. Click TEST CONNECTION. A conformation message is displayed if the connection has been established with your Hero_Flow's.
         

     9. Click OK to finish saving the Connection in Hero_Flow.