Friday Apr 04, 2014

Turning Big Data into Real-Time Action for a Greater Customer Experience

The power shifted to us, consumers. The digital revolution allows us to access broader set of services, and communicate without boundaries. Today we demand more and better choices in a competitive market, putting pressures on businesses to catch up with our expectations.

By offering differentiated and improved experience to their customers organizations see that they can drive revenue growth via higher loyalty, and improved brand perception.  Because technology is a key enabler for delivering superb and consistent customer experience across all touchpoints, in recent years customer experience solutions have become a top priority for CIOs. Thanks to the availability of big data analytics, organizations can now analyze a broader variety of data, rather than a few basic data points, and gain deeper insight into their customers and operations. In turn, this deeper insight helps align their business to provide a seamless customer experience.

In our digital, fact-paced world we produce large volumes of data with unprecedented velocity. This data contains perishable value that requires fast capture, analysis, and action to be able to influence the operations or the interaction with the customer. Otherwise the insight or action may become irrelevant, which decreases the value for the customer and the organization significantly.  To extract the maximum value from highly dynamic and perishable data, you need to process much faster and take timely action. This is the main premise behind Oracle's Fast Data solutions, which we have discussed in previous blogs and webcasts.

Real-time data integration and analytics play a crucial role in our new world of big and fast data. Organizations that look into leveraging  big data to create greater customer experience, need to evaluate the analytical foundation behind their customer-facing systems and resulting interactions, and determine whether they can improve how and when they collect, analyze, and act on their ever-growing data assets.

In our next webcast my colleague Pete Schutt in the Oracle Business Analytics team and I will discuss how organizations can create value for their customers using real-time customer analytics, and how to leverage big data to build a solid business analytics foundation using the latest features of Oracle Data Integration and Oracle Business Analytics. We will provide multiple customer examples for different solution architectures.

Join us on April 15th 10am PT/ 1pm ET by registering via the link below.

Turning Big Data into Real-Time Action for a Greater Customer Experience

Tuesday, April 15th 10am PT/ 1pm ET

Until we meet at this webcast, please review my related article on this topic published on DBTA earlier this year:

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 Jan 22, 2014

Deep Dive Into Oracle Data Integrator Changed Data Capture Leveraging Oracle GoldenGate

Check out this blog post below from Christophe – first the details related to Oracle Data Integrator’s (ODI) Journalizing Knowledge Modules (JKMs) as well as a deeper dive into the particulars around the seamless out-of-the-box integration between Oracle Data Integrator (ODI) and Oracle GoldenGate.

http://www.ateam-oracle.com/understanding-the-odi-jkms-and-how-they-work-with-oracle-goldengate/

Happy reading!

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"

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

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!

 

Thursday Sep 12, 2013

Stream Relational Transactions into Big Data Systems

Are you one of the organizations adopting ‘big data systems’ to manage and analyze a class of data typically referred to as big data? If so, you may know that big data includes data that could be structured, semi-structured or unstructured, each of which originates from a variety of different sources.  Another characterization of big data is described by the data's volume, velocity, and veracity. Due to its promise to help harness the data deluge we are faced with, the adoption of big data solutions is becoming quite pervasive. In this blog post I’d like discuss how to leverage Oracle GoldenGate’s real-time replication for big data systems.

The term 'big data systems' is an umbrella terminology used in general to discuss a wide variety of technologies each of which is used for a specific purpose. Broadly speaking, big data technologies address the needs for batch, transactional, and real-time processing requirements. Using the appropriate big data technology is highly dependent on the use case being addressed.

While gaining business intelligence from transactional data continues to be a dominant factor in the decision making process, businesses have realized that gaining intelligence from other forms of data they have been collecting will enable them achieve a more complete view, address additional business objectives, and lead to better decision making. The following table illustrates some examples of various industry verticals, forms of data, and the objective the business attempts to achieve using the other forms of data.

Industry

Data

Objective

Healthcare

