I am connecting to JDBC 2019 with no specified properties. I get this warning message for PI: com.osisoft.jdbc.common.DriverImpl acceptsURL SEVERE: Invalid sub-protocol provided in jdbc:pioledb://dasName/Data... I need to test real time data access from PI Server. For this I need to load data into PI Server. What tools or approaches can I use to upload data into PI Server Was wondering if the Transpose function can be used to transpose a view? Hi Friends, I have set up a query to read the data from Pi Server into SQL Server and the query works fine. However, when I save this query as a SQL Server Integration Service Package and run the same, ... I am having trouble configuring our RTQP server and user authentication the way i want to. In reading through the admin guide it only provides instructions for adding a mapping/trust for the ... Hello Everyone! I have configured digital tags, which values I can see good in Archive editor but in SQL Commander it is showing incorrect please check below screenshots. PI SQL Commander: ... What is the case format in PI SQL Commander? Thank you. Hi, I need to provide a large amount of data (5000 tags over 2 years) for a group of analysts. At the moment, I generate a query via PI SQL Commander Lite and saves the result to a file. However, this method... Goodmorning, I am having issues querying the value of an attribute which is linked to an enumeration set in AF. I copy the query that actually gives back the field s.Value (SNAPSHOT VALUE) empty in thi... What I am doing is looking for elements that have name like 'Engine%' ex: 'Engine 1', 'Engine 2' , etc I also want to filter down to the specific piece of equipment defined by the Attribute EquipId.... I have searched the question DB and can not find something similar I have also reviewed all the Query compendium and nothing strikes me.... We have a SQL table name EquipmentInfo in o... I have a vb.net program that runs fine on my development box. When I deploy to my user, the pi data does not show up. I'm using pi oledb. I have a PSA license. I would like to know what files I my be missing or what f... I am developing SSRS reports that use PI data. I am trying cobble together something that allows me to ask parameterized questions (as opposed to writing explicit functions for every attribute I am asked... I am trying to abstract a way to get Attribute Samples without having to write a function table, and table valued function, and a linked server procedure for every attribute. if you care to comment ... A downstream java based application needs to use PI JDBC via a PI SQL DAS middleware deployment to query AF Attributes to determine: Current Value of a set of PI AF Attributes "Delta" or change in PI AF Attribute ta... i want to download the pi sql data access to fetch the data from sql. I want to create a connection using PI OLEDB with JMP and PI data. How do I achieve that? 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... 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... 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.