Tuesday Feb 18, 2014

Recap of Oracle GoldenGate 12c Webcast with Q&A

Simply amazing! That’s how I would summarize last week’s webcast for Oracle GoldenGate 12c.  It was a very interactive event with hundreds of live attendees and hundreds of great questions. In the presentation part my colleagues, Doug Reid and Joe deBuzna, went over the new features of Oracle GoldenGate 12c. They explained Oracle GoldenGate 12c key new features including:

  • Integrated Delivery for Oracle Database,
  • Coordinated Delivery for non-Oracle databases,
  • Support for Oracle Database 12c multitenant architecture,
  • Enhanced high availability via integration with Oracle Data Guard Fast-Start Failover,
  • Expanded heterogeneity, i.e. support for new databases and operating systems,
  • Improved security,
  • Low-downtime database migration solutions for Oracle E-Business Suite,
  • Integration with Oracle Coherence.

We also had a nice long and live Q&A section. In the previous Oracle GoldenGate webcasts, we could not respond to all audience questions in a 10-15 minute timeframe at the end of the presentation. This time we kept the presentation part short and left more than 30 minutes for Q&A. To our surprise, we could not answer even half of the questions we received. 

If you missed this great webcast discussing the new features of Oracle GoldenGate 12c,  and more than 30 minutes of Q&A with GoldenGate Product Management, you can still watch it on demand via the link below.

On Demand Webcast: Introducing Oracle GoldenGate 12c: Extreme Performance Simplified

On this blog post I would like to provide brief answers from our PM team  for some of the questions that we were not able to answer during the live webcast.

1) Does Oracle GoldenGate replicate DDL statements or DML for Oracle Database?

    Oracle GoldenGate replicates DML and DDL operations for Oracle Database and Teradata.

2) Where do we get more info on how to setup integration with Data Guard Fast-Start Failover (FSFO)?

     Please see the following blog posts or documents on My Oracle Support:

Best Practice - Oracle GoldenGate and Oracle Data Guard - Switchover/Fail-over Operations for GoldenGate    [My Oracle Support Article ID   1322547.1] 

Best Practice - Oracle GoldenGate 11gr2 integrated extract and Oracle Data Guard - Switchover/Fail-over Operations  [My Oracle Support Article ID 1436913.1] 

3) Does GoldenGate support SQL Server 2012 extraction? In the past only apply was supported.

Yes, starting with the new 12c release GoldenGate captures from SQL Server 2012 in addition to delivery capabilities.

4) Which RDBMS does GoldenGate 12c support?

GoldenGate supports all major RDBMS. For a full list of supported platforms please see Oracle GoldenGate certification matrix.

5) Could you provide some more details please on Integrated Delivery for dynamic parallel threads at Target side?

Please check out our white papers on Oracle GoldenGate 12c resource kit for more details on the new features, and how Oracle GoldenGate 12c works with Oracle Database. 

6) What is the best way to sync partial data (based on some selection criterion) from a table between databases?

 Please refer to the article: How To Resync A Single Table With Minimum Impact To Other Tables' Replication? [Article ID 966211.1]

7) How can GoldenGate be better than database trigger to push data into custom tables?

Triggers can cause high CPU overhead, in some cases almost double compared to reading from redo or transaction logs. In addition, they are intrusive to the application and cause management overhead as application changes. Oracle GoldenGate's log-based change data capture is not only low-impact in terms of CPU utilization, but also non-intrusive to the application with low maintenance requirements.

8) Are there any customers in the manufacturing industry using GoldenGate and for which application?

We have many references in manufacturing. In fact, SolarWorld USA was our guest speaker in the executive video webcast last November. You can watch the interview here. RIM Blackberry uses Oracle GoldenGate for multi-master replication between its global manufacturing systems. Here is another manufacturing customer story from AkzoNobel.

9) Does GoldenGate 12c support compressed objects for replication? Also does it supports BLOB/CLOB columns?

Yes, GoldenGate 12c and GoldenGate 11gR2 both support compressed objects. GoldenGate has been supporting BLOB/CLOB columns since version 10.

10) Is Oracle Database 11.2.0.4 mandatory to use GoldenGate 12c Integrated Delivery? Not earlier versions?

Yes. To use GoldenGate 12c’s Integrated Delivery, for the target environment Oracle Database 11.2.04 and above is required .

