Our employee data are available in Oracle database and we want to integrate the employee details to our environment. Every day the data should be synchronized and if any new user is added/modified, it should be updated to our environment post synchronization. How can I integrate Oracle with BPM'Online and where can I find any documents/link related to it?
Hence, you can use OData protocol, which is a universal for integrations. Also, you can create your own web service in bpm'online using C# and send external request to your side. Please see instruction on how to create your own web service:
You can find the CRUD requests example in the atteched file. The only two things that the manual doesn't cover are CSRF token (you will receive it in the login request response and you will need to add it to all of the next requests). Please check how I add the sessionid key. You need to add the CSRF id in the same way. Besides, you can avoid using the sessionid cookie if you use the forceusesession key in the header of all of the requests.
Please note that it's not ok to select all of the contacts via API. If you have a lot of contacts, the request will take huge amount of time. I recommend to use a filtration and select only the data that you need.