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.

Wednesday Dec 11, 2013

GoldenGate 12c - What is Coordinated Delivery?

In Oracle GoldenGate 12c, the parallel apply is improved with two features: Integrated Delivery and Coordinated Delivery. Different from the Integrated Delivery, Coordinated Delivery is not limited to Oracle Database.This blog discusses the new Coordinated Delivery feature by answering two questions:


  • Why do I need Coordinated Delivery?

  • What is Coordinated Delivery?
  • [Read More]

    Thursday Dec 05, 2013

    Are You Ready for the Future?

    Have you wondered where you and your organization will be in the future as the information technology advances in an unprecedented way? Have you wondered whether your company, or team, is equipped with the right tools and strategy to be ahead of competition, as everything around us changes? If yes, you are not alone. If not, you should. 

    When it comes to leveraging data and creating opportunities for innovation and growth, data integration is a critical technology that sits in the center of many key initiatives: big data analytics, cloud integration, modernization to name a few. Many industry leaders that excel and continue to innovate are the ones that keep an eye on how they collect and distribute their data.They know the value of turning data into an asset, rather than a cost driver.

    With the new release of Oracle Data Integrator 12c and Oracle GoldenGate 12c, Oracle established itself as the leader in the data integration and replication space.  And how Oracle differentiates its offering is now highlighted in an interactive e-book: The Path to the Future.

    In this e-book we told Oracle Data Integration product family's story through the words of our customers; including Starwood Hotels and Resorts, BT, Herbalife, SK Telecom, MediSwitch, Aria Systems, MegaFon and others.  The e-book reveals how Oracle Data Integration products help you stay ahead of the curve by integrating any data, anywhere, at the speed of thought, with maximum performance and availability,  and full trust in its high quality.  You will also find out how the latest 12c release helps you keep pace with the latest trends while improving developer productivity and performance. 

    Take a look at our new interactive e-book and let us know what you think!


    Thursday Nov 21, 2013

    Recap of Oracle GoldenGate 12c and Oracle Data Integrator 12c Launch Webcast

    Last week we had a great video webcast for Oracle GoldenGate 12c and Oracle Data Integrator 12c. Our development executives, Brad Adelberg and Tim Hall,  talked about the new features and how the new release helps with delivering future-ready data integration solutions with extreme performance and high IT productivity. 

    If you missed the webcast you can watch it on demand via the following page:
    On-Demand Video Webcast: Introducing 12c for Oracle Data Integration

    In previous blogs we have talked about the new features of Oracle GoldenGate 12c and Oracle Data Integrator 12c, so I am not going to repeat them here. But worth repeating are what our customers and partners say about the new 12c release.

    SolarWorld’s Senior Database Administrator, Russ Toyama was in the studio with our executives for the launch webcast, and Russ discussed their GoldenGate implementation for SolarWorld's manufacturing process. SolarWorld is the largest U.S. solar panel manufacturer for more than 35 years and needed operational intelligence to continuously improve the quality of its products, while ensuring the systems operate with high performance and stability.

    SolarWorld uses GoldenGate to move data from multiple manufacturing databases into a single decision support system database in real time, freeing up the OLTP systems for transaction processing, which improves their performance and stability. The DSS database is very flexible in meeting reporting needs, and provides a comprehensive view of multiple manufacturing processes. This provides the traditional roles of reporting and engineering analysis to continuously improve product quality, yield and efficiency, and enables real time monitoring of the production manufacturing process. Using this real-time monitoring capability SolarWorld is able to detect the deviations from the norm right away, and take action to remedy or understand the situation. This not only improves production quality, but also improves cost management. The manufacturing process is a series of steps building upon the previous, so if there is an issue, it needs to be corrected as soon as possible to prevent waste and reduce manufacturing costs.

    For GoldenGate 12c we heard from Surren Partabh, CTO for Technology Services for BT. Surren explained the role of Oracle GoldenGate for their private cloud initiative and how they have improved customer experience and availability, while managing costs as well.  Surren highlighted that Oracle's data integration product family is one of the cornerstones for BT"s cloud migration project and enable to migrate to cloud simply, and in an agile manner. BT used GoldenGate to build a replication hub to help with the migration from legacy systems to the cloud with a reliable fallback strategy. Surren also commented on the tight integration between GoldenGate 12c and Oracle Data Integrator 12c,  saying that it is a "step in the right direction" as it simplifies the actual installation, configuration, management, and monitoring of solutions. You can watch the interview with BT's Surren Partabh here.

    In the launch webcast we also heard from Mark Rittman, CTO of Rittman Mead Consulting. Mark talked about the Oracle Data Integrator 12c new features in great depth, given that he was closely involved with the Beta testing program. Mark shared his opinion that the new flow-based design interface is the most critical feature of this 12c release and will bring major productivity gains for developers. He added that interoperability with Oracle Warehouse Builder for easier migration and tighter integration with Oracle GoldenGate are very valuable for customers. Mark also discussed the new release of Oracle BI Applications and how its use of Oracle Data Integrator for data movement and transformations simplifies life for Oracle BI Apps customers.  The complete interview with Mark Rittman is available for you as well.

    If you missed the launch webcast last week, I hope you take the time to watch it on demand and discover how Oracle has changed the data integration and replication technology space with Oracle Data Integrator 12c and Oracle GoldenGate 12c. For more information including white papers and podcasts you can also download free resources.

    Wednesday Oct 30, 2013

    Replicating between Cloud and On-Premises using Oracle GoldenGate

    Do you have applications running on the cloud that you need to connect with the on premises systems. The most likely answer to this question is an astounding YES!  If so, then you understand the importance of keep the data fresh at all times across the cloud and on-premises environments. This is also one of the key focus areas for the new GoldenGate 12c release which we announced couple of week ago via a press release.

    Most enterprises have spent years avoiding the data “silos” that inhibit productivity. For example, an enterprise which has adopted a CRM strategy could be relying on an on-premises based marketing application used for developing and nurturing leads. At the same time it could be using a SaaS based Sales application to create opportunities and quotes. The sales and the marketing teams which use these systems need to be able to access and share the data in a reliable and cohesive way. This example can be extended to other applications areas such as HR, Supply Chain, and Finance and the demands the users place on getting a consistent view of the data.

    When it comes to moving data in hybrid environments some of the key requirements include minimal latency, reliability and security:

    • Data must remain fresh. As data ages it becomes less relevant and less valuable—day-old data is often insufficient in today’s competitive landscape.
    • Reliability must be guaranteed despite system or connectivity issues that can occur between the cloud and on-premises instances.
    • Security is a key concern when replicating between cloud and on-premises instances. There are several options to consider when replicating between the cloud and on-premises instances.

    Option 1 – Secured network established between the cloud and on-premises

    A secured network is established between the cloud and on-premises which enables the applications (including replication software) running on the cloud and on-premises to have seamless connectivity to other applications irrespective of where they are physically located.

    Option 2 – Restricted network established between the cloud and on-premises

    A restricted network is established between the cloud and on-premises instances which enable certain ports (required by replication) be opened on both the cloud and on the on-premises instances and white lists the IP addresses of the cloud and on-premises instances.

    Option 3 – Restricted network access from on-premises and cloud through HTTP proxy

    This option can be considered when the ports required by the applications (including replication software) are not open and the cloud instance is not white listed on the on-premises instance. This option of tunneling through HTTP proxy may be only considered when proper security exceptions are obtained.

    Oracle GoldenGate

    Oracle GoldenGate is used for major Fortune 500 companies and other industry leaders worldwide to support mission-critical systems for data availability and integration. Oracle GoldenGate addresses the requirements for ensuring data consistency between cloud and on-premises instances, thus facilitating the business process to run effectively and reliably.

    The architecture diagram below illustrates the scenario where the cloud and the on-premises instance are connected using GoldenGate through a secured network

    In the above scenario, Oracle GoldenGate is installed and configured on both the cloud and the on-premises instances. On the cloud instance Oracle GoldenGate is installed and configured on the machine where the database instance can be accessed. Oracle GoldenGate can be configured for unidirectional or bi-directional replication between the cloud and on premises instances.

    The specific configuration details of Oracle GoldenGate processes will depend upon the option selected for establishing connectivity between the cloud and on-premises instances. The knowledge article (ID - 1588484.1) titled ' Replicating between Cloud and On-Premises using Oracle GoldenGate' discusses in detail the options for replicating between the cloud and on-premises instances. The article can be found on My Oracle Support.

    To learn more about Oracle GoldenGate 12c register for our launch webcast where we will go into these new features in more detail.   You may also want to download our white paper "Oracle GoldenGate 12c Release 1 New Features Overview"

    I would love to hear your requirements for replicating between on-premises and cloud instances, as well as your comments about the strategy discussed in the knowledge article to address your needs. Please post your comments in this blog or in the Oracle GoldenGate public forum - https://forums.oracle.com/community/developer/english/business_intelligence/system_management_and_integration/goldengate

    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"

    Thursday Oct 17, 2013

    Welcome Oracle Data Integration 12c: Simplified, Future-Ready Solutions with Extreme Performance

    The big day for the Oracle Data Integration team has finally arrived! It is my honor to introduce you to Oracle Data Integration 12c.

    Today we announced the general availability of 12c release for Oracle’s key data integration products: Oracle Data Integrator 12c and Oracle GoldenGate 12c. The new release delivers extreme performance, increase IT productivity, and simplify deployment, while helping IT organizations to keep pace with new data-oriented technology trends including cloud computing, big data analytics, real-time business intelligence. With the 12c release Oracle becomes the new leader in the data integration and replication technologies as no other vendor offers such a complete set of data integration capabilities for pervasive, continuous access to trusted data across Oracle platforms as well as third-party systems and applications.

    Oracle Data Integration 12c release addresses data-driven organizations’ critical and evolving data integration requirements under 3 key themes:

    • Future-Ready Solutions
    • Extreme Performance
    • Fast Time-to-Value

          There are many new features that support these key differentiators for Oracle Data Integrator 12c and for Oracle GoldenGate 12c. In this first 12c blog post, I will highlight only a few:·

    Future-Ready Solutions to Support Current and Emerging Initiatives: Oracle Data Integration offer robust and reliable solutions for key technology trends including cloud computing, big data analytics, real-time business intelligence and continuous data availability. Via the tight integration with Oracle’s database, middleware, and application offerings Oracle Data Integration will continue to support the new features and capabilities right away as these products evolve and provide advance features.

    E    Extreme Performance: Both GoldenGate and Data Integrator are known for their high performance. The new release widens the gap even further against competition. Oracle GoldenGate 12c’s Integrated Delivery feature enables higher throughput via a special application programming interface into Oracle Database. As mentioned in the press release, customers already report up to 5X higher performance compared to earlier versions of GoldenGate. Oracle Data Integrator 12c introduces parallelism that significantly increases its performance as well.

    Fast Time-to-Value via Higher IT Productivity and Simplified Solutions:  Oracle Data Integrator 12c’s new flow-based declarative UI brings superior developer productivity, ease of use, and ultimately fast time to market for end users.  It also gives the ability to seamlessly reuse mapping logic speeds development.Oracle GoldenGate 12c ‘s Integrated Delivery feature automatically optimally tunes the process, saving time while improving performance.

    This is just a quick glimpse into Oracle Data Integrator 12c and Oracle GoldenGate 12c. On November 12th we will reveal much more about the new release in our video webcast "Introducing 12c for Oracle Data Integration". Our customer and partner speakers, including SolarWorld, BT, Rittman Mead will join us in launching the new release. Please join us at this free event to learn more from our executives about the 12c release, hear our customers’ perspectives on the new features, and ask your questions to our experts in the live Q&A.

    Also, please continue to follow our blogs, tweets, and Facebook updates as we unveil more about the new features of the latest release.

    Wednesday Sep 25, 2013

    Oracle GoldenGate AppAdvantage in Action at Land O’Lakes, Smuckers, and Veolia Water

    On Tuesday at OpenWorld we had the honor to host a panel with GoldenGate customers: Land O’Lakes, Smuckers, and Veolia Water. Besides giving us yummy nutrition and healthy water, these companies have another aspect in common. They all use GoldenGate to boost their ERP application.

    Veoila Water’s Pierre Kerrinckx came from their HQ in France for this panel and spoke to us about the database migration project for their JD Edwards ERP system. Using GoldenGate Veolia was able to migrate from Oracle Database 10gR2 on Aix 5.3 Oracle 10g R2 to Oracle Database Aix 7.1 Oracle 11g R2 and did so with only 2 hours of interruption to JD Edwards end users. Pierre mentioned, the other benefit of GoldenGate was the ability to switch back to the old environment if needed.

    Land O’Lakes’ Mark Kohls talked about their use of GoldenGate for their JD Edwards ERP system supporting the Purina business line. Land O’Lakes had to migrate enterprise-wide JDE Xe ERP system to new database and application server platform with minimal downtime to the business. While their goal was to have less than 8 hours of downtime, with GoldenGate they limited downtime to 30 minutes.

    Both Veolia and Land O’Lakes used GoldenGate in an Active-Passive fashion, meaning that the new environment was not used simultaneously with the old one, and the users migrated all at once. GoldenGate provides Active-Active migration model too, if the company prefers to do a phased migration and truly zero downtime.

    Smuckers's Neal Indermuhle had a different story to share. He talked about operational reporting for their critical Oracle E-Business Suite and how using Oracle GoldenGate helped the company to achieve the near real-time data they need in making critical business decisions. Neil shared that the replication latency averages less than 10 seconds and Oracle GoldenGate Veridata is leveraged to validate synchronization.

    I would like to thank Pierre, Mark, and Neal for sharing their best practices, and taking tough questions from the audience. If you would like to learn more about Oracle GoldenGate’s solutions for JD Edwards, E-Business Suite and other key Oracle Applications please check out our new resource center with recorded video presentations and detailed white papers.

    Before I get ready for another full day at OpenWorld tomorrow I would like to leave you with the key GoldenGate sessions we have lined up for Wednesday:

    Best Practices for Integrating Oracle GoldenGate with Oracle Active Data Guard (CON8500)
    Wednesday, September 25, 2013 at 10:15AM-11:15AM PT
    Moscone South – 104

    Powering Solutions for Oracle Applications with Oracle GoldenGate (CON8897)
    Wednesday, September 25, 2013 at 11:45AM-12:45PM PT
    Moscone West – 2024

    Integrated Apply for Oracle Database: Scalable Replication with Oracle GoldenGate (CON8198)
    Wednesday, September 25, 2013 at 5:00PM-6:00PM PT
    Moscone North – 131

    Monday Sep 23, 2013

    At the End of the First Day of Data Integration Track at OpenWorld

    A long, but exciting Monday at Oracle OpenWorld 2013 ended for the Oracle Data Integration product management team. We had a full day with many key product strategy sessions.  Mark Hurd's keynote set the tone for the Data Integration sessions as well. Mark focused on big data analytics and the changing consumer expectations. Especially real-time insight is a key theme for Oracle overall and data integration products. In Mark Hurd's keynote we heard from key customers, such as Airbus and Thomson Reuters, how real-time analysis of operational data including machine data creates value, in some cases even saves lives. Thomas Kurian gave a deeper look into Oracle's big data and fast data solutions.

    Brad Adelberg, VP of Development, presented Oracle’s Data Integration product strategy based on these key trends that we heard in the keynotes. Brad talked about how Oracle's data integration products address the new data integration requirements that evolved with cloud computing, big data, and changing consumer expectations and how they set the key themes in our products’ road map. Brad explained why and how fast-time to value, high-performance and future-ready solutions are the top focus areas for product development. If you were not able to attend OpenWorld or this session I recommend reading the white paper : Five New Data Integration Requirements and How to Meet them with Oracle Data Integration, which provides an in-depth look into how Oracle addresses the new trends in the DI market.

    Following Brad’s session, Nick Wagner provided in depth review of Oracle GoldenGate’s latest features and roadmap. Nick discussed how Oracle GoldenGate’s tight integration with Oracle Database sets the product apart from the competition. We also heard that heterogeneity of the product is still a major focus for GoldenGate’s development and there will be more news on that front when there is a major release.

    After GoldenGate’s product strategy session, Denis Gray from the PM team presented Oracle Data Integrator’s product strategy session, talking about the latest and greatest on ODI. Another good session was delivered by long-time GoldenGate users, Comcast.  Jason Hurd and Amit Patel of Comcast talked about the various use cases they deploy Oracle GoldenGate throughout their enterprise,from database upgrades, feeding reporting systems,  to active-active database synchronization.  The Comcast team shared many good tips on how to use GoldenGate for both zero downtime upgrades and active-active replication with conflict management requirement.

    We ended the day with a wonderful award ceremony for Oracle Excellence Awards for Oracle Fusion Middleware Innovation. The ceremony was held in the Yerba Buena Center for the Arts. Congratulations to Royal Bank of Scotland and Yalumba Wine Company, the winners in the Data Integration category. You can find more information on the award and the winners in our previous blog post: 2013 Oracle Excellence Awards for Fusion Middleware Innovation…

    The demo pods for data integration products had a busy day as well. You can see from the photos below our experts stayed busy talking to attendees, yet they stopped a moment to smile to my camera.

    If you have any questions about sessions you’ve missed or general questions about our products you can find us in Moscone South on both sides of the expo hall within Oracle Database and Oracle Fusion Middleware demo pods. Also, don’t forget to add the following sessions to your schedule for Tuesday.

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

    Tuesday, September 24, 2013 at 3:45PM-4:45PM PT

    Moscone West – 2024

    Optimize Oracle Active Data Guard/Oracle GoldenGate: Oracle Database 12c Global Data Services (CON8704)

    Tuesday, September 24, 2013 at 5:15PM-6:15PM PT

    Moscone South – 200

    Combining Oracle Data Integrator and Oracle GoldenGate (HOL10144)

    Tuesday, September 24, 2013 at 3:45PM-4:45PM PT

    Marriott Marquis – Nob Hill AB

    For a full overview of the Data Integration track please check out Focus On Data Integration.

    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.

    Friday Jun 28, 2013

    Upgrading Oracle Siebel CRM Application Without Downtime

    Oracle’s Siebel Customer Relationship Management (CRM) software helps organizations differentiate their businesses to achieve top- and bottom-line growth. Siebel CRM delivers comprehensive solutions that are tailored to more than 20 different industries. As Siebel CRM implementations have evolved into mission critical, operational business processes that must operate 24/7, companies are finding it increasingly difficult to afford the downtime typically required to perform an in-place upgrade. Without these upgrades, businesses loose out on critical new features and functionality.


    With Oracle GoldenGate, customers don’t have to choose between upgrades and outages. Oracle GoldenGate allows Siebel CRM customers to perform upgrades with zero downtime. Now Siebel customers can always take advantages of the latest innovations in customer relationship management without having to worry about potential lost revenue due to downtime.


    Oracle GoldenGate provides three different deployment models for Siebel CRM zero downtime upgrades that are designed to meet differing customer requirements. These range from a basic unidirectional model, which is designed to work out-of-the-box, to the most sophisticated active-active model for phased migrations.


    If you have mission-critical Siebel CRM implementations I recommend that you watch the screencast below to learn how you can begin taking advantage of all the latest Siebel enhancements without having any downtime.

    This screencast is also available on Oracle Media Network and Oracle's YouTube channel. For even more details I recommend reading the whitepaper Upgrading Siebel CRM with Zero Downtime .

    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.

    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
    22
    23
    24
    25
    26
    27
    28
    29
    30
       
           
    Today