11) We have Oracle Streams implementation for more than 5 years. We would like to migrate to GoldenGate, however older version of GoldenGate were not supporting filtering individual transactions. Is it supported in GoldenGate 12c?

      Yes, it is supported in GoldenGate 12c.


In future blog posts I will continue to provide answers for common questions we received in the webcast. In the meanwhile I highly recommend watching the Introducing Oracle GoldenGate 12c: Extreme Performance Simplified webcast on demand.

Thursday Oct 24, 2013

Oracle GoldenGate 12c - Leading Enterprise Replication

Oracle GoldenGate 12c released  on October 17th and includes several new cutting edge features that firmly establishes GoldenGate's leader position in the data replication space.   In fact, this release more than doubles the performance of data delivery, supports Oracle's new multitenant database feature,  it's more secure, has more options for high availability, and has made great strides to simplify the configuration and deployment of the product.     Read through the press release if you haven't already and do not miss the quote from Cern's Eva Dafonte Perez, regarding Oracle GoldenGate 12c "….performs five times faster compared to previous GoldenGate versions and simplifies the management of a multi-tier environment"

There are a variety of new and improved features in the Oracle GoldenGate 12c.  Here are the highlights:

  • Optimized for Oracle Database 12c -  GoldenGate 12c is custom tailored to the unique capabilities of Oracle database 12c and out of the box GoldenGate 12c supports multitenant (pluggable database (PDB)) and non-consolidated deployments of Oracle Database 12c.   The naming convention used by database 12c is now in three parts (PDB-name, schema-name, and object name).  We have made changes to the GoldenGate capture process to support the new naming convention and streamlined the whole process so a single GoldenGate capture process is being used at the container level rather than at each individual PDB.  By having the capture process at the container level resource usage and the number of processes are reduced. To view a conceptual architecture diagram click here.
  • Integrated Delivery for the Oracle Database - Leveraging a lightweight streaming API built exclusively for Oracle GoldenGate 12c, this process distributes load, auto tunes the degree of parallelism, scales better, and delivers blinding rates of changed data delivery to the Oracle database.  One of the goals for Oracle GoldenGate 12c was to reduce IT costs by simplifying the configuration and reduce the time to manage complex infrastructures.  In previous versions of Oracle GoldenGate, customers would split transaction loads by grouping tables into multiple different delivery processes (click here to view the previous method). Each delivery process executed independently and without any interaction or knowledge of other delivery processes.  This setup was complicated to configure and time consuming as the developer needed in-depth knowledge of the source and target schemas and the transaction profile. With GoldenGate 12c and Integrated Delivery we have made it easier to configure and faster to deploy.  To view a conceptual architecture diagram of integrated delivery click here
  • Coordinated Delivery for Non-Oracle Databases - Coordinated Delivery orchestrates high-speed apply processes and simplifies the configuration of GoldenGate for non-Oracle targets. In Oracle GoldenGate 12c a single delivery process is used with multiple threads (click here) and key events, such as primary key updates, event markers, DDL, etc, are coordinated between the various threads to insure that the transactions are applied in the same sequence as they were captured, all while delivery improved performance. 
  • Replication Between On-Premises and Cloud-Based systems. - The trend for business to utilize both on-premises and cloud-based systems is rising and businesses need to replicate data back and forth.   GoldenGate 12c can be configured in a variety of ways to provide real-time replication when unrestricted or restricted (limited ports or HTTP tunneling) networks are between on-premises and cloud-based systems.   

  • Expanded Heterogeneity - It wouldn't be a GoldenGate release without new and improved platform support.   Release 1 includes support for MySQL 5.6 and Sybase 15.7.   Upcoming in the next release GoldenGate, support will be expanded for MS SQL Server, DB2, and Teradata.
  • Tighter Security - Oracle GoldenGate 12c is integrated with the Oracle wallet to shield usernames and passwords using strong encryption and aliases.   Customers accustomed to using the Oracle Wallet with other Oracle products will instantly be familiar with how to use this great new feature
  • Expanded Oracle Application and Technology Support -   GoldenGate can be used along with Oracle Coherence to enable real-time changed data feeds to the Coherence cache using Toplink and the Oracle GoldenGate JMS adapter.     Plus,  Oracle Advanced Customer Services (ACS) now offers a low downtime E-Business Suite platform and database migrations using GoldenGate as the enabling technology. 

Keep tuned for more blogs on the new features and the upcoming launch webcast where we will go into these new features in more detail.   In the mean time make sure to read through our white paper "Oracle GoldenGate 12c Release 1 New Features Overview"

Friday Sep 20, 2013

Must-Attend Oracle GoldenGate sessions at OpenWorld

 We are very excited for a great event next week. In my last couple of blogs I gave overviews of what is lined up in the Data Integration track. Today I’d like to highlight some of the other key Oracle GoldenGate sessions in case you missed them in our Focus On Data Integration document.

 Obviously the Oracle GoldenGate: New Features and Product Strategy (CON8867) session on Monday at 12:15PM in Moscone West – 2024 is a must-attend session for the GoldenGate community. You will hear the latest features and the roadmap.

If you are currently evaluating high availability solutions then the session “Continuous Availability with Oracle GoldenGate: Best Practices from Comcast” will help you greatly. You’ll get to hear best practices from Comcast on how they implemented four-way and three-way multimaster (active-active) replication architectures using Oracle GoldenGate. You can see how they were able to perform zero downtime system maintenance activities such as patching and upgrades of the operating systems and relational databases supporting critical business operations.

Continuous Availability with Oracle GoldenGate: Best Practices from Comcast (CON8951)

Monday at 12:15PM PT Moscone South – 300

 On Tuesday the session “A Panel of Masterminds: Perspectives from Oracle GoldenGate Customers” will feature a customer panel made up of enterprise architects and other data integration professionals to discuss how they revolutionized their business using Oracle GoldenGate. This interactive session will provide examples of how Oracle GoldenGate supports critical Oracle Applications such as Oracle E-Business Suite and JD Edwards.

A Panel of Masterminds: Perspectives from Oracle GoldenGate Customers (CON8898)

Tuesday at 3:45PM-4:45PM PT Moscone West – 2024

Data integration is not simply replication and in many instances it requires real-time ETL capability. Oracle GoldenGate and Oracle Data Integrator work together for improved data integration agility. In the Hands-On-Lab “Combining Oracle Data Integrator and Oracle GoldenGate”, specifically designed for developers, DBAs, and architects, you will hear best practices for using Oracle GoldenGate and Oracle Data Integrator together to perform real-time ETL. Attendees will experience and hands-on walkthrough on how to configure Oracle GoldenGate from Oracle Data Integrator Studio

 Hand-on-Lab: Combining Oracle Data Integrator and Oracle GoldenGate (HOL10144)

Tuesday at 3:45PM Marriott Marquis – Nob Hill AB

Oracle GoldenGate and Oracle Active Data Guard are two powerful technologies that can be implemented together seamlessly. On Wednesday you can learn how these two technologies can work together in the session “Best Practices for Integrating Oracle GoldenGate with Oracle Active Data Guard”. For Oracle Database customers incorporating data integration with high availability, this session is a can’t miss!

Best Practices for Integrating Oracle GoldenGate with Oracle Active Data Guard (CON8500)

Wednesday 10:15AM PT Moscone South – 104

 For E-Business Suite, Oracle BI, and Oracle Coherence customers a great session awaits you on Wednesday: “Powering Solutions for Oracle Applications with Oracle GoldenGate” will cover E-Business Suite platform migrations and operational reporting, Oracle BI real-time reporting, and Oracle Coherence hot caching. This is a great opportunity to learn how Oracle GoldenGate can extend capabilities with your business applications

Powering Solutions for Oracle Applications with Oracle GoldenGate (CON8897)

Wednesday 11:45AM PT Moscone West – 2024

 On Thursday we will start with the session “Oracle Management Pack for Oracle GoldenGate: Product Update”, which will cover the latest features and enhancements to managing and monitoring GoldenGate.

Oracle Management Pack for Oracle GoldenGate: Product Update (CON9105)

Thursday 11:00AM PT Moscone West – 2012

 In the session “Deploying Oracle GoldenGate with Multitenant Container Databases” you can learn how Oracle GoldenGate can be deployed to capture and replicate changes using Container Databases (CDBs) and Pluggable Databases (PDBs) introduced in the Oracle Database 12c multitenant architecture. Our experts will also provide Oracle GoldenGate configuration recommendations for common and advanced deployment models within the multitenant architecture.

Deploying Oracle GoldenGate with Multitenant Container Databases (CON8499)

Thursday 2:00PM Moscone South – 200

A key use case for GoldenGate is providing zero downtime, and low-risk database upgrades and platform changes. “Cross-Platform Database Upgrades with Oracle GoldenGate” will cover database upgrade scenarios and how you can leverage Oracle GoldenGate and Oracle Data Guard technologies to achieve your upgrade goals. In addition, you will learn how to take advantage of Oracle Advanced Customers Support Services to help you complete your business-critical upgrades while achieving high availability.

Cross-Platform Database Upgrades with Oracle GoldenGate (CON4286)

Thursday 2:00PM Moscone South – 305

As every year GoldenGate team offers a set of strong hands-on-labs. “Deep Dive into Oracle GoldenGate” hands-on-lab’s focus is to provide an overview of the Oracle GoldenGate architecture and then allow attendees to instantiate a secondary database that can be used for disaster recovery or a reporting instance. Hope you can join this session and see firsthand how easy Oracle GoldenGate is to use and how it can be a very valuable technology solution for your organization.

Deep Dive into Oracle GoldenGate (HOL10026)

Thursday 11:00AM Marriott Marquis – Nob Hill AB

Oracle GoldenGate customers looking to take control of their Oracle GoldenGate deployments must attend our Hands-On-Lab session “Deep Dive into Oracle GoldenGate Monitor”. This lab will focus on our complementary product Oracle GoldenGate Monitor, designed to deliver end-to-end visibility into Oracle GoldenGate instances across the enterprise. Attendees will learn about key features including automatic heterogeneous solution discovery, persisted monitoring points, display of replication elements, lag graphs, and creation of alerts.

Deep Dive into Oracle GoldenGate Monitor (HOL10128)

Thursday 12:30 PM - 1:30 PM PT-- Marriott Marquis - Nob Hill AB

I also would like to remind you that you can visit GoldenGate product management in the following demo pods to ask your questions:

Oracle GoldenGate and Oracle Data Integrator – POD 3412

Monitoring Oracle GoldenGate for End-to-End Visibility – POD 3493

Oracle GoldenGate for Oracle Applications – POD 3494

Oracle GoldenGate: Real-Time Transactional Database Replication – POD 3518

Next week you will hear from me and our PM team about what was discussed in these sessions. Stay tuned for more, and enjoy OpenWorld 2013 next week!

 

Monday Sep 09, 2013

Boosting Oracle Applications with Oracle GoldenGate: Hear from Masterminds

In recent blogs we have mentioned new data integration solutions and resources for Oracle Applications. Oracle Data Integration products provide incremental value, the AppAdvantage, to Oracle Application users by maximizing performance and availability, and by enabling real-time insight.

Many Oracle Applications customers such as Herbalife and BT, have seen great results from GoldenGate’s solutions. Herbalife used GoldenGate for offloading Oracle E-Business Suite operational reporting to an ODS. As a result the company increased performance significantly while improving the business reports using real-time data. BT used GoldenGate for upgrading its Siebel CRM system to the latest version without impacting operations, with minimized risk, and improved system performance by 5%.

There are many more customers who achieved major performance, availability, and improved insight. This year at Oracle OpenWorld we decided to showcase GoldenGate’s strong offering for Oracle Applications in a customer panel:

A Panel of Masterminds: Perspectives from Oracle GoldenGate Customers

Tuesday, Sep 24, 3:45 PM - 4:45 PM - Moscone West – 2024

In this session industry leaders, Smuckers , Veolia Water, and Land O’Lakes, will talk about their use of GoldenGate for Oracle Applications including E-Business Suite and JD Edwards. The panelists will discuss the best practices and tips for using GoldenGate’s real-time data replication capabilities in offloading reporting to a reporting environment and migrating or upgrading their application environment.

If you attended previous OpenWorld’s customer panels within the Data Integration track, you know there will be great depth in the discussion. For example, last year we had two customer panels for GoldenGate. In one panel St. Jude Medical, Equifax, and Bank of America, presented how they achieved eliminated planned downtime for critical systems using GoldenGate, and in another panel Comcast, Raymond James, and Turk Telekom discussed operational reporting solutions using GoldenGate. 

