You are developing the PDI solution for a customer. The customer requires that a set of SQL statements are executed on each connection to the database.
I'm not sure about the other options, but using the Advanced section in the Database Connection window to enter the SQL statements seems a bit clunky. C looks like the cleanest solution.
Option C seems like the way to go. Passing the SQL statements as a parameter in the Database Connection window's Options section is a pretty straightforward approach.
Herschel
1 days agoReita
3 days agoLudivina
8 days agoAfton
10 days agoSharee
11 days agoHerschel
15 days ago