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

How can we connect to PI Achieve database with Python(step by Step procedure).

Community User

PI server is in VM -A

PI AF server and PI SQL DAS server is in VM-B

and Python is installed in VM-C

 

all three VM's are in Same domain.

I am able to ping VM-B form VM-C

I want data of PI AF( tags , its history) , in Python installed in VM-C.

 

How can we do that.

 

Please suggest possible steps.

Parents
  • 0

    Hi (Missing Content)​ ,

    Depending on your PI SQL DAS flavor, you'll need a different driver on your Python (VM-C) end.

    If you have RTQP(recommended), then use PI SQL Client (ODBC|OLEDB|JDBC)

    If you have OLEDB, then use PI ODBC or PI JDBC Driver.

    A sample connection string can be found in the user guide. I'll copy one for PISQLClient-ODBC:

    ConnString = 'Driver={PI SQL Client}; AF Server=myAfServer; AF Database=myAfDatabase; Integrated Security=SSPI;'

     

     

     

Reply
  • 0

    Hi (Missing Content)​ ,

    Depending on your PI SQL DAS flavor, you'll need a different driver on your Python (VM-C) end.

    If you have RTQP(recommended), then use PI SQL Client (ODBC|OLEDB|JDBC)

    If you have OLEDB, then use PI ODBC or PI JDBC Driver.

    A sample connection string can be found in the user guide. I'll copy one for PISQLClient-ODBC:

    ConnString = 'Driver={PI SQL Client}; AF Server=myAfServer; AF Database=myAfDatabase; Integrated Security=SSPI;'

     

     

     

Children
No Data