• State Not Answered
  • Replies 4 replies
  • Subscribers 3 subscribers
  • Views 209 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.

  • 0 in reply to Community User

    Hi (Missing Content)​ , still on this. In this case, I do not have PI SQL Client OLEDB, but I have PI OLEDB Enterprise available. Could you please let me know how to now test on PowerShell if it can use the PI OLEDB Enterprise that is on my machine? I can not find any resource that is related to using PowerShell with PI OLEDB Enterprise.

Reply Children
No Data