Relational Database Connection

    Describes all the information needed to connect to a relational database.

    Hop supports tens of relational databases out of the box. If your specific database doesn’t have built in support, you’ll probably still be able to connect with the Generic database connection.

    Check the list of databases for more details.

    Actions:

    Transforms:

    The options describe below are for the Generic database connection.

    The options for your selected database depend on the database vendor and/or engine.

    OptionDefaultDescription

    Supports the Boolean data type

    true

    Supports the Timestamp data type

    true

    Quote all identifiers in database

    Force all identifiers to lower case

    Force all identifiers to upper case

    Reserve case of reserved words?

    true

    The preferred schema name

    The SQL statements to run after connecting (; separated

    None