Has anyone tried to pass parameters from SSRS to PI ODBC?
If possible I would like to learn how.
DB
Has anyone tried to pass parameters from SSRS to PI ODBC?
If possible I would like to learn how.
DB
Hi David,
I haven't seen many customers using SSRS with PI ODBC; however, it should be possible with PI OLEDB. Have you checked out the white paper: Integrating PI System 2010 with Microsoft SSRS?
Daphne, I was looking to get information off this post, however the linked paper is no longer available? This seems like a topic of interest yet.
@ twipf on Sep 2, 2015 8:39 PMHi Tyler,
I have sent you a PI Square message regarding this white paper. Thanks.
Thanks Daphne, I've received and downloaded it.
Hello Daphne,
Could be possible to have the white paper too? I tried to download it but is not available.
Kindly regards,
Jaime Olmo
Hello Jaime,
Please let me investigate, why this download link is not working for you. I may contact you via direct message about this. Meanwhile and also for other interested users, there is a more recent document available with the UC 2016 Hands-On Lab Workbooks. After downloading this package, please look for Build Better Reports with PI SQL Framework.
Hello Gregor Beck,
The portal only says: "The file you selected is not available. A newer or updated version may be available.Go to the following link to search for your download: All Downloads." No more details. The newer version in the Hands-On Lab looks promising. Anyway I would like to have the version of 2010 for reference with our legacy systems.
Hi Jaime,
I am working on making the White Paper from 2010 available to you. Please stand by.
Hi Jaime Olmo,
I've added a manual override to your SSO profile. You should now be able to download Integrating PI System 2010 with Microsoft SSRS.
I have more good news. The White Paper is now available to anyone signed in with an SSO account.
Hi David,
I haven't seen many customers using SSRS with PI ODBC; however, it should be possible with PI OLEDB. Have you checked out the white paper: Integrating PI System 2010 with Microsoft SSRS?