PI OLEDB Enterprise

Showing 9 of 4924

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 2 years ago in AVEVA™ PI System Access (PSA) / PI OLEDB Enterprise 0 Declined

8 VOTE

PI OLEDB Enterprise access to AF Tables

Allow PI OLEDB Enterprise access to AF Tables. The current workaround is to have the table live on a SQL database and then link to them from AF.

MAMEDINA over 2 years ago in AVEVA™ PI System Access (PSA) / PI OLEDB Enterprise 2 Declined

7 VOTE

Allow PIOLEDB Enterprise to connect directly to a PI Data Archive

If PI OLEDB Provider is not going to be further developed, allow PI OLEDB Enterprise to connect directly to a PI Data Archive. There are times when an SQL type query is needed, but the data structure has not been mapped to an AF server yet.

Guest over 2 years ago in AVEVA™ PI System Access (PSA) / PI OLEDB Enterprise 5 Declined

6 VOTE

Expose Values with Duplicate Timestamps in Transpose Function

https://pisquare.osisoft.com/message/116957-pi-sql-commander-and-ssrs-how-to-retrieve-multiple-values-with-the-same-timstamp In the current implementation of the transpose archive in OLEDBEnt, a user is unable to retrieve data that may exist at t...

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

5 VOTE

Add 'Time Zone = Server' to PI OLEDB Enterprise

'Time Zone = Server' is available in PI OLEDB Provider, but has not been added to 'PI OLEDB Enterprise'. We have PI Data Archives in multiple time zones and require the ability to select the data in the server time zone.

Guest over 2 years ago in AVEVA™ PI System Access (PSA) / PI OLEDB Enterprise 2 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 2 years ago in AVEVA™ PI System Access (PSA) / PI OLEDB Enterprise 1 Declined

3 VOTE

Allow PI OLEDB Enterprise client to specify which member of a PI Data Archive Collective to connect to.

Enable functionality for PI OLEDB Enterprise that will allow the client to specify which member of a PI Data Archive collective they wish to connect to. This functionality has already been enabled for PSE and would like something similar for PI OL...

Guest over 2 years 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 2 years ago in AVEVA™ PI System Access (PSA) / PI OLEDB Enterprise 0 Declined

0 VOTE

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

No description provided

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

Please enter your email address

FILTER BY CATEGORY