Oracle acquired GoldenGate on September 3,2009.
GoldenGate enables the exchange and manipulation of data at the transaction level among multiple, heterogeneous platforms across the enterprise.
GoldenGate Features and Capabilites :-
1) Filtering :- Gives the flexibility to select and replicate the desired amount of data from the source(s) that could be Database(s),Flat files,File systems,Datawarehouse,etc.
2) Transformation :- Gives the capability to move the data between two different kind of databases like between SQL Server and Oracle,IBM DB2 and Oracle by transformation.
3) Custom Processing :- Allows to perform complex mappings and to use Ibuild selective functions for processing.Gives the option for scheduling also.
4) Real-Time :- Log-based capture capability allows to move thousands of transactions per second with very low impact.
5) Heterogenous :- Allows to move changed data accross different databases and platforms.
6) Transactional :- Can work in transactional environments as well by maintaining the transactional integrity.
7) Performance :- More performance because of Log-based capture.
8) Extensibility and Flexibility :- Its open and modular architecture allows to extract and replicate selected data records, transactional changes, and changes to DDL across a variety of topologies.
9) Reliability :- It is resilient against failures and interruptions by maintaining checkpoints,trails and logs.
No comments:
Post a Comment