Posted by
ErmanArslansOracleBlog on
URL: http://erman-arslan-s-oracle-forum.114.s1.nabble.com/BIG-data-architecture-tp8559p8562.html
Hi Roshan,
I don't know anything about Streamet/talend. Can it perform CDC?
Goldengate is reliable and it can do CDC, as you know.
It is reliable and the best solution for making CDC on Oracle environments.
PLSQL transformation is cheap but it should be managed well. It should be under control of some sort of application.. Else, you will do lots of maintanence.
2 diagrams that you sent are telling me different stories.
In one of them, you use Hadoop and in the other you use Oracle RDBMS and RAC.
I don't know your business story and purpose for building this kind of an environment, but you should decide the correct environment according to your needs.
Using Oracle and Hadoop together is an alternative that we consider while dealing with enteprise Data Warehouses. We generally use Hadoop for offloading some of the processing and we still use Exadata (Oracle RAC) in the front line.
Orchestration and integration between the platforms is also important.
So, as for CDC, there are other solutions available on the market.
One of the is STRIIM. We ( as GTech )are the distributor of it. So maybe you can take a look at it as well..
Of course, if you want to have a POC or consultancy, we are happy to help.
We are already implemented this solution it lots of Enterprise Companies.
Striim ->
https://www.striim.comAlso, you may want to check the Gluent. We are started to deali with it recently.
Gluent ->
https://gluent.com/