#LAOTNTour Leg1 : Panama (City Tour)

It was a long flight from Istanbul, Turkey to Panama City, Panama. First 10:35 hours of flight from Istanbul Atatürk Airport to New York JFK Airport. Laying over 3:50 hours, then to Panama City International Airport with 5:12 hours of flight.
I was picked up by courtesy of Panama Oracle Users Group and it was a pleasant journey from the airport to Intercontinental Miramar Hotel. “Anti-Jet-Lag” method worked again. Didn’t sleep before my first flight and slept all flights long, landed at 05:57 am with a fresh, slept. :-) Continue reading

#OTNLATour has just started

As started my trip from Istanbul to Panama City, OTN LA Tour 2014 has just started for me.
Here is the my session list for each leg of the tour and the video that Bob Rhubart has posted on OTNArchBeat YouTube channel. Thanks Bob for letting me speak about this long tour.

I know I will be very tired at the end of each day, but I’m sure it will worth it. Once again, I am proud of being an Oracle ACE Director and supporting Oracle ACE Program. Continue reading

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 Continue reading

#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. Continue reading

OUGF Harmony 2014, #OUGF14


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). Continue reading

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. Continue reading