Both sessions had great audience participation and I expect this year’s panels will be very interactive too.

Another related session on using GoldenGate for Oracle Applications is going to be delivered by the product management team. GoldenGate PM will be joined with PMs from Oracle  BI Applications and Oracle Coherence teams. The team will present latest  updates such as tight integration with Oracle Coherence, and solutions for Oracle BI Applications, E-Business Suite, Siebel CRM, ATG Web Commerce and more.

Powering Solutions for Oracle Applications with Oracle GoldenGate

Wednesday, Sep 25, 11:45 AM - 12:45 PM - Moscone West - 2024

 I hope those of you who will be at OpenWorld will join these sessions. If you will not be at OpenWorld, you can visit our new resource center to download free screencasts and white papers on our solutions for Oracle Applications.

Wednesday Sep 04, 2013

Extending the Value of Oracle Applications with Oracle Data Integration

Can you imagine a business operating without any application software? Not anymore. Transactional applications are in the center of business operations in today's digital world. With a wide range of offering, Oracle Applications bring customers the latest technology and make IT a strategic differentiator for their business. These applications’ data is also a major asset to the organization and critical to the health of the business. There are several ways Oracle's data integration solutions help Oracle Applications customers drive more value out of their application investments. 

A key method to maximize return on business applications is to connect their data to gain a unified view. A complete and up-to-date view enables businesses to make better business decisions and meet customers’ needs more efficiently. This is where Oracle Data Integration comes in. By connecting applications at the data-layer, at any latency, Oracle’s data integration products enable Oracle Applications users to find answers that takes their business to the next level. Oracle Data Integrator (ODI) , the flagship product for bulk data movement and transformation, has a long list of Knowledge Modules for Oracle Applications to leverage best practices in loading, transforming, or integrating data for that specific application. Oracle Data Integrator is also embedded in the Oracle BI Applications 11.1.1.7.1 release. With its tight integration with Oracle GoldenGate, ODI enables Oracle BI Applications users to leverage GoldenGate’s real-time data integration capabilities for performing analysis with up-to-date data.

In addition to removing data silos, IT organizations need to meet users’ expectations for high performance and continuous operations. With a single real-time data replication software platform, GoldenGate addresses both of these requirements. Oracle E-Business Suite, Oracle PeopleSoft Applications, JD Edwards, Siebel CRM, ATG Web Commerce customers can use GoldenGate to offload queries from production systems to reduce overhead and increase performance. In addition, GoldenGate is certified for enabling application upgrade for Siebel CRM, JD Edwards, and Communications Billing and Revenue Management without interrupting business operations. With bidirectional and heterogeneous real-time data replication GoldenGate also eliminates planned downtime for database, operating system, and hardware migration projects.

You can find out how Oracle Data Integration can help your Oracle Application deployment by visiting our new resource center: Powering Oracle Applications with Next-Generation Data Integration.

I also would like to invite you to learn more about how Oracle Fusion Middleware offers incremental value to Oracle Applications customers, which we call Oracle AppAdvantage, with innovative, best-of-breed solutions that simplify IT, provide a competitive edge, and enable innovation. You can read about Oracle AppAdvantage Story to discover how Oracle AppAdvantage helps align IT and business initiatives.

Thursday Jun 13, 2013

Near Zero Downtime Upgrades for Oracle Communications Billing and Revenue Management

Billing application is one of the key systems for a communications company. It is critical for not only revenue generation but also for customer experience.  Oracle Communications Billing and Revenue Management (BRM) solutions offers a flexible and reliable solution that helps service providers maximize customer value and profitability, and enhance business agility. Oracle BRM supports new business models including cloud, machine to machine (M2M), and mobile virtual network operators (MVNO).  Many of the world's leading, and innovative service providers—including France Telecom, Vodafone, Swisscom, Savvis, Sirius XM Satellite Radio and Nintendo, rely on the BRM application for their critical billing operations.

When it comes to upgrading a major system, such as BRM, things may get a bit tricky. Until recently there were only two approaches to upgrading BRM systems: In-place upgrades and the parallel system run. The in-place upgrade approach means the current BRM system would be shut down and brought back up after it is upgraded to the latest release of BRM. In addition to downtime, it puts heavy risk on the business. The parallel system run approach is an attempt in having two BRM systems running live in parallel. Unfortunately, this approach could only keep a portion of the data in-sync between the two systems as not all data feeds could be applied to both databases. Both of these approaches to upgrade resulted in downtime, which is not desirable for a system that drives revenue and impacts customer experience directly. 

