asked
How replicate database between two database with Oracle esb middleware?
I have two SQL Server databases with the same version. there is a Oracle bus service between the two SQL Server database. I want transaction replication between two database,two database located in different cities. How do I configure Transactional Replication between the two Database?
II had to research this one as I have never used Oracle ESB. What I found was basically no, it will not work. Simple explanation is that the ESB can transform HTTP, SOAP and FTP protocols. Replication is a proprietary protocol and ESB does not understand it. From my own experiences with other things, I would experiment with it and see if you can get it to work. That is because ultimately, if you can pass SQL Server calls through ESB then you should be able to do replication. Try setting up your packages to use stored procedures to replicate data. Additionally, you are able to set up SQL Server to use SOA, which is what ESB uses. So logically I see no reason for it to not work. Some links of interest:
https://blogs.oracle.com/middleware/entry/configuring_mssql_with_soa_suite
http://stackoverflow.com/questions/41597551/how-replicate-database-between-two-database-with-oracle-esb-middleware
http://www.oracle.com/technetwork/articles/soa/ind-soa-esb-1967705.html
18 People are following this question.
