Thursday Apr 11, 2013

Why Real Time?

Continuing on the five key data integration requirements topic, this time we focus on real-time data for decision making. 

[Read More]

Tuesday Apr 02, 2013

Starwood Hotels Presents in Customer Success Forum on April 11th

Register before April 5th for the online Customer Success Forum with Starwood Hotels and Resorts (April 11th 11am ET), and ask questions about how they used Oracle Exadata, Oracle GoldenGate, and Oracle Data Integrator for data warehousing and operational reporting.[Read More]

Thursday Mar 28, 2013

More Complete, Open, Real Time.

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

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


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

Wednesday Feb 27, 2013

Support for Timestamp in Oracle GoldenGate for Sybase

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

Friday Feb 22, 2013

Türk Telekom Saves Big and Improves Performance with Real-Time Archiving Solution

Written by:

Serkan KARATAS, Database Division Manager, Türk Telekom

Sandrine Riley, Oracle Data Integration Product Management


Türk Telekom--a leading communication and convergence technology company in Turkey and the country’s most valuable brand for the last four years according to Brand Finance--provides fixed line communications and broadband internet services. The company, which was founded in 1994 by separating from Posta ve Telgraf Teşkilatı, the national post and telegraph directorate of Turkey, owns more than 14.3 million fixed access lines—nearly all fixed access lines in Turkey—and 7 million asymmetric, digital subscriber lines.

Challenges and Goals

Türk Telekom’s challenge came with growth in becoming a leader in their industry. Customer relationship, sales, marketing, and finance departments needed accurate, timely, and well reported data from the organization's core CRM, billing and payment systems. Unfortunately, the overall data latency, movement, and accuracy were not optimal. The reports needed by these departments were critical for business practices around debt tracking and collecting, detecting of revenue leakages, overall churn prevention, as well as revenue assurance controls. In addition, these reports needed to incorporate online real-time data as well as historical data. In response to the challenges it faced, Türk Telekom set out to build a solution where reports would be delivered on time with maximum performance, leveraging all the appropriate data for better data analysis relevant to the critical business processes. Initially, the team tried to serve all the reports from core OLTP systems, quickly realizing they suffered from performance issues. They needed to reduce the amount of data on the OLTP system, and have the ability to report leveraging the historical data, all at the same time. Additionally, unplanned downtime with the systems was becoming an issue, and the need for data archiving became apparent.

Solution and Results

Türk Telekom was familiar with GoldenGate, as they had used it for their real-time data warehouse, as well as for some zero downtime migrations. Pleased with their prior results, they embarked on a new project in using Oracle GoldenGate for online archiving. This may very well be the first implementation of its kind in the market. Oracle GoldenGate is used to replicate the data to the archive database with near real-time latency, with the ability to purge historical data from the core OLTP database without replicating the purge activity to the archive database. Unlike other archiving solutions, the archive database contains not only historical data but also hot data, and, the archiving processes run while the systems are online and in real-time – not with offline scheduled batches.

Development and testing took about six months, and once this solution was implemented, it showed big results, very quickly. Within 1 month’s time of the solution’s go-live, full return on investment was achieved. Türk Telekom has saved approximately 55 million US dollars in revenue during just the first year ! The company has decreased overall churn rate due to debt by 60%, and has drastically increased OLTP performance by 10X. The business now has immediate access to sales, marketing and financial reports – providing the appropriate departments data to better handle debt tracking, and revenue leakages for example. As initially promised, the reports generated combine historical and real-time data as desired for the business.

Türk Telekom also saw many technical improvements based on this solution as well. 65% percent of disk space was saved once the historical data was archived. Storage and back-up costs shrunk by 40%, and maintenance costs of the production database decreased by 50%. Overall, the systems are more flexible and perform better with the use of Oracle GoldenGate.

But that isn’t all. Türk Telekom is not finished using Oracle GoldenGate. Future projects include: archiving large log tables and transaction tables on the OLTP database for Siebel and Oracle SOA Suite applications in use, directing all application reports to the archive database and totally removing the workload on the OLTP database, as well as wanting to use the archive database as the source for GoldenGate replication to configure cascading replication from the archive database. While lots of work is ahead for the team at Türk Telekom – their success and desire for more of it is very motivating!

For more details, please see Turk Telecom’s Oracle OpenWorld 2012 presentation:

http://www.myexpospace.com/oracle2012/SessionFiles/CON8876_PDF_8876_0001.pdf

its customer snapshot:

http://www.oracle.com/us/corporate/customers/customersearch/turk-telekom-5-gg-ss-1872904.html

and podcast:

http://feedproxy.google.com/~r/OracleOfmRadio/~3/RIpUbVF1HhI/12755074_Turk_Telekom_101212.mp3

Monday Feb 11, 2013

Setting up a One-way Replication from Sybase to Oracle

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

Tuesday Feb 05, 2013

Deeper Look into Integrated Capture for Oracle Database

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

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

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

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

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

Friday Feb 01, 2013

Installing Oracle GoldenGate for Sybase

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

[Read More]

Friday Jan 11, 2013

Customer Spotlight:Raymond James

Back in October we announced that Raymond James is a winner of 2012 Fusion Middleware Innovation Awards in the Data Integration category. As I mentioned on this site before, Raymond James used Oracle Data Integrator and Oracle GoldenGate in an integrated solution for its operational data store that supports the application services across the enterprise. By using Oracle's real-time data integration solution from heterogeneous systems into a centralized ODS, the team achieved higher application performance, reduced complexity and cost, and up to 50 percent faster time to market. 

I had a pleasure meeting the team, Ryan Fornett, Tim Garrod, and Michael Wells, from Raymond James at Oracle OpenWorld 2012. In addition to hearing from them during their presentations, we had a chance to record interviews with Tim and Ryan while at OpenWorld. You can find the links to their videos below:

 Yesterday, with their permission we posted a detailed blog on the FMW blog site about their implementation:

Data Integration Customer Spotlight: Raymond James Financial

I highly recommend reading it to see Oracle Data Integration products in action.

Many thanks to Ryan, Tim, and Mike for sharing the details of their innovative solution with us.


Thursday Jan 10, 2013

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

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

Watch On Demand:Maximum Availability with Oracle GoldenGate.

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

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

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

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

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

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

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

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

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

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

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

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

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

Monday Dec 10, 2012

Maximum Availability with Oracle GoldenGate

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

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

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

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

Webcast: Maximum Availability with Oracle GoldenGate

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

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

Wednesday Oct 31, 2012

Ameristar Wins with Oracle GoldenGate’s Heterogeneous Real-Time Data Integration

Today we announced a press release about another successful project with Oracle GoldenGate. This time at Ameristar. Ameristar is a casino gaming company and needed a single data integration solution to connect multiple heterogeneous systems to its Teradata data warehouse.

The project involves integration of Ameristar’s promotional and gaming data from 14 data sources across its 7 casino hotel properties in real time into a central Teradata data warehouse. The source systems include the Aristocrat gaming and MGT promotional management platforms running on Microsoft SQL Server 2000 databases.

As you can notice, there was no Oracle Database involved in this project, but Ameristar’s IT leadership knew that  GoldenGate’s strong heterogeneous and real-time data integration capabilities is the right technology for their data warehousing project. With GoldenGate Ameristar was able to reduce data latency to the enterprise data warehouse, and use this real-time customer information for marketing teams in improving overall customer experience. Ameristar customers receive more targeted and timely campaign offers, and the company has more up-to-date visibility into financial metrics of the company.

One other key benefit the company experienced with GoldenGate is in operational costs. The previous data capture solution Ameristar used was trigger based and required a lot of effort to manage. They needed dedicated IT staff to maintain it. With GoldenGate, the solution runs seamlessly without needing a fully-dedicated staff, giving the IT team at Ameristar more resources for their other IT projects.

If you want to learn more about GoldenGate and the latest features for Oracle Database and non-Oracle databases, please watch our on demand webcast about Oracle GoldenGate 11g Release 2.

Tuesday Oct 16, 2012

Sabre Manages Fast Data Growth with Oracle Data Integration Products

Last year at OpenWorld we announced Sabre Holding as a winner of the Fusion Middleware Innovation Awards. The Sabre team did an excellent job at leveraging cutting edge technologies for managing rapid data growth and exponential scalability demands they have experienced in the travel industry.

Today we announced the details and specific benefits of Sabre’s new real-time data integration solution in a press release. Please take a look if you haven’t seen it yet. Sabre Holdings Deploys Oracle Data Integrator and Oracle GoldenGate to Support Rapid Customer Growth

There are 3 different areas of benefits Sabre achieved by using Oracle Data Integration products:

  • Manages 7X increase in data sources for the enterprise data warehouse
  • Reduced infrastructure complexity
  • Decreased time to market for new products and services by 30 percent.

This simply shows that using latest technologies helps the companies to innovate robust solutions against today’s key data management challenges. And the benefit of using a next generation data integration technology is not only seen in the IT operations, but also in the business side. A better data integration solution for the enterprise data warehouse delivered the platform they need to accelerate how they service their customers, improving their competitive advantage.

Tomorrow I will give another great example of innovation with next generation data integration from Oracle. We will be discussing the Fusion Middleware Innovation Awards 2012 winners and their results with using Oracle’s data integration products.

Monday Oct 08, 2012

The most challenging part of blogging about OpenWorld is…

...not knowing where to start. Do I talk about the great presentations from our partners and executives in our keynote sessions; do I write about the music festival, or many great sessions we had in the Data integration track? A short blog can never do justice. For now I will stick to our data integration sessions for those who could not attend with so many other sessions running concurrently. And in the coming weeks we will be writing more about what we talked in our sessions and what we learned from our customers and partners.

For today, I will give some of the key highlights from Data Integration sessions that took place on Wednesday and Thursday of last week  On Wednesday, GoldenGate was highlighted in multiple Database and Data Integration sessions. I found particularly the session about Oracle’s own use of GoldenGate for its large E-Business Suite implementation for supply chain management and service contract management very interesting. In 2011, Oracle implemented a new operational reporting system using GoldenGate real-time data replication to an operational data store that leverages data from E-Business Suite.The results are very impressive. Mark Field, VP of Applications Development in the IT organization shared with us that data freshness improved by 2,210X while report run performance improved by 60X. For more information on this implementation and its results please see the white paper: Real-Time Operational Reporting for E-Business Suite via GoldenGate Replication to an Operational Data Store


Other sessions that provided very rich content were: "Best Practices for Conflict Detection and Resolution in Oracle GoldenGate for Active/Active", "Tuning and Troubleshooting Oracle GoldenGate on Oracle Database", "Next-Generation Data Integration on Oracle Exadata" and "Accelerate Oracle Data Integrator with Advanced Features, SOA, Groovy, SDK, and XML". Below is a slide presented by Stephan Haisley in the Tuning and Troubleshooting Oracle GoldenGate session. If you missed them during OpenWorld, I highly recommend downloading the slides. We will continue to blog about these topics and related resources.

.

Thursday Oct 04, 2012

Oracle OpenWorld Highlights

We are in the final days of Oracle OpenWorld 2012 and the data integration team have been hard at work giving sessions, meeting customers, demonstrating product and conducting hands-on labs.    It has been a great conference, but the best part is meeting our customers and learning about all the great implementations of our products. 

Wednesday was the last day that the exhibition hall was open and attendees were getting in their final opportunities to see our products and meet with the product management team.   Two hours before the close of the hall, people lined up to learn about GoldenGate 11gR2, Monitor, Adapters, Veridata, and all the different use cases.    Here's a picture of Sjaak Vossepoel, who is our DIS Sales Consulting Manager for EMEA speaking to a potential customer on the options of using Oracle GoldenGate for heterogenous data replication. 


Over the last two days, the GoldenGate team ran two labs; Introduction to Oracle GoldenGate Veridata and Deep Dive into Oracle GoldenGate.   Both of the labs were completely booked out and unfortunately we had to turn away people.   BUT,  all of our labs were recorded recently so if you were not able to get into the lab or did not have enough time to complete your labs, visit youtube.com/oraclegoldengate to see a  complete recording of the labs we used at OpenWorld plus more.

 Here are a couple pictures from the Deep Dive into Oracle GoldenGate lead by Chis Lawless from the Product Management team.

Thanks to the GoldenGate Hands-on Lab team for putting on a great session!!!

We will post more information about where you can find additional details on OpenWorld as they become public.   

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