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 Output 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. 

         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 field names.
    • Confirm or change field data types.
    • Remove or confirm the arrangement of fields.
  • 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);

        

    6) Click OK to finish saving the Output in Hero_Flow.