Practitioner’s notes, machine statistics.

Best practices and reduced hospitalization.

Retail

Weblog, click streams.

Micro-segmentation recommendations.

Banking

Weblogs, fraud reports.

Fraud detection, risk analysis.

Utilities

Smart meter reading, call center data.

Real-time and predictive utilization analysis.

Role of transactional data

When using other forms of data for analytics, better contextual intelligence is obtained when the analysis is combined with transactional data. Especially low-latency transactional data brings additional value to dynamically changing operations that day-old data cannot deliver. In organizations, a vast majority of applications' transactional data is captured in relational databases. In order to ensure an efficient supply of transactional data for big data analytics, there are several requirements that the data integration solution should address:

<!--[if !supportLists]-->· <!--[endif]-->Reliable change data capture and delivery mechanism

<!--[if !supportLists]-->· <!--[endif]-->Minimal resource consumption when extracting data from the relational data source

<!--[if !supportLists]-->· <!--[endif]-->Secured data delivery

<!--[if !supportLists]-->· <!--[endif]-->Ability to customize data delivery

<!--[if !supportLists]-->· <!--[endif]-->Support heterogeneous database sources

<!--[if !supportLists]-->· <!--[endif]-->Easy to install, configure and maintain

A solution which can reliably stream database transactions to a desired target enables that the effort is spent on data analysis rather than data acquisition. Also, when the solution is non-intrusive and minimally impacts the source database, it minimizes the need for additional resources and changes on the source database.

Oracle GoldenGate is a time tested and proven product for real-time, heterogeneous relational database replication. Oracle GoldenGate addresses the challenges listed above and is widely used by organizations for mission critical data replication among relational databases. Furthermore, GoldenGate moves transactional data in real-time to support timely operational business intelligence needs.

Oracle GoldenGate Integration Options for Big Data Analytics

There is a variety of integration options available with the Oracle GoldenGate product that facilitates delivering transactions on relational databases into non-relational targets.

Oracle GoldenGate provides pre-built adapters which integrate with Flat Files and Messaging Systems. Please refer to Oracle GoldenGate for Java - Administration Guide and Oracle GoldenGate for Flat Files -Administration Guide for more information.

Oracle GoldenGate also provides Java APIs and a framework for developing custom integrations to Java enabled targets. Using this capability, custom adapters or handlers can be developed to address specific requirements. In this blog post I’d like focus on Oracle GoldenGate Java APIs for developing custom integrations to big data systems.

As we mentioned earlier, 'big data systems' is an umbrella terminology used in general to describe a wide variety of technologies, each of which is used for a specific purpose. Among the various big data systems, Hadoop and its suite of technologies are widely adopted by various organizations for processing big data. The below diagram illustrates a general high level architecture for integrating with Hadoop.

<!--[if !vml]--><!--[endif]--> <!--[if !vml]--><!--[endif]-->

Custom Adapter

<!--[if !vml]--><!--[endif]--> <!--[if !vml]--><!--[endif]--> <!--[if !vml]--><!--[endif]--> <!--[if !vml]--><!--[endif]-->

Pump Parameter file

Adapter Properties file

<!--[if !vml]-->

You can implement custom adapter or handler for the big data system using Oracle GoldenGate's Java API. The custom adapter is deployed as an integral part of the Oracle GoldenGate Pump process. The Pump and the custom adapter are configured through the Pump parameter file and custom adapter's properties file respectively. Depending upon the requirements, the properties for the custom adapter will need to be determined and implemented.

The Pump process will execute the adapter in its address space. The Pump reads the Trail File created by the Oracle GoldenGate Capture process and passes the transactions to the adapter. Based on the configuration, the adapter will write the transactions into Hadoop.

Enabling the co-existence of big data systems with relational systems will benefit organizations to better serve customers and improve decision-making capabilities. Oracle GoldenGate, which has an excellent record of empowering IT on the various aspects of data management requirements, provides the capability to integrate with big data systems. In the upcoming blog posts, we will discuss in depth the implementation and the configuration of integrating Oracle GoldenGate with Hadoop technologies. 

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.

