Oracle GoldenGate Studio, It is here and so are my thoughts

Ever since Oracle purchased GoldenGate, the biggest complaint about Oracle GoldenGate (OGG) has been around the fact that it is a command line tool. I like the command line interface of OGG, the simplicity of it and what can be done by just editing the parameter files from the command line. However, for those of you that require a graphical interface, Oracle has listened and provided a new tool. This tool is Oracle GoldenGate Studio!

This year at Oracle Open World 2015, Oracle announced Oracle GoldenGate Studio Release 1 (12.2.1). This is Oracle’s first step into bringing Oracle GoldenGate into the GUI environment. Studio is a design tool that complements the monitoring tools that Oracle provides for GoldenGate.

As a design tool, you can do a range of things now. A few of the thing are as follows:

  • Build out a wide range of Oracle GoldenGate architectures
  • Synced parameter files to systems where Oracle GoldenGate is running or dump the files to a directory for later installation
  • Export/Import GoldenGate Solutions
  • Define mappings in either local or global settings

When you first start Oracle GoldenGate Studio, anyone who has worked with Oracle Data Integrator will notice some similarities. This is because the initial framework for Oracle GoldenGate Studio is built around the ODI framework. This is good because if provides a familiar looking interface for the end user.

Just like ODI, Oracle GoldenGate Studio uses a repository. This repository can be the same repository as many other Oracle products. In my environment, I’ve got Oracle GoldenGate Studio running against a 12.1.0.2 database. The repository is used to keep track of all the mappings needed to keep track of the architectures that is designed within the studio.

Overall, my initial thoughts on this product are:

  • For a first release, it is good but has some limited functionality
  • I like the interface and it helps to make quick work of designing a flow; however, initially there will be a learning curve for most GoldenGate Admins (no more Visio diagrams need to track)
  • Not thrilled with having another repository to keep up with; nice that is can be combined into other repositories if needed, just need to make sure schema names do not overwrite

 

With this tool being announced at Oracle Open World, expect some great blogs about this tool being road tested as well. In the mean time, once it becomes available (after OOW15) give it a try. It will make your life a bit easier.

Enjoy!!

Advertisements

10 comments

  1. Thanks for the write up.

  2. Thank for the write up.

  3. When to download Oracle GoldenGate Studio?

    1. Not yet. Studio is still in beta. Stay tuned though. Will be out shortly.

      1. @curtisbl Thanks, and in the present can download in edelivery.

      2. does gg studio comes under Oracle GoldenGate Foundation Suite,could you suggest how i can download as not able to gg studio there.

  4. Thanks.how can i get the beta version download.

  5. Hi
    Is golden gate monitor included in golden gate studio. Reading your book gave me that impression but my understanding may be wrong. From your book and I paste here
    With the addition of GoldenGate Studio, Oracle now provides an offering that will allow you to design
    and build Oracle GoldenGate architectures, validate data between environments, and monitor these
    environments from a central location

    The monitor is where I have the confusion.
    Do I need to install Golden gate monitor if I have studio

    1. Thanks for reading the book. Studio has some light monitoring built into it. GoldenGate Monitor is a separate product.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

Mrs. Jaye's Class Blog

Coordinate Algebra & Advanced Algebra

Pardy DBA

ORA-00001: unique constraint (ORA.BLOG_TAGLINE_PK) violated

Martin Widlake's Yet Another Oracle Blog

Oracle performance, Oracle statistics and VLDBs

HeliFromFinland

Heli's thoughts on Database Designing, Oracle SQL Developer Data Modeler, User Groups etc.

Julian Dontcheff's Database Blog

The good DBA is one who learns from his mistakes, the best DBA is one who learns from other DBA's mistakes

Martins Blog

Trying to explain complex things in simple terms

The Data Warrior

Changing the world, one data model at a time. How can I help you?

Maaz Anjum's Blog

A life yet to be lived...

PeteWhoDidNotTweet.com

Stuff that interests me, if not you!

%d bloggers like this: