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 Jun 13, 2013

Near Zero Downtime Upgrades for Oracle Communications Billing and Revenue Management

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

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

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

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

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

Thursday May 16, 2013

Sabre Holdings Case Study Webcast Recap

Last week at Oracle we had a very important event. In addition to the visit by the roaming Gnome, who really enjoyed posing for pictures on our campus, I had the priviledge to host a webcast with guest speaker Amjad Saeed from Sabre Holdings. We focused on Sabre's data integration solution  leveraging Oracle GoldenGate and Oracle Data Integrator for their enterprise travel data warehouse (ETDW).

Amjad, who leads the development effort for Sabre's enterprise data warehouse, presented us how they approached various data integration challenges, such as growing number of sources and data volumes, and what results they were able to achieve. He shared with us how using Oracle's data integration products in heterogeneous environments enabled right-time market insights, reduced complexity, and decreased time to market by 40%. Sabre was also able to standardize development for its global DW development team, achieve real-time view in the execution of the integration processes, and the ability to manage the data warehouse & BI performance on demand. I would like to thank Amjad again very much for taking the time to share their data integration best practices with us on this webcast.

In this webcast my colleague Sandrine Riley and I provided an overview of Oracle Data Integration products' differentiators. We explained architectural strengths that deliver a complete and integrated platform that offers high performance, fast time-to-value, and low cost of ownership.  If you have not had a chance to attend the live event we have the webcast now available on demand via this link for you to watch at your convenience:

Webcast Replay: Sabre Holdings Case Study: Accelerating Innovation using Oracle Data Integration

There were many great questions from our audience. Unfortunately we did not have enough time to respond to all of them. While we are individually following up with the attendees, I also want to post the questions and answer for some of the commonly asked questions here.

    Question: How do I learn Oracle Data Integrator or GoldenGate? Is training the only option ?

    Answer: We highly recommend training through Oracle University. The courses will cover all the foundational components needed to get up and running with ODI or GoldenGate. Oracle University offers instructor-led and online trainings. You can go to http://education.oracle.com to get a complete listing of the courses available.Additionally – but not in replacement of training – you can get started with a guided ‘getting started’ type tutorial which you can find on our OTN page:  in the ‘Getting Started’ section of the page.Also, there are some helpful ‘Oracle by Example’ exercises/videos which you can find on the same page.

    For Oracle GoldenGate, we recommend watching instructional videos on its Youtube channel: Youtube/oraclegoldengate. A good example is here

    Last but not least, at Oracle OpenWorld there are opportunities to learn in depth by attending our hands-on-labs, even though it does not compare to/replace taking training.

    Question: Compare and contrast Oracle Data Integrator to the Oracle Warehouse Builder ETL process. Is ODI repository-driven and based on creation of "maps" when   creating ETL modules?

    Answer: ODI has been built from the ground up to be heterogeneous – so it will excel on both Oracle and non-Oracle platforms.  OWB has been a more Oracle centric product.  ODI mappings are developed with a declarative design based approach, and processes are executed via an agent – who is orchestrating and delegating the workload in a set-based manner to the database.  OWB deploys packages of code on the database and produces more procedural code.   For more details – please read our ODI architecture white paper

    Question:  Is the metadata navigator for ODI flexible and comprehensive so that it could be used as a documentation tool for the ETL?

    Answer: Oracle Data Integrator's metadata navigator has been renamed – now called ODI Console.  The ODI console is a web-based interface to view in a more picture based manner what is inside of the ODI repository.  It could be used as documentation.  Beyond the ODI console, ODI provides full documentation from the ODI Studio.  For any given process, project, etc.  you are able to right click – and there is an option that says ‘print’ – and this will provide you with a PDF document including the details down to the transformations.  These documents may be a more appropriate method of documentation.  Also – please check out a whitepaper on Managing Metadata with ODI.

If you would like to learn more about Oracle Data Integration products please check out our free resources here. I also would like to remind you to follow us on social media if you do not already. You can find us on Facebook, Twitter, YouTube, and Linkedin.



Monday Apr 29, 2013

Monitoring Oracle GoldenGate 11g Release 2

One of the key improvements in Oracle GoldenGate 11g Release 2 is in the monitoring area. This release brought  integration with Oracle Enterprise Manager 12c, as well as a new product dedicated for monitoring Oracle GoldenGate, called Oracle GoldenGate Monitor.  This new product is included in the Management Pack for Oracle GoldenGate and offers GUI-based solution for end-to-end, real-time visibility into Oracle GoldenGate implementations across the enterprise. GoldenGate Monitor increases IT productivity by offering consolidated information for multiple instances of Oracle GoldenGate and via its comprehensive e-mail, SNMP and CLI alert capabilities, among many other features.

We have a new screencast that presents Oracle GoldenGate  Monitor's features and architecture, along with a product demonstration. If you have a GoldenGate solution or plan to deploy one, I highly recommend watching this screencast here or via the embedded video below to learn about monitoring GoldenGate processes via this simple but powerful GUI-based product.


For more information on Oracle GoldenGate 11g Release 2, please check out our free resources.

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.

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
« July 2015
SunMonTueWedThuFriSat
   
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
 
       
Today