Oracle Open World – Amazing …

Well I have to admit, you really have to experience this once, to know what big of an event this really is.

Through the Oracle Fusion Regional Director program I was invited to Oracle Open World to get in touch with the other ace’s and ace directors and of course with the product team.

We needed to share our experience and knowledge with the product team and of course mind-mapping with the other regional directors.

Yesterday we had an ace-meeting in which we’ve talked about the different 11g releases and the road ahead. After the ace-meeting it was time to go to Larry Ellison’s keynote speech.

This was amazing, and I need to show you all the footage I have on this when I’m back home. He talked about the beginning of Oracle, how they started out, what their main lifestyle and focus was and how they got to be as big and succesfull as they are today. Different pictures and videos were given from the different managers and CFO’s in their younger days and of course different mash-ups they’ve directed concerning Oracle’s approach.

One play was awsome regarding ‘what happens when Oracle takes over your company’, this was really,trully great ;o))

After that we had an ace-dinner which was really great to get acquanted with everyone and to have a feeling of everyone’s experience/knowledge … and most of all to have a great time out.

Because of the jetlag-feeling I went home afterwards, no after dark parties for me anymore.

Flex and Oracle

Recently we have been working with Adobe Flex and Live Cycle Data Services, part from some little bugs the products seems great. The only thing that stops me from using more Flex is the fact that you need to have a license to use Adobe Live Cycle Data Services and not all customers are interested to make this investment.

So I was looking for a solution and came across this nice example of Mike Potter. He demonstrates how you can use flex with php in order to update a mySQL Database. This should also be possible in Oracle I thought, using mod pl/Sql. Let’s give it a try:

The first thing I wanted to accomplish was to display data from an Oracle database into my flex application. I will use xml to retrieve and display my data.

I started by making a new flex project with a custom component were I implemented a simple datagrid where I would display my retrieved data.

The next thing to do was to let Oracle display some xml so I could retrieve this back into my flex application. I will do this a simple as possible and just use the htp.p function in order to display some static xml:

I then called my procedure in my browser and checked of the xml is correctly generated:

This seemed correct, now I had to retrieve this data into my flex application. I will use the HTTPService tag in mxml to do this. As url property I gave the same location I typed in my browser to check the xml. Now complete your HTTPService with the right resulthandler, I used an Arraycollection to store my data and specified it as dataprovider in my datagrid. The result was what I hoped for:

This is the most simple example of course, but now I’m launched for some further research.

Showcase Rad Race

As promised a little view of the application we build during the RAD Race. The application offers day care services. Both day care centers as parents can register and use the system.

A day care center registers and puts out some offers with certain dates that children can stay. Parents can search offers and put out their own demands. Every night the system will calculate the top 5 offers that match the parent demands and email them.

Although not viewable here, every action a parent/day care center makes is logged into the system and emails are also being send.

I made 2 shorts videos of the basic action a day care center / parent will do so you can have a quick look into the application.

A video of a day care center logging in can be downloaded here

A video of a parent logging in can be downloaded here

Oracle Open World – Let’s present some Use Cases

One week to go until Oracle Open World kicks of and it will be my 1st attendance, and to be honnest I’m pretty nervous ;o)

The last few weeks I’ve been trying to integrate my oracle bpel processes with a Flex User Interface, and with success … which means I have new material to discuss with the SOA Community.

The case I would like to discuss with the different fusion regional directors, ace’s and of course the product team will hold following topics (already explained on this blog):
– Use Case: Migrate existing Excel data using Oracle Data Integrator
– Use Case: Analyse Business processes using BPA Suite and BPM processes and generate bpel blue print using bpa suite
– Use Case: integrate Flex User Interface with existing Bpel Processes using Web Service Proxy Clients for the middletier

These are the 3 different approaches I’ve used so far for an existing customer, trying to evaluate BPA Suite and ODI using a real-time case and implemting a business process driven application using bpel & flex.

I’m really looking forward to the discussions to exchange experience & expertise !

See you there!

Join Me at Oracle OpenWorld Connect!