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:

MS Sql

  6. Select MS Sql for the database type.

  7. Configure your MS Sql settings:

  • Host
  • Port
  • Database name
  • Username
  • Password

         

     8. Click Test Connection. A confirmation message is displayed if the connection has been established with Hero_Flow.
         

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

MySQL

    6. Select MySQL for the database type.

    7. Configure your MySQL settings:

  • Host
  • Port
  • Database name
  • Username
  • Password

        

     8. Click Test Connection. A confirmation message is displayed if the connection has been established with Hero_Flow.
         

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

Oracle

     6. Select Oracle to connect to an Oracle database.

     7. Configure your Oracle settings:

  • Host
  • Port
  • SID
  • Username
  • Password

         

     8. Click Test Connection. A confirmation message is displayed if the connection has been established with Hero_Flow.
         

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

PostgreSQL

     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 confirmation message is displayed if the connection has been established with Hero_Flow.
         

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


Qubole

     6. Select Qubole to connect to an Qubole database.

     7. Configure your Qubole settings:

  • Connection string
  • Password

        

     8. Click Test connection. A confirmation message is displayed if the connection has been established with Hero_Flow.
         

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

Snowflake

     6. Select Snowflake to connect to a Snowflake database.

     7. Configure your Snowflake settings:

  • Snowflake account name
  • Select your platform (AWS or Azure)
  • Select the region for your platform.
  • Username
  • Password

         

   8. Click Test connection. A confirmation message is displayed if the connection has been established with Hero_Flow.
         

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