JDBC Sender OS Command
I want to know where the operating system command runs when used in jdbc sender adapter , In PI or in the database after executing the sql queries? I am wondering if i can use a Stored procedure through a script in database. Any help appreciated .And forgive me for my ignorance Thanks.
Raja Sekhar Reddy replied
, but the thing which is bothering me is in JDBC SENDER ADAPTER the option RUN OPERATING SYSTEM COMMAND is executed in the PI server or the JDBC server where PI is attacking to fetch the data
Executed on PI server not data base, Sedner Adapter pick sup the data based on your configuration(Data base tables),but script also picks up the data based on logic u writen in script. it can pull the data from FTP .