• State Not Answered
  • Replies 4 replies
  • Subscribers 3 subscribers
  • Views 211 views
  • Users 0 members are here
Options
Related

How do I automate saving query result to .csv file in PI SQL Commander Lite?

Kelvino

I have a Product Batch Event Frame configured and running in PI AF. Also, I am able to successfully query for the results in PI SQL Commander Lite, but I need to automatically run the Query in PI SQL Commander Lite and save the result of the queries in .csv format at 11:59:59 PM on daily basis.

Parents
  • 0

    Hi ​,

    PI SQL Commander Lite is an utility provided with PI SQL Family products to test queries and connections. It does not have any scheduling capability or autonomy to run what at when. I'd suggest you to automate the task using a PowerShell script that uses PI SQL Client OLEDB or any of the variant drivers. One can also use a linked server and SQL Agent jobs to schedule a similar repeated tasks. More enterprise-wide approach may include using the PI Integrator for Business Analytics.

Reply
  • 0

    Hi ​,

    PI SQL Commander Lite is an utility provided with PI SQL Family products to test queries and connections. It does not have any scheduling capability or autonomy to run what at when. I'd suggest you to automate the task using a PowerShell script that uses PI SQL Client OLEDB or any of the variant drivers. One can also use a linked server and SQL Agent jobs to schedule a similar repeated tasks. More enterprise-wide approach may include using the PI Integrator for Business Analytics.

Children