Wednesday Feb 27, 2013

Support for Timestamp in Oracle GoldenGate for Sybase

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

Tuesday Feb 26, 2013

ODI - Slowly Changing Dimensions in 0 to 60

Want to see understand how to setup your datastores for supporting dimension loading concepts such as type 2 slowly changing dimensions? See the viewlet here.  The viewlet provides a very quick look at setting up a datastore for supporting slowly changing dimension data loading using ODI 11g. It uses the IKM Slowly Changing Dimension and shows dimension members being versioned when for example a marital status change happens.

Monday Feb 25, 2013

Connecting Velocity to Value: Introducing Oracle Fast Data

To understand fast data, one must first look at one of the most compelling new the breakthroughs in data management: big data. Big data solutions address the challenge today’s businesses are facing when it comes to managing the increasing volume, velocity, variety of all data - not just data within as well as about the organization. Much of the buzz and to-do around big data has been around Hadoop, NoSQL technologies, but little has been talked about velocity. Velocity is about the speed this data is generating. In many cases the economic value of this data diminishes fast as well. As a result, companies need to process large volumes of data in real-time and make decisions in a more rapid fashion to create value from highly-perishable, high-volumes of data in business operations.

This is where fast data comes in. Fast data solutions help manage the velocity (and scale) of any type of data and any type of event to enable precise action for real-time results.

Fast data solutions come from multiple technologies, and some of the concepts, such as complex event processing and business activity monitoring, have been in use in areas such as the financial services industry for years. But often, the pieces were used in isolation—a complex event process engine as a standalone application to apply predefined business rules to filter data, for example. But when these concepts are tied to analytics, capabilities expand to allow improved real-time insights. By tying together these strands, companies can filter/correlate, move/transform, analyze, and finally act on information from big data sources quickly and efficiently, enabling both real-time analysis and further business intelligence work once the information is stored.

Oracle’s Fast Data solutions offer multiple technologies that work hand-in-hand to create value out of high-velocity, high-volume data. They are designed to optimize the efficiency, scale for processing high volume events and transactions.

[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]

Wednesday Feb 06, 2013

ODI - Extracting data from PDF Forms in 0 to 60

Here's an end to end viewlet illustrating how to reverse engineer form metadata from PDFs and also how to extract and integrate data. This carries on from the earlier posting here.

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]
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
« February 2013 »
SunMonTueWedThuFriSat
     
2
3
4
7
8
9
10
12
13
14
15
16
17
18
19
20
21
23
24
28
  
       
Today