Has anybody accessed OSI PI data from Business Objects 4.0 through the Information Design Tool (IDT) using the OLEDB drivers? Of particular interest to me is to be able to access PI AF data contained on the SQL Server DB.... any ideas??
I recently spent quite a bit of time trying to connect PI to BOBJ 4. Below is a summary of my findings:
A prototype was developed to assess the potential of connecting PI to the BOBJ 4.0 platform directly through both OLEDB and JDBC. ODBC and Web Services, while viable options would not provide access to all data and thus were not tested. Both of these access methods do not expose MDB or Batch data.
Results of the prototype are discussed below:
• Using the Generic OLEDB connection within BOBJ we were unable to establish a connection to the PI system. As this was not a supported database by SAP they were only able to provide general direction on our configuration and could not raise the issue to development as it was an unsupported use.
• Layering JDBC on the OLEDB installation and using the Generic JDBC connection within BOBJ we were able to make the connection to the source PI system however we were not able to develop a universe for a number of reasons:
o BOBJ could not fetch columns for the exposed DB tables. We were able to bring these in through the use of derived tables but this required using open ended SQL queries (select * from …) that would not be feasible in an operating system as the complete data sets would be much too large and would encounter time out delays before completion.
o Alternatively we attempted to connect via the PI AF system but this to was not successful as BOBJ could not recognize the GUID data types that are required to connect data elements.
Likewise SAP indicated that this was not a supported database by SAP and they were only able to provide general direction on our configuration and could not raise the issue to development as it was an unsupported use.
While neither of these solutions was capable of connecting through BOBJ, we were able to test the ability of having an application remotely connect to PI through PI JDBC.
Additionally, ARI has already implemented a solution where BOBJ is able to connect to PI systems through an OLEDB Linked Server configured in SQL Server to act as a middleware application. This then exposed the PI data as if it were resident in the SQL Server database hence allowing the generic SQL Server connections within BOBJ to be leveraged. This approach was likewise demonstrated effective in the OIM equipment data model prototype for exposing PI AF data structures. Note: SQL Server views had to be created for each of the exposed tables as BOBJ was not able to read these directly.
Thank you for sharing these results!
i know this post is old, but i thought i would respond incase you are getting emails...i recently did a write up on how we attached BO to PI using OLEDB Enterprise
Retrieving data ...