Friday Sep 06, 2013

Sneak Peek into Data Integration Sessions at Oracle OpenWorld 2013

As we are getting ready for another great OpenWorld I'd like to give you sneak peek into what we have planned for data integration topics this year. As in the last few years, the Data Integration track is again full with great customer speakers, product updates, and hands-on-labs. While I am not able to share everything we will cover in these sessions I can say that you will get to hear about new solutions and new features for both Oracle Data Integrator and Oracle GoldenGate.

On Monday at 10:45am our VP of Development Brad Adelberg will open the data integration track by presenting the direction of Oracle Data Integrator and Oracle GoldenGate in the Accelerating Your Business with Oracle Data Integration Solutions (Moscone West 2024) session. Brad will explain how Oracle's data integration products enable organizations to get the most value out of big data,  their investments into Oracle Applications, and cloud deployments. The session will cover the key themes of the upcoming releases of our products.

Following Brad's great overview into overall Oracle Data Integration, GoldenGate product management will present  Oracle GoldenGate New Features and Product Strategy at 12:15pm in the same location. You will hear about new features of the product. Following GoldenGate PM, Oracle Data Integrator product management will present Oracle Data Integrator's product vision and new features in the session:
Oracle Data Integrator Product Update and Future Strategy at 1:45pm in the same room: Moscone West 2024.

The last session of Monday is a must-attend session. You will get to meet the winners of  the Oracle Excellence Awards for Oracle Fusion Middleware Innovation and learn about their impressive success stories across all Fusion Middleware products. I highly recommend adding Oracle Fusion Middleware: Meet This Year’s Most Impressive Innovators to your OpenWorld schedule. It will take place at 4:45pm  at Yerba Buena Center for the Arts, Lam Research Theater.

On Tuesday data quality product strategy sessions will kick off the day for our track with Oracle Enterprise Data Quality: Product Overview and Roadmap at 10:30am (Moscone West 2024) . Right after this session you will have a chance to hear from GoldenGate customers in the A Panel of Masterminds: Perspectives from Oracle GoldenGate Customers session at 3:30pm in the same room. This panel brings us presenters from Smuckers, Land o Lakes and OTV France. I will discuss this session in more detail next week. For now I will mention that customers will discuss how they achieved zero downtime upgrades and migrations and improved performance using GoldenGate with their Oracle Applications.

At the end of Tuesday you can attend another informative Oracle Data Integrator session about Extracting Strategic Insights from Business Data with Oracle Data Integrator (5:30pm, Moscone West 2012)

Wednesday starts with a great customer panel, Real-World Data Quality: Customers Using Oracle Enterprise Data Quality, at 10:15am in Moscone 2024. The must-attend session of Wednesday is Customer Perspectives: Oracle Data Integrator.  Paychex, Infiniti Insurance are among the customers presenting in this session and will be discussing best practices in implementing Oracle Data Integrator. Don't miss this session at 1:15pm in Moscone 2012.  I also recommend checking out at 3:30pm Making the Move to Oracle Data Integrator. ODI PM will be joined by Oracle partners Rittman Mead and sumIT AG. Together they will share great tips for a phased migration path from Oracle Warehouse Builder to Oracle Data Integrator.

Thursday is packed with many in-depth technical product deep dive sessions from experts. The two that I want to highlight here are: Configuring Oracle Business Intelligence Applications on Oracle Data Integrator: A Deep Dive, which will explain best practices for configuring and tuning Oracle Business Intelligence Applications' latest release which embeds Oracle Data Integrator.  This one is at 12:30pm at Moscone South 303. The second session I recommend, Deploying Oracle GoldenGate with Multitenant Container Databases, will share details on how to set up GoldenGate in the context of container databases (CDBs). You can attend it at 2pm at Moscone South 200.

