Skip to main content

Use the start and stop events. These events allow you to execute queries outside of a regular data flow and are not for processing records. On the event type (either start or stop), choose "JDBC Query". An extra tab will appear in the properties pane that allows you to define the query, the connection properties and driver (if necessary).

 

If you need to execute more than two queries, you can add a Dev Data Generator origin, check the "Produce Events" checkbox, and add a JDBC Executor off of the event flow of the origin.

Hi ​@Sami,

 

Thanks for this! One question though, we want to use a parameterized connection for our pipeline with Start and Stop Events using JDBC query. However, it does not allow us to use a parameterized value and unable to click the “Use parameter” button:

Any ideas how we can use a parameterized connection?


Reply