Oracle GoldenGate offers a third approach to upgrade BRM systems and fortunately this new solution delivers near zero downtime and minimized risk.  Using GoldenGate's real-time data replication capability IT teams can create a full copy of the new BRM system on the latest software release without impacting the current BRM system. End users can use the old version, while a parallel system can be upgraded to the newest version of the release, kept in synch in real time with the active database, and tested thoroughly without time pressure before end users switch over to the upgraded BRM instance. GoldenGate's failback option also mitigates the risk to the business during the upgrade process. Oracle GoldenGate’s unique software platform does not require any changes to the source BRM system and uses minimal system resources. The solution supports BRM clients running BRM 7.2 or higher.

This is a very powerful solution for BRM users and we decided to explain the solution in depth via a screencast to help BRM users understand the new method better. If you have a mission-critical BRM system I highly recommend watching the screencast below to learn the detailed implementation steps.

You can watch the screencast also on Oracle Media Network, or Oracle's YouTube account. We have a white paper Near Zero Downtime Upgrade for Oracle Communications Billing and Revenue Management (BRM) Application that you can download for more information as well.

Thursday Mar 28, 2013

More Complete, Open, Real Time.

If you have been following our blogs you know about the strength of our data integration products, and our passion about helping our customers achieve their information management goals. Our customer testimonials in all kinds of solutions have proven our leadership in both data integration and data availability spaces. We decided to put our long story in a short video and incorporate examples of impressive benefits our customers achieve every day.

Here is the short video we came up with about Oracle Data Integration product family. Please take a look and let me know what you think.


To learn more about Oracle Data Integration products please download our free resources.

Thursday Mar 07, 2013

5 New Data Integration Requirements for Today’s Data-Driven Organizations

How are the latest technology trends affecting data integration requirements? Read about the 5 key data integration requirements and Oracle's Data Integration product strategy in meeting these requirements.[Read More]

Wednesday Feb 27, 2013

Support for Timestamp in Oracle GoldenGate for Sybase

This article explains the Sybase timestamp support in Oracle GoldenGate.[Read More]

Monday Feb 11, 2013

Setting up a One-way Replication from Sybase to Oracle

This blog provides an example on how to set up one-way replication from Sybase to Oracle.[Read More]

Tuesday Feb 05, 2013

Deeper Look into Integrated Capture for Oracle Database

With Oracle GoldenGate 11gR2 we announced a new "Integrated Capture" process for the Oracle Database. In our launch webcast back in September'12 our product team presented this feature along with other key features such as intelligent conflict management, advanced encryption, global deployment support and more.  You can watch that webcast on demand here.

We now have a recorded presentation with more details on this new feature. You can watch the GoldenGate Integrated Capture screencast to get a deeper look into this feature.

Integrated Capture for Oracle Database is very unique in the industry. This feature enables a deeper integration into the database engine and serves as the foundation for new features GoldenGate for Oracle Database will be adding  in the future.

As we mentioned in our recent Maximum Availability with Oracle GoldenGate webcast, GoldenGate's Classic Capture is still available for both Oracle Database, as well as other non-Oracle databases GoldenGate supports. Below is an overview of supported Oracle Database versions and features for both Classic and Integrated Capture.

Also please make sure to check out our new resources on GoldenGate's continuous availability solutions to learn more about Integrated Capture feature and other key new features.

Friday Feb 01, 2013

Installing Oracle GoldenGate for Sybase

Though documented in the Oracle GoldenGate for Sybase Installation Guide, there are still many questions on how to install Oracle GoldenGate for Sybase. In this blog I want to walk you through the setup steps and discuss the tip and tricks in the installation process.

[Read More]

Thursday Jan 10, 2013

Maximum Availability with Oracle GoldenGate Webcast: On Demand Link & FAQ

