At our company we have a custom made ERP built with ibm Domino. Next to this we also have a webshop built with PHP. Currently we are sharing each others data. In Domino I have done this by creating java agents which receive and send data, this happens on the main server and a replicate server. The problem is that there are getting more and more agents. I was thinking about a way how to do this different. Instead of agents I was thinking about setting up a SQL Server in which I will store the Notes documents data. This SQL Server can then be shared with the website. Is this possible? Or are there better ways to fix this?
Instead of synching Notes data to SQL Server and having PHP access the SQL data, why not just code your PHP to directly access the Notes data using Domino Access Services?