SQL Connection

The SQL Connection Advanced action creates a database connection.

Parameters

• connectionName: The name of the connection to open.
• connectionURL: The JDBC connection URL (jdbc:mysql://localhost:3306/).
• connection.user (optional): The user name to connect the database.
• connection.password (optional): The password of the user.
• connection.<propertyName> (optional): Any property that can be used to customize your connection.

Examples

An example of creating a connection to a MySQL database:

• connectionURL: jdbc:mysql://host:3306/mysql
• connection.user: my_user_name
• connection.password: my_password

An example of creating a connection to a DB2 database:

• connectionURL: jdbc:db2://host:50000/db
• connection.user: my_user_name
• connection.password: my_password
• driverClassName: com.ibm.db2.jcc.DB2Driver