So I am trying to connect the accounting software Procas to my Sharepoint server, so that I can utilize the values from the Procas accounts in a Nintex Workflow. I have heard that this connection is possible, but have not seen it implemented for myself. Both programs are on separate SQL server 2012 R2, and I believe that the best bet would be to use a merge replication with the Procas as the publisher and the Sharepoint as the subscriber, however, I was wondering if anyone here had any knowledge on this or has done this same connection in the past. I would appreciate any feedback or knowledge anyone can bestow upon me.
PS I am not sure which place to publish this in, so I am trying Installation
Solved! Go to Solution.
I have since found out that since Procas currently runs our server, it is not possible to create a dynamic connection between that server and the one I am running Sharepoint from. In order to share data, exporting the data from the Procas server to the Sharepoint server daily just to view the data. It would require going into the Procas server to change any of that data though.