Everything started on April 2010 when I need to prepare an abstract for Open World 2010. I immadiately prepared for a abstract and sent it to relevants at a rainy night. Here is how my abstract was.
Benefiting of Oracle Data Integrator in a heterogeneous environment – A challenging scenario in Telco Industry.
Turkcell is a telecommunication operator which is the leader of Turkey and third in Europe. Main scope of the solution is to acquire raw data and increase/create meaning to various operational applications within Network Operations Division in Turkcell. There are lots of different operational systems of different vendors, databases, operating systems to maintain, analyse, record and track network infrastructure of Turkcell.
The solution is a datawarehouse approach to combine and merge Network Operations applications to make different kinds of trend analysis, creating data patterns and historical correlations.
Oracle Data Integrator is used as an ETL/ELT tool to bring all these different kind of data into datawarehouse. Datawarehouse is stored in Oracle 11g Release 2 database. Sybase Power Designer is used as a modeling tool for the complete datawarehouse (Operational Data Store, Datawarehouse, Datamarts).
Source systems of the solution are in a variety that are stored in Oracle 10g, Oracle 11g, Microsoft SQL Server 2005, Microsoft SQL Server 2008, Sybase ASE 15.03, Sybase IQ 12.7, different types of files.
Datamarts, which are generated from datawarehouse according to suitable grouping, are implemented to ad-hoc querying. Datamining functionality is added through historical and current data. In this session hear how Turkcell uses Oracle Data Integrator to merge several kind of sources into a Data Warehouse, transforming data into business value information.
It was 20 May 2010 when I received a mail with a subject of “Oracle Open World 2010 Speaker Invivation” and make me excited at far night. As a tradition I need to reply the invitation. We decided to divide the session into two parts and my colleague, Fatih, would be with me to share the same excitement. Forms are filled through web, invitation letters obtained, received the brand-new passports, interview for visa, bought the plane tickets, booked for the hotels and at last time to fly away.
Room 3020 in Moscone West Level 3 was waiting for us for our session with subject “Turkcell Transforms Its Business with Oracle Data Integrator and Oracle Exadata” at 22 September 2010 between 16:45 and 17:45. We decided to fly to New York then to San Francisco and same return with a day to visit in New York.
Before I go nearly all my agenda was full because of “closed session” invitations. But lots of bloggers put our session to their session list. Thanks them a lot.!