AVEVA™ PI System Access (PSA)

Showing 94

Use Escape Sequences with ODBC driver

ODBC driver should support the use of Escape Sequences such as {ts}

Alan Izar over 1 year ago in AVEVA™ PI System Access (PSA) / PI ODBC Driver 0 Declined

Specify Negative Time Offsets in SQL Commander

Customer would like to write a query to return a time column with a negative offset in the PI OLEDB Provider such as: SELECT time, (time - 1d) as datekey FROM piarchive]..[picomp2] WHERE tag='sinusoid' This query works SELECT time, (time + 1d) ...

Guest over 1 year ago in AVEVA™ PI System Access (PSA) / PI OLEDB Driver 0 Declined

3 VOTE

structured annotations oledb

Have PI OLEDB work with structured annotations.Hopefully at the very least with String Type annotations.

Guest over 1 year ago in AVEVA™ PI System Access (PSA) / PI OLEDB Driver 1 Declined

2 VOTE

Option to verify PI Data Archive connection during PI SDK installation

During PI SDK installation, there is currently no option to verify the connection to the PI Data Archive. This can lead to complications if, for example, PI Interface Configuration Utility (which includes PI SDK) is the first piece of PI software ...

Guest over 1 year ago in AVEVA™ PI System Access (PSA) / General 1 Declined

1 VOTE

PI ODBC driver for linus

There is a pi JDBC driver for linux, but not an ODBC driver. This means that tools built around ODBC do not fully exploit the tools functionality. For example, RStudio has great database navigation tools that require ODBC.

Guest over 1 year ago in AVEVA™ PI System Access (PSA) / PI ODBC Driver 0 Declined

2 VOTE

Don't install SQL Commander Lite with OLEDB Drivers Automatically

We did install the SQL Client software on our SQL server, but there was no option to exclude the SQL Commander Lite. So, we had to turn around and uninstall SQL Commander Lite. I'd just like to suggest for future install packages that there be an ...

Guest over 1 year ago in AVEVA™ PI System Access (PSA) / PI OLEDB Driver 0 Declined

0 VOTE

Increase the default size of 4000 characters of the security descriptor column

No description provided

Guest over 1 year ago in AVEVA™ PI System Access (PSA) / PI OLEDB Enterprise 0 Declined

4 VOTE

Add in the Element Hierarchy table information to determine the primary reference of a copied reference element

When an element is copied as reference (parent-child) elsewhere in the tree it then has multiple parents. One of it is the primary parent. This information needs to be added to the hierarchy tables.

Guest over 1 year ago in AVEVA™ PI System Access (PSA) / PI OLEDB Enterprise 1 Declined

20 VOTE

Add DATEADD and DATEDIFF functions to PI SQL Commander

When any time related functions need to be performed against timestamp columns in PI SQL Commander, one needs to utilize a significant amount of conversions to make this work. For example, if one needs to round timestamps to the nearest minute or ...

Guest over 1 year ago in AVEVA™ PI System Access (PSA) / PI OLEDB Enterprise 0 Declined

1 VOTE

Automatically update Transpose Function in SQL Commander when referenced Element Template name is updated

In PI SQL Commander, users can create Transpose Functions that are linked to Element Templates in AF. When the referenced Element Template is renamed in PI System Explorer, the Transpose Function in PI SQL Commander is no longer able to find the E...

Guest over 1 year ago in AVEVA™ PI System Access (PSA) / PI OLEDB Enterprise 0 Declined

Please enter your email address

FILTER BY CATEGORY