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 Platform_

    1. Open Hero Platform_.

    2. Open Integration from the navigation menu and select Outputs.


    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 the query timeout value. (Seconds)
    • Query statements that are not completed by the timeout value are canceled.
    • The value of "0" disables the query timeout feature.
  • 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.


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);


        Learn more about variable resolution.

    6) Click OK to finish saving the Output in Hero Platform_.