• oledb download

    i want to download the pi sql data access to fetch the data from sql.
    last modified by LIUDAWEI
  • All. How do I make a connection with JMP and PI using PI OLEDB? I would want to know the steps.

    I want to create a connection using PI OLEDB with JMP and PI data. How do I achieve that?
    last modified by Santachow
  • I am trying in MS-SQL to write: SELECT [tag],[time],[value],[status] ,[timestep]  FROM [PI].[piarchive]..[piinterp2] Where tag = 'sinusoid' and [time] between '*-1h' and '*'and [timestep] = '30m' GO

    I am trying in MS-SQL to write:   SELECT [tag],[time],[value],[status] ,[timestep]   FROM [PI].[piarchive]..[piinterp2] Where tag = 'sinusoid' and [time] between '*-1h' and '*'and [timestep] = '3...
    last modified by BjaNyg
  • query to contextualize EFs AND archived attribute values

    Hello, I'm new to the SQL family of products and was hoping someone could help me create a query that will: 1. gather EF data: get start and end times, durations, parent EFs and any EF attributes + values (we have a...
    last modified by narburgh
  • Link to download PI JDBC Driver setup kit

    Hello, do you know where I can download PI JDBC Driver setup kit?  The OSIsoft Tech Support Downloads page (https://techsupport.osisoft.com/Downloads/All-Downloads/) does not seem to have it.  Thank you.
    last modified by MINHTRAM
  • We have installed RQTP Data Engine and I can query through SQL Client to get values from AF database.  How do I use PI SQL Client to query tags that are not in the AF but are solely in the Data Archive?

    So we are new to PI.  We have installed RQTP Data Engine and I can query through SQL Client to get values from AF database.  How do I use PI SQL Client to query tags that are not in the AF but are solely in ...
    last modified by SharZ
  • PI JDBC connection error

    Hi Everyone,   We have been using PI JDBC to retrieve data from PI AF via DAS into R. Everything is working great until one of the function's table in an AF database becomes invalid (e.g. due to amendment/remova...
    last modified by kuehcj
  • Execution timed out with piinterp table

    Hi,        I always report errors when inquiring with ODBC  "select * FROM piarchive..piinterp WHERE tag='xxx' and time between '2019-09-06' and  '2019-09-09' "  Or&...
    last modified by sharon.meng
  • PI SQL Commander Query

    To get all milliseconds interval data from query. For eg: I want to fetch data of time '2018-07-26 07:15:00.543' But when i try to execute query :   SELECT tag, time, DIGSTRING(CAST(status AS Int32)) digsta...
    last modified by Bhavesh_22
  • Extract data from PI System Management Tools(Archive Editor)

    Hi Everyone,   I really need help! I am very new to this and spent very long time with no success yet. I need to retrieve data from the archive editor in the PI System Management Tools. I want to be able to upd...
    last modified by ziadelghoul
  • PI OLEDB Select question

    Hello,  I'm trying to do what Ithought was a simple query but I've already spent way to much time trying to get it to work. I feel like I'm just running into a syntax problem and am hoping to get some help with ...
    last modified by DaveThompson
  • Data INSERT not persisting after restart.

    We have a day and a half gap for 2800 tags. I was asked to read the data from PHD and write to PI. I am using a Python script to get the data for each tag (iterate through list of tags) then write it to PI. The data w...
    last modified by Etienne
  • How to get previous value for AF attributes?

    Hi, I need help to find a way to efficiently get the last value of a two AF attributes (PI tags) before a given point in time, i.e. I want to get the PrevVal for a set of AF Attributes   The constraints are I...
    last modified by wilsona
  • PI Data link Calculated Max Value Ignore Dates

    Hi I am using PI Datalink with “Calculated Data in max mode” and have it set up as follows    Data Item = ‘Tag name’ Start Time = today End time = -1year Mode = Max   ...
    last modified by AndrewCamuso
  • where can i download software and interfaces from? where is the download area of the customer portal? please make it easier to find

    Im not sure if its because osisoft have changed their landing page, but i cannot find the customer portal log in url . Can someone please post a link thank you
    last modified by ctgarvey2
  • PI JDBC Driver Java compatibility

    Hi,  Do there exist some kind of overview on which versions of PI JDBC Driver is compatible with which version of Java (Java 8, Java 11 etc)?  Thanks, Erik  pi jdbc driver java
    last modified by hodneeri
  • How to extract 1-minute average once per hour?

    Hello,   I am having trouble trying to figure out how to get one-minute average values once an hour. Specifically I'm hoping to extract a one minute average from 18 after the top of the hour each hour (at 09:18, ...
    last modified by rfmii
  • How to consume Event Frames from AF DB using PI SQL Commander?

    Hi PI Friends.   I have a question. How I can to generate a SQL query in order to consume the data of event frames directly from AF database? I need event frames name, startime, endtime, duration, and the rest o...
    last modified by ccastro

    Hello Everyone!   I need to install PI OLEDB ENTERPRISE 2017 R2, I have search in product list but I couldn't see install KIT separately, also this is not included in AF service 2017 R2 update, please check...
    last modified by AKASH MISAL
  • I need to copy all values from one tag to another backup tag. What is the best way ?

    I'm using pi sql commander but I'm not sure if this is the best solution. But I'm having timeout issues because of the large amount of records Here is an sample query I'm using in Pi SQL Commander. It is an insert wi...
    last modified by Dante_QP