Gurcan Orhan's Oracle Data Integrator Blog


OTN Latin America Tour 2014

Wooohooo… All my papers are accepted to OTN TOUR LAD 2014 (North America leg). I have filled out the permission form and if approved I will be speaking below events. It’s an honor to be accepted to this unique organization and proud of selected first Turkish Oracle Engineer ever.

Details of the event can be found here (Spanish). It will be great to meet with other ACE/ACED speakers as well as Oracle technologists of Latin America.

4th August : Panama, Panama
6th August : San Jose, Costa Rica
8th August : Mexico City, Mexico
11th August : Guatemala, Guatemala
13rd August : San Salvador, El Salvador
15-16th August : Bogota, Colombia
18-19th August : Quito, Ecuador (more…)


#OUGF14 Harmony Impressions

Actually my journey to Helsinki, Finland not started well. I have to leave my Zippo lighter’s inside at the German security, because I had a stop over at the Munich airport. And I starved for lighter in Helsinki, few people are smoking, nearly none of the shops are selling lighters and I was to camping next day. Luckily hotel’s matches helped me a lot, except begging 3 matches each time I go in the hotel.

Rest…? Rest of the trip and event was great.! As my friends Heli Helskyaho, Philippe Fierens, Jan Karremans, Lucas Jellema, Alex Nuijten and Brendan Tierney wrote their impressions (all are wonderful).

First credits goes to Heli Helskyaho & Ann Sjökvist for organising such a great event and accepting me as a speaker. Second credit goes to Oracle ACE Program (Vikki and Lillian), they are the one who were in charge that I was there (sponsorship of ACE Director budget). Finally, last credits goes to all speakers and attendees. This event cannot be without you. (more…)


OUGF Harmony 2014, #OUGF14

Filed under: ACE Director,Conferences&Seminars — Gurcan Orhan @ 11:23
Tags: , ,


Initially I would like to thank Heli and Ann very very much for such a good organized event for Finland Oracle User Group.

You should be sorry if you missed this event because it rocked in every tent and/or session.

I plan to write my impressions (hopefully later today) and want to share my experiences about #OUGF14. So, enough clues for now. :-)

Originally posted on HeliFromFinland:

I am Finnish and this is the end.

The OUGF Harmony 2014 has ended. Sad:( It was such a fun event. I already miss all our great speakers and attendees….

We started on Wednesday with the speakers’ dinner in a Viking restaurant Harald. There was plenty of food and plenty of drinks….and plenty of VIKINGS….



The conference officially started on Thursday morning. A bus was waiting for speakers and attendees in the centre if Helsinki to drive them to the Finnish forest. The conference venue was a venue called Haltia in a middle of a nature park called Nuuksio.

The content of the conference was amazing! We had THE C.J. Date explaining temporal data…


An so many other excellent speakers. The audience was really listening…


The speaker of the first day was voted to be James Morle with his excellent keynote presentation. I am very sorry if you missed it:(…

View original 262 more words


ODI-IKM Incremental Update (Updateless) v1

I have been thinking of creating a brand new Knowledge Module which will make an Incremental Update without using any UPDATE/DELETE SQL statements, only with inserts to increase performance. Initially, I was thinking that there should be a second integration table, but when I started scrawling to figure out flow diagram and how Knowledge Module works, I realized that there is no need for a second integration table.
If you are using Oracle database which your target table existing, this Knowledge Module can fit your needs. Let me try to explain how it works;

1. Drops and Creates I$ flow table (as usual)
2. Inserts the missing records (new records on source) to I$ flow table (if INSERT_NEW_ROWS option is set to true).
3. Inserts the matching records (existing records on source) to I$ flow table (if UPDATE_EXISTING_ROWS option is set to true).
4. Inserts the non-matching records (deleted records on source) to I$ flow table (if NOT_DELETE_NON_EXISTING_ROWS option is set to true).
5. Wrap them up and truncate & insert target table from flow table and drop flow table (if DELETE_TEMPORARY_OBJECTS option is set to true).
6. Analyze target (if ANALYZE_TARGET option is set to true). (more…)


Using DBLink for Oracle to Oracle in ODI

DBLink is the one of the most powerful attributes, if it is needed to load data from one Oracle database to other Oracle database especially when you are doing extraction. If you want to use DBLink, that you already implemented in Topology as “Instance / DBLink (Data Server)”, in a Knowledge Module in Oracle Data Integrator (ODI), there are not fancy options. (more…)


#OUGF14 Harmony by @ougf_ry

Filed under: ACE Director,Conferences&Seminars — Gurcan Orhan @ 13:54
Tags: , , ,

As some of you know, I will be attending to OUGF (Oracle User Group Finland) between 5-6th of June. Thanks to everybody who is in charge of paper selections especially Heli Helskyaho for the organization and Ann Sjökvist for the administration of the event. (more…)


@ODTUG 2nd ODI Experts Panel

Annual ODI Experts Panel of ODTUG will be placed tomorrow afternoon (for me night). We’ll try to answer all the questions about ODI 10G, 11G and 12c from the audiance. All the panelists are focused on ODI for different scopes. (more…)


After TROUG BI&DW 2014

Filed under: Conferences&Seminars — Gurcan Orhan @ 09:51
Tags: , , ,

It was a nice day of TROUG BI&DW 2014 full day meeting. Thanks for all attendees, speakers and everybody who paid attention to this event.
Here are some blog posts / articles about event impressions. (more…)


3rd Webinar for @LAOUC

Save the date for third webinar of LAOUC. I will be talking about EDQ&OGG&ODI on Exadata for Perfection (click for registration) for LAOUC (Latin America Oracle User Community) on this Thursday (2nd April  5PM (BRT) – 8PM GMT – 10pm (GMT +2)).

I will be talking highlights about the powerful applications of Oracle’s Enterprise Data Quality, Golden Gate, Oracle Data Integrator and Oracle Exadata to produce a faster data warehouse preperation.

Join me for this webinar and let’s talk about the control ability of Oracle Data Integrator.


Save the date for 29th April

Filed under: ACE Director,Conferences&Seminars — Gurcan Orhan @ 12:03

I will be attending a webinal panel which is 2nd annual ODTUG – Ask the Experts Panel : ODI on 29th April 2014 3PM EDT (10PM GMT+2).

Click to take a look at ODTUG Webinars, click to register the event.
Remember, you will be the one who will lead this panel with your questions.

Here’s a copy of what is written in ODTUG‘s webinar page.

Moderator : Jesus Villavicencio, Blue Stone – A Huron Consulting Group solution

Panelists :

Join ODTUG Expert’s Panel Webinar!

This is a live interactive panel similar to the ACE Lunch and Learn panels held at Kscope conferences. This innovative webinar is modeled after a call-in radio talk show. You will be able to chat a question to our organizer and if it is accepted you will have the option to verbally ask the question to our panel. Please be sure to have the proper equipment (headset and a quiet office) so that our panelists can clearly understand your question. You’ll also be able to participate in the discussion with the panel while they answer your question.

The following are some potential topics, but audience participation will shape the scope of the panel:

  • What are the top features of ODI 12c and can they be used in a typical data warehouse implementation?
  • Describe the migration from OWB to ODI 12c as it might occur in practice. Anything to watch out for?
  • What are some examples of customizations that you have made in ODI and why?
  • Interested in taking the ODI certification exam? We can talk about what was in the test, how to prepare for it, what to study, etc.
  • Using ODI to improve the Hyperion Planning/Essbase capabilities.
Next Page »

The Rubric Theme. Create a free website or blog at


Get every new post delivered to your Inbox.

Join 554 other followers

%d bloggers like this: