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

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 Dec 28, 2012

ODI - Basic Hive Queries

Here we will see a basic example joining the movie lens data and then loading a Hive table based on the tables from the Reverse Engineering Hive Tables post. The Hive table was defined and created via ODI, I duplicated the movies table and added a column for the rating, just for demo purposes...

When I build my interface, I add movies for my source and movies_info as my target, the auto mapping completes much of the mapping, the rating (which is not mapped below) comes from another table - this is where ODI's incremental design is nice, I can add in a new datastore as a source and map columns from it, then describe the join. 

 After I have added the movie ratings table, I will define the join just by dragging movie_id from movies to the ratings table movie_id column. That's the join...mostly defined.

The other thing you need to check is that the ordered join property is set. This will generate the ordered join (ANSI style, but using the Hive technology's template) syntax.

 We can also perform transformations using built in or user defined functions, below I am performing the Hive built-in UPPER function on the movie name for example.

In the physical, or flow view I am using the Hive Control Append IKM, I am using ODI to create the target table in Hive and also performing a truncate if it exists. Also have the control flow switched off. 

Executing this is just like any other interface apart from we leverage Hive to perform the heavy lifting. The resultant execution can be inspected in the ODI operator or console and the resultant table inspected when complete. 

Tuesday Oct 25, 2011

Top 3 Ways to Leverage Oracle GoldenGate with MySQL Databases

One of the key differentiators of Oracle GoldenGate in the real-time data integration and data replication technology space is its heterogeneity. It provides log-based change data capture, routing, transformation, and delivery between heterogeneous systems. MySQL is one of the heterogeneous platforms that GoldenGate can support both as source and target.

The most common ways Oracle GoldenGate is used with MySQL are real-time data warehousing, real-time reporting, and query offloading. In real-time data warehousing use case, Oracle GoldenGate feeds online transaction data from Web properties running on MySQL databases to the data warehouse in real time, to enable a complete and reliable view of the business operations. Oracle GoldenGate can feed all major data warehouses including Oracle Exadata, Teradata, IBM Netezza, Greenplum etc.

MySQL is heavily used for departmental enterprise applications including analytical systems. Oracle GoldenGate can deliver real-time data from production OLTP systems to data marts running on MySQL to support operational reporting and analytical applications. This enables analytical systems to have access to up-to-date information when supporting operational decision making.

Last but not least, GoldenGate can enable query offloading from production OLTP systems that may be on a mainframe (such as DB2 z/Series) or open systems (such as  MSFT SQL Server or Sybase ASE). Oracle GoldenGate can move all or a portion of transactional data in real time from production databases to MySQL databases to allow the end users to run their queries and reports on the dedicated server rather than on the production server. This approach is a great way to reduce TCO and maximize the performance of production OLTP systems. In addition, it allows to optimize the database for reporting purposes. Especially in travel and ecommerce industry it helps reduce browsing activity related overhead on OLTP systems.

To read more about how to leverage Oracle GoldenGate please check out our new MySQL and Oracle GoldenGate spotlight document and check the additional resources provided.

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