In this blog we are going to discuss regarding main difference between classic and integrated extract in Oracle GoldenGate :

Data capture method: Classic extract reads data directly from the database transaction logs, while integrated extract receives data from a logminer server.

Supported data types: Integrated extract supports more Oracle datatypes compared to classic extract.

Database integration: Integrated extract is fully integrated with the database, requiring no additional setup for Oracle RAC, ASM, and TDE.

Log file handling: Integrated extract can automatically switch between different copies of archive logs or mirrored versions of online logs, providing better handling of missing log files.

Database version support: Integrated extract is only supported for Oracle Databases from 11gR2 onwards.

Performance: Integrated extract generally offers better performance and scalability due to its tighter integration with the database.

Future support: Classic extract has been deprecated and will not be enhanced in future releases, while integrated extract is the recommended and actively developed method.

Hope you liked the blog! Do share your thoughts in comments! Keep Learning Keep Growing!