Thank you for your reply! I've watched that video. But it doesn't answer my question. I might have stated it incorrectly.
I have a element hierarchy laid out in PI System Explorer. This is sitting on a development database, so it is not in production yet.
Asset Server: PIAF-GEN
I want to be able to access the data in DevDb in a SSRS report.
I'm sorry PI is new to me and I'm not familiar with all of its products.
The database that you are querying from is determined by the table schema. So an PI OLEDB Enterprise query would look something like:
WHERE DBReferenceTypeID IS NOT NULL
This query is accessing elements from the NuGreen AF database.
If this is your first time working with our SQL products, I suggest taking the time to peruse the rest of the PI SQL course as it does a good job introducing you to how the products work and then does a deeper dive into some common use-cases.
Okay that make sense. I will check out the PI SQL course as you recommended.
I do have one last question:
In SSRS, I do not have the option for "PI SQL Client" for the OLE DB Provider. It does however give me the option to choose "PI OLE DB Provider". Do I need the PI SQL Client to use the PI OLEDB Enterprise Query?
Thank you again for your help