My Company is looking to integrate all of its data into a SAP Replication server. Is there a current way to do this with PI data?
There are a couple of different ways that you can make PI data available for 3rd party tools. First, you can expose the PI Server using PI OLEDB Enterprise (AF) and/or PI OLEDB Provider (Data Archive). These will allow you to access the data stored in PI using SQL queries. Another option is the PI Integrator for Business Analytics/SAP HANA. The PI Integrator for Business Analytics can write PI data to different targets, including SQL, Oracle, flat files, and Hadoop. The PI Integrator for SAP HANA writes PI data to SAP HANA specifically. Our YouTube Learning Channel has an overview: OSIsoft: What is the PI Integrator for Business Analytics? - YouTube .
I'm not too familiar with SAP Replication Server or SAP Data Services, though either of these approaches should work if they can read from external tables.
While it's technically possible, I would not recommend duplicating your entire PI Server. The PI Server can hold a lot of data; trying to access all that data at once can cause significant performance issues affecting its functionality. Both the approaches I mentioned earlier are best suited for accessing a subset of PI data externally.
From what I have been told, SAP Replication server needs write access to the database it is replicating to create and modify objects and also needs to view the transactional logs to determine when a change has occurred. Immediately from these points it was a no go but I thought I would check for an interface or connector.
Thankyou as well for raising the performance considerations for the PI server- I had not considered these.
Retrieving data ...