Last month we had a live webcast on a hot topic: Maximum Availability with Oracle GoldenGate. The webcast presentation focused on how Oracle GoldenGate can help achieve maximum availability for Oracle Database and other major databases. This webcast was very useful in answering a frequently asked question around GoldenGate's role for Oracle Database Maximum Availability Architecture (MAA) and when to use Oracle GoldenGate vs Active Data Guard. Product experts, Joe Meeks from Oracle Database High Availability product management team and Nick Wagner from Oracle GoldenGate product management team, addressed this question for us. Joe and Nick presented GoldenGate’s key solutions within MAA, and when to use which product along with Integrated Capture and Automated Conflict Management features of GoldenGate 11gR2. If you missed this event I highly recommend watching it on demand via the following link.

Watch On Demand:Maximum Availability with Oracle GoldenGate.

We also recorded a short podcast on this topic. Oracle GoldenGate 11gR2 for Maximum Availability

In the live webcast we had a very interactive audience who submitted over 100 questions during the event. Joe and Nick answered the most commonly asked questions about GoldenGate’s use cases and technology. Here are a few of the questions that we did not have time to answer during the event, along with the answers from the PM team.

  • Can I use the target database as warehouse for select only. If I were to allow users to this target, are there steps to ensure both source and target databases remain in sync?

 Yes you can use the target for read only or select only operations. Yes, we can do bi-directional active-active replication if you want to allow users to make changes to the target system. We can replicate those back to the source.

  • Can Integrated Capture be run on Oracle Database Standard Edition?

Yes, but all of the features that are only supported by Integrated Capture are only available with Oracle Database Enterprise Edition.

  •  Is it possible to capture database transactions from a source database using GoldenGate and publish them as messages into   a JMS queue?

Yes, GoldenGate can capture from and deliver to JMS queue. Please see our page for Java Adapter for more info. 

  • Can GoldenGate be used in environments where a number of tables do not have primary keys?

Yes. In tables without primary keys, we will use all non-LOB columns in the where clause for updates and deletes and then use ROWNUM = 1.

  • Is there a webinar that shows how to set up Oracle GoldenGate?

 Oracle GoldenGate Youtube channels has many useful videos and labs including “Oracle GoldenGate Fundamentals and How Oracle GoldenGate Works” and “Oracle GoldenGate Deep Dive Hands-on Labs” in 3 part series. You can browse and watch them here. Please check out GoldenGate training sessions with Oracle University as well.

I highly recommend subscribing to GoldenGate’s Youtube channel along with joining the GoldenGate Facebook and Twitter communities to get regular updates on the product.

Monday Dec 10, 2012

Maximum Availability with Oracle GoldenGate

Oracle Database offers a variety of built-in and optional products for maximum availability, and it is well known for its robust high availability and disaster recovery solutions. With its heterogeneous, real-time, transactional data movement capabilities, Oracle GoldenGate is a key part of the Maximum Availability Architecture for Oracle Database.

This week on Thursday Dec. 13th we will be presenting in a live webcast how Oracle GoldenGate fits into Oracle Database Maximum Availability Architecture (MAA). Joe Meeks from the Oracle Database High Availability team will discuss how Oracle GoldenGate complements other key products within MAA such as Active Data Guard. Nick Wagner from GoldenGate PM team will present how to upgrade to latest Oracle Database release without any downtime. Nick will also cover 2 new features of  Oracle GoldenGate 11gR2:  Integrated Capture for Oracle Database and Automated Conflict Detection and Resolution. Nick will provide in depth review of these new features with examples.

Oracle GoldenGate also offers maximum availability for non-Oracle databases, such as HP NonStop, SQL Server, DB2 (LUW, iSeries, or zSeries) and more. The same robust, reliable real-time, bidirectional data movement capabilities apply to all supported databases.

 I'd like to invite you to join us on Thursday Dec. 13th 10am PT/1pm ET to hear from the product experts on how to use GoldenGate for maximizing database availability and to ask your questions. You can find the registration link below.

Webcast: Maximum Availability with Oracle GoldenGate

Thursday Dec. 13th 10am PT/1pm ET

Look forward to another great webcast with lots of interaction with the audience.

About

Learn the latest trends, use cases, product updates, and customer success examples for Oracle's data integration products-- including Oracle Data Integrator, Oracle GoldenGate and Oracle Enterprise Data Quality

Search

Archives
« April 2014
SunMonTueWedThuFriSat
  
2
3
5
6
7
8
9
10
12
13
14
17
18
19
20
21
23
24
25
26
27
28
29
30
   
       
Today