Hi All
Its been a while since I have been on here… But hopefully I can find some advice .
I am in need of an integration tool SQL to Lotus Notes, to replace our old one named Replic Action .
The Replic Action software is more than 15 years old, the software is just too old and slow and is no longer providing the integration service modern systems require. is became evident again yesterday evening when we ran into an issue, where the character encoding failed due to Repic Action failing because it was relying on the operating system to encode the characters correctly, but as I understand, Windows 2012 does not provide this support, instead it suggests applications like Replica Action should take care of encoding characters itself. To fix this issue, I have to create my own integration job using an ODBC call in an agent.
We have setup a lot of Replic Action jobs that pull in updates/inserts from our master BI data and map the data to fields in lotus notes databases, this tool also allows us to run agents once a job has ran.
So, I am wondering, is there any new and modern integration tools out there similar to this ?