PI connection with OLEDB server

[vishnu_pallamreddy]

Hi All,

I have a requirement of connecting PI server to Honeywell PHD database server. As per Honeywell the only way to access their database is through OLEDB provider as they are exposing their database to outer world through OLEDB provider only.

Please let me know if anyone has worked on PI connection with OLEDB server.

Thanks In Advance,

Vishnu Pallamreddy.

[arunneerolil · Accepted solution]

Vishnu,

Ideally SAP MII should be used for these kinds of integration.

If you have an MII in your landscape, you can expose it as a web service and consume it from PI.

Another option is PI-> .NET platform/server-> PHD, but you should have a .NET platform/server in your landscape.

regards,

Arun

[vishnu_pallamreddy · Accepted solution]

Hi Arun,

please let me know what is SAP MII?

[arunneerolil · Accepted solution]

Vishnu,

Its SAP Manufacturing Integration and Intelligence -> Used for Shop floor/ manufacturing system integration and reporting.

http://help.sap.com/saphelp_mii150sp00/helpdata/en/4d/54cbe9071b60c5e10000000a15822d/frameset.htm

Arun

[former_member183908]

I think you can go with the other option with webservice.You can request the DB team to expose their application/table to webservice and consume the same using PI.

Thanks

[iaki_vila]

Hi Vishnu,

AFAIK SAP PI only supports JDBC connections. If you only option is to use OLEDB you would need to install the driver and to do a java application to be deployed on PI server. This Java application can be used as a wrapper and you could can it via http or soap.

Regards.