Even though I listed 12 session in this blog post for you to review, there are many more, very informative sessions available this year at OpenWorld. Please make sure to review the Focus On Data Integration to discover other sessions that may interest you.

Stay tuned for more blogs on the some of the key sessions I mentioned above.


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 Jul 26, 2013

The Best Data Integration for Oracle Exadata Comes from Oracle

In a previous blog post I talked about about how Oracle Exadata customers can migrate/consolidate their systems without downtime. In that blog post I mentioned that Oracle Data Integrator and Oracle GoldenGate offer unique and optimized data integration solutions for Oracle Exadata. For example, customers that choose to feed their data warehouse or reporting database with near real-time throughout the day, can do so without decreasing  performance or availability of source and target systems. And if you ask why real-time, the short answer is: in today’s fast-paced, always-on world, business decisions need to use more relevant, timely data to be able to act fast and seize opportunities. A longer response to "why real-time" question can be found in a related blog post.

If we look at the solution architecture, as shown on the diagram below,  Oracle Data Integrator and Oracle GoldenGate are both uniquely designed to take full advantage of the power of the database and to eliminate unnecessary middle-tier components. Oracle Data Integrator (ODI) is the best bulk data loading solution for Exadata. ODI is the only ETL platform that can leverage the full power of Exadata, integrate directly on the Exadata machine without any additional hardware, and by far provides the simplest setup and fastest overall performance on an Exadata system.

We regularly see customers achieving a 5-10 times boost when they move their ETL to ODI on Exadata. For  some companies the performance gain is even much higher. For example a large insurance company did a proof of concept comparing ODI vs a traditional ETL tool (one of the market leaders) on Exadata. The same process that was taking 5hrs and 11 minutes to complete using the competing ETL product took 7 minutes and 20 seconds with ODI. Oracle Data Integrator was 42 times faster than the conventional ETL when running on Exadata.This shows that Oracle's own data integration offering helps you to gain the most out of your Exadata investment with a truly optimized solution. 

GoldenGate is the best solution for streaming data from heterogeneous sources into Exadata in real time. Oracle GoldenGate can also be used together with Data Integrator for hybrid use cases that also demand non-invasive capture, high-speed real time replication. Oracle GoldenGate enables real-time data feeds from heterogeneous sources non-invasively, and delivers to the staging area on the target Exadata system. ODI runs directly on Exadata to use the database engine power to perform in-database transformations. Enterprise Data Quality is integrated with Oracle Data integrator and enables ODI to load trusted data into the data warehouse tables. Only Oracle can offer all these technical benefits wrapped into a single intelligence data warehouse solution that runs on Exadata.


Compared to traditional ETL with add-on CDC this solution offers:

  • Non-invasive data capture from heterogeneous sources and avoids any performance impact on source
  • No mid-tier; set based transformations use database power
  • Mini-batches throughout the day –or- bulk processing nightly which means maximum availability for the DW
  • Integrated solution with Enterprise Data Quality enables leveraging trusted data in the data warehouse

In addition to Starwood Hotels and Resorts, Morrison Supermarkets, United Kingdom’s fourth-largest food retailer, has seen the power of this solution for their new BI platform and shared their story with us. Morrisons needed to analyze data across a large number of manufacturing, warehousing, retail, and financial applications with the goal to achieve single view into operations for improved customer service. The retailer deployed Oracle GoldenGate and Oracle Data Integrator to bring new data into Oracle Exadata in near real-time and replicate the data into reporting structures within the data warehouse—extending visibility into operations. Using Oracle's data integration offering for Exadata, Morrisons produced financial reports in seconds, rather than minutes, and improved staff productivity and agility. You can read more about Morrison’s success story here and hear from Starwood here.

I also recommend you watch our on demand webcast on Zero-Downtime Migration to Oracle Exadata Using Oracle GoldenGate: A Customer Case Study and download free resources on Oracle Data Integration products to learn more about their powerful architecture and solutions for data-driven enterprises.

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 .

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