• Compare 2 DB for differences

    Is there a method to compare 2 DBs for the differences. For example, let's say this databases are the same but there may be new elements. How I can compare these two to find the elements that are one database that are...
    SantiagoVeraTorres
    last modified by SantiagoVeraTorres
  • PI JDBC query: get archived values for a time frame, outside bounds

    Hello, I'm using PI SDL DAS with OLEDB Ent 2019 (we don't have AF 2018+ so I am unable to use RTQP as this time). What I'm trying to do is query archived values of attributes of a unit during the duration of an EF.&#...
    narburgh
    last modified by narburgh
  • 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. 
    dreampangari
    last modified by dreampangari
  • PI Web API 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. 
    dreampangari
    last modified by dreampangari
  • jdbc

    Hi,   I am using 2018 JDBC Driver and unable to connect to DAS Server. I am using this url   jdbc:pioledb://<server name>/Data Source=<data src name>;Integrated Security=SSPI;   DAS is 20...
    mgoel
    last modified by mgoel
  • 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
    wwoo111222
    last modified by wwoo111222
  • JDBC setup file not available

    I am new to PI server. I have to design a system to fetch data from an existing Pi server. I have the required user credentials and query to fetch the data. My program is written in java. I read about the JDBC driver ...
    suhridelectromed
    last modified by suhridelectromed
  • How to get the next value in picomp2 using PI SQL family

    Hello,   I'm using picomp2 to search for times when a batch tag equals a certain batch number to get an appropriate estimate of when the batch started and ended. I realized that the last value the picomp2 query ...
    narburgh
    last modified by narburgh
  • How to Passing Parameters from MS SQL Reporting Services (SSRS)

    Has anyone tried to pass parameters from SSRS to PI ODBC?   If possible I would like to learn how.   DB
    DavidBrookes
    last modified by DavidBrookes
  • PI JDBC Driver connection to Apache Nifi.docx

    Apache nifi is an easy to use, powerful, and reliable system to process and distribute data.  https://nifi.apache.org/ This document provides instructions on how to connect PI Data to Apache Nifi and create a si...
    ErnestGarner
    last modified by ErnestGarner
  • PI Data into Oracle DB

    H Folks,   I´m loocking for an permanent, performant way to transfer data from PI into an ORACLE DB.   There are two requirements:   1) accessing Data regularely for creating reports, KPI´...
    flost
    last modified by flost
  • Product Release: PI ODBC 2016 R2

    PI ODBC 2016 R2 is released 2016-11-10   OSIsoft is pleased to announce the general availability of PI ODBC 2016 R2, a member of the PI Developer Technologies suite of products.   Please see the official ...
    tmcmanus
    last modified by tmcmanus
  • Inserting multiple entries with SQL parameters?

    I am using ODBC/OLEDB Provider to insert data into the PI archive. I am using Python/pyodbc to submit these queries with SQL parameters.For a single entry this is working well:.   sql =  "INSERT INTO piarch...
    ErikN
    last modified by ErikN
  • PiOLEDB: Query table piarchive.piinterp in combination with join

    Hello, is it possible to query the piarchive.piinterp table in combination with join? I want to query a lot of exact times of an pitag by using the sql server.   Example: Select * from [myDB].[dbo].[myTable] ...
    OliverKrieger
    last modified by OliverKrieger
  • 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...
    kfong
    last modified by kfong
  • the script of ODBC connection when we use the trust in PI system

    For the purpose to clearly know the connection from application and user, we use the PI trust mapping the Windows domain accout, some of trust is for the static IP address. Then we have a question on the PI connect...
    Charles Zhang
    last modified by Charles Zhang