Create a JDBC Input

JDBC Connections available:

  • DB2
  • MS Sql
  • MySQL
  • Oracle
  • PostgreSQL
  • Qubole
  • Redshift
  • Snowflake

Create an Input for JDBC in Hero Platform_

  1. Open Hero Platform_.
  2. Open Integration from the navigation menu and select Inputs.
  3. Click Create New Input.

  4. Enter a name for the JDBC Input and select an JDBC Connection from the drop-down list.
  5. Configure the JDBC Input data.

    • Enter a SQL query to pull data.

      • Placeholders
        • ${partition} 
        • ${checkpoint} 

          Example query:

          select * from <field name> where {checkpoint} and {partition}

          Partition and checkpoint placeholders are not supported  when the query has more than one table.

      The {partition} command does not support SQL aliases as part of the select statement. The Select statement can create an alias for ease of reference in the rest of the SQL query, but use actual table/column names for the elements being selected when using {partition}.

    • Select a field from the drop-down menu if partitioning a column input is required.
    • Enter a numerical value for the partition size.
    • Select a field from the drop-down menu if checkpointing a column input is required.
    • Click the Refresh icon to display field mapping for the Input
    • 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.