Create a JDBC Output


To create a JBDC Output, you must first create a JDBC Connection

JDBC Connections available:

  • MS Sql
  • MySql
  • Oracle
  • PostgreSQL
  • Qubole
  • Snowflake

Create a Connection to a JDBC in Hero_Flow

    1. Open Hero_Flow.

    2. Click Outputs from the menu on the left.

        

    3) Click Create New Output.

        

    4) Give the Output a name and select your JDBC Connection. 

        

5) Complete the JDBC Output configuration fields:

  • BatchMode
    • Yes: Recommend for most cases.
      • Enter a batch size for the number of queries that execute in one transaction. 

        The batch size value depends on the content of the query being sent. Large text OR binary fields require a smaller batch size that will not step over data size limits. For smaller payloads, such as numbers or small text fields, a larger batch size is more efficient.

    • No: Execute one query for each tuple.
  • Enter an SQL query used for inserting, updating, or removing data.
  • From the field mapping table:
    • Confirm or change column names.
    • Confirm or change column data types.
    • Remove or confirm the arrangement of columns.
  • Click OK to save the Output.

Preparation

A database table (MySQL/PostgreSQL) needs to be created in your database where the data is to be written.

Below is an example of how to create a table in MySQL using a next script:

create table test_url_download ( name varchar(255), data blob);