• PI OLEDB regarding

    PI OLEDB   We are still using PI-OLEDB-Enterprise_2012_.exe. With reference to upgrading Windows to 2012 in our company, was trying to download PI-OLEDB-Enterprise 2017 but it  shows as   ...
    last modified by Maitreyi
  • PI web vs PI JDBC

    Which PI technology is better to develop java client ? We heard that PI web API would be bit slower than PI JDBC. The solution should support on windows and  Linux operating systems. 
    last modified by dreampangari
  • how to use excel vba develope pi trend control

    In excel VBA, add an EXCELTRENDWIZARD Control. how to use this trend control to show some PI DATA curve? or In Excel VBA whitch control can I use to show some PI DATA trend?
    last modified by pigeon
  • How to get

    How to get PI JDBC Driver How to get PI SQL Data Access Server (OLE DB) Install Kit How to get PI OLEDB Provider
    last modified by wwoo111222
  • PI OLEDB Enterprise filter out elements with an element reference (link to an element in another place in the hierarchy)

    How does one filter out elements in Assets.Elements where one of the parents in it's path is a link in the elements hierarchy? PI Builder seems to remove these.  However, in Assets.ElementsHierarchy they look i...
    Marc Dunivan
    last modified by Marc Dunivan
  • PI OLEDB Enterprise: Query Asset Framework Library Tables

    Is it possible via PI OLEDB Enterprise to query the tables in PI Asset Framework directly without using a "Table Lookup" data reference attribute?
    Marc Dunivan
    last modified by Marc Dunivan
  • Does PI SQL Commander use AFSDK internally?Hello,

    Hello,   Woolgathering concepts for gathering PIDA, AF, and possibly non-AF SQL data within a external custom visualization tool.  As I am not on the development team, I wanted to use a PI tool that I could...
    last modified by James@Inva
  • Is there a PI SQL function to strip out the GUID and PointID from a PI Point data reference for query?

    I am using PI SQL to retrieve the element hierarchy configuration for some testing. The element attribute configString returns \\<PIServer>?<GUID>\<PITab>?<PIPointID>.   Result set ->...
    last modified by RickSmithJr
  • OleDb Enterprise not showing the correct record when queried by GUID

    Hi,   I am using PI OleDb to connect to a PI AF database.   If I query on the GUID shown on System Explorer I get the wrong object e.g.   select * from OPENQUERY([PI],'SELECT top 100 ev1.* FROM [ABB...
    last modified by pcassidy
  • Annotations made in PIVision available for reports

    With PIVision we are now able to add comments on eventframes. These comments are stored in "annotations" belonging to the EventFrame. These annotations also contain additional info, sucg as when and to whow notificati...
    last modified by HansBleijendaal
  • Product Release: PI OLEDB Enterprise 2016 R2

    PI OLEDB Enterprise 2016 R2 is released 2016-10-27    OSIsoft is pleased to announce the general availability of PI OLEDB Enterprise 2016 R2, a member of the PI Developer Technologies suite of products...
    last modified by tmcmanus
  • How to left outer join query using OleDB Enterprise?

    Hello all, I'm currently having trouble getting left outer joins working with PI, and OleDB. We're currently using PI Server 2012, and PI OleDB Enterprise 2016, and within the documentation I've read here: https://...
    last modified by rtrudeau
  • I have manullay deleted the endtime of an Eventframe as the analysis closed this event due to long run and end event did not occur while backfilling the data.

    I have manually deleted the endtime of an Eventframe as the analysis closed this event due to long run and end event did not occur while backfilling the data. Now actually the end event was true after a long time I di...
    last modified by Anithakash
  • How to insert Tag Value Using PI OLEDB ?

    I am using win32com.client.Dispatch in python to insert Tag value into PI Database.   Code : def insert(self,query):             if self.isConnected(): ...
    last modified by QasimGulzar
  • Cannot connect to PI Server

    Hello everyone,   I cannot connect to my PI Server.   I have 3 machines in one domain. On the first one I have PI Server, second coresight and on the third one I uses PI SQL Commander. My problem occurs ...
    last modified by dpilc
  • how to change retrieval mode with SQL in Archive Table to get previous compressed time value? I can´t use a time interval.   I´m using a PI OLEDB Provider.   Thanks.

    how to change retrieval mode with SQL in Archive..picomp2 Table to get previous compressed time value?   I can´t use a time interval.   I´m using a PI OLEDB Provider.   Thanks.
    last modified by emeneses
  • What's are some good ways to analyze event frame data?

    Hi PI Square. I'm working on a stats project trying to analyze some event frame data.  It's one of the first I've undertaken, and I was looking for some help!   Scope: 20'000+ event frames with 22 variable...
    last modified by kfong
  • PIOLEDB enterprise empty result

    Hello, I am preparing a report (in SSRS) extracting some data from PI via PIOLEDB Enterprise 2012 showing element path and an interpolated range over last 24h from DATAT area and have the following problem: When the...
    last modified by dpilc
  • PIOLEDB and time parameters

    I trying to use PIOLEDB combined with SSRS parameters to view 50+ "assets"   The expression I'm trying to use is TimeEQ('TAG1',ST,ET,"Running")/86400 similar to PI Time Filtered in datalink   in SSRS query...
    last modified by HenlodeWaal
  • Alternative Uses of OLEDB Enterprise

    First off: hello, world!   Okay, now to business...I'm working out a plan for a PI system where the end users like the idea of using PowerPivot to access cubed PI data from the OLEDB Enterprise platform, but wan...
    last modified by skermode