Trends, Tips and Insights on Digital Learning and Certification

Learn to Get Data from One Database to Another

Diana Gray
Sr. Principal Curriculum Product Manager

From time to time, IT staffers may find that the differences in their various databases present a problem. For example, they might need to replicate data from one database to another.

How do you get data to cooperate and communicate between different data sources?

One option is to use Oracle GoldenGate, a comprehensive software package that enables real-time data integration, transformations, transactional change data capture, and more. Oracle University offers training that shows you how to do this, and more, using this powerful tool.

Oracle GoldenGate 12c: Fundamentals for Oracle

Integrate your organization's disparate data across heterogeneous databases to improve decision-making.

Configure and Implement Oracle GoldenGate More Efficiently

By taking the above mentioned course, you'll learn to install Oracle GoldenGate and prepare the source and target environments. See how to use the Oracle GoldenGate command line interface (GGSCI) efficiently.

You'll also develop the knowledge and skills to configure Change Capture (Extract), Change Delivery (Replicate), and Initial Load. You'll learn how to extract trails and files using Data Pump, create parameter files, and manage Oracle GoldenGate instances.

Explore New Features in 12c

Features new to 12c, such as Integrated Apply and Wallet, are highlighted along the way. This course is based on Oracle GoldenGate version 12.1.2. Please note that the labs are done in Linux.

Oracle GoldenGate 12c: Advanced Configuration for Oracle

Enrolling in this Oracle GoldenGate 12c training will help you develop your installation and configuration skills. By interacting with top Oracle instructors, you'll be able to ask questions as you solidify your understanding.

Integrate your organization's disparate data across heterogeneous databases for improved decision-making. Become more efficient at configuring and implementing the more advanced features of Oracle GoldenGate used together with the Oracle RDBMS 12c.

Once you've completed this course, you'll have the knowledge and skills to utilize the more advanced features of Oracle GoldenGate 12c, including:

  • Integrated capture
  • Integrated delivery
  • Active-active replication
  • Conflict detection and resolution
  • DDL/DML replication
  • Oracle GoldenGate event marker subsystem
  • Advanced data manipulation and transformation techniques
  • Advanced data mapping

In addition, you will use a simulated Oracle RAC configuration to experiment with the Oracle GoldenGate Clusterware-aware facilities, which ensure seamless data replication in case of node failure.

Oracle GoldenGate 12c: Troubleshooting and Tuning

This Oracle GoldenGate 12c Troubleshooting and Tuning training teaches you how to gather and examine evidence; you’ll also learn to solve case problems, diagnose their cause, and find methods of resolution. Each of these practices challenges you to diagnose and troubleshoot the issue using GoldenGate software.

By enrolling in this course, you'll develop deeper knowledge of Oracle GoldenGate 12c performance tuning methods. Expert instructors will teach you how to identify the causes of slow startups, evaluate lag statistics, and solve network and disk bottlenecks.

Utilize all of the existing GoldenGate tools, such as GGSCI and Logdump, the health check scripts, and the Streams Performance Advisor (UTL_SPADV) to troubleshoot system issues occurring to both classic extract/replicate and integrated extract/replicate.

Oracle GoldenGate training is just what you need to get your databases to work together. Sign up for a course today so you can master the necessary skills.

Related Content

Be the first to comment

Comments ( 0 )
Please enter your name.Please provide a valid email address.Please enter a comment.CAPTCHA challenge response provided was incorrect. Please try again.