I cannot see Incoming Changes!

My colleague updated the design but I cannot see those changes in my design. I have checked the design out from Subversion and I have the .svn file in my working copy directory. What is wrong?

Nothing. You must first select Refresh Incoming Changes in Pending Changes pane and after that you can Update Working Copy. Data Modeler does not automatically ask Subversion for incoming changes. You must do it yourself before updating the working copy.

How can I see what is in Subversion?

I have heard that Subversion is integrated to Data Modeler. What does that mean and how can I see what is inside Subversion? I do not want to install any clients or anything…

Go to Team menu and select Versions. The Versions browser opens. You use this browser for creating directories to Subversion, working with Subversion and for seeing what is in Subversion. Go to Team menu again and select Pending Changes. The Pending Changes tab appears. In Pending Changes you check for incoming changes and update the working copy, commit outgoing changes and add files.

Subversion integration also means that when you are working on Pending changes you see the table etc names and not the file names. The file names are terrible for human eyes because they are based on object ids.

Why doesn’t the change in Memory Settings take effect?

I have changed the memory settings (AddVMOption -Xmx1768M) in datamodeler64.conf but it does not change anything. Why?

Because you must remove the settings from product.conf first. As long as you have them in product.conf those settings are follower.

So either

  • change product.conf or
  • remove the memory settings from product.conf and change the datamodeler.conf / datamodeler64.conf file.

My personal opinion is that datamodeler.conf / datamodeler64.conf is better place for changes but both choices work..

Handling Change Requests with Data Modeler

Did you know that you can also add change requests to Data Modeler? And you can easily get reports on unfinished change requests…

Below you can see a new change request I added to an entity Customer already on Oct the 2nd.


I add change requests quite frequently and definitely have no time to follow them all manually. How do I know that all have been finished?

I go to Find (search), the binoculars icon on the Tool bar.


I select the Advanced Mode and select Change Request as “Object Type”. Then I can see all the properties for a change request on the list of “Searchable Properties”. I select “Completed” and define it should be false.


Press Find.

And voilá. In Results tab I see all the change requests that are not finished.

But. I need a report to our project manager who makes sure somebody finishes this task…

I press the Report button.


I select PDF as the Output Format (I could select HTML, XLS or XLSX if I want), I give the report and the file a name. I could use an existing or create a new template but I am happy with the default report. I press Generate Report. And here we are…


I am ready to inform the project manager…

But what if the project manager wants to edit the change requests but refuses to learn how to use Data Modeler? Do I need to be his/her secretary? no…

I run the report in XLS or XLSX format and pass it to him/her to edit with Microsoft Excel. Then I get it back. The project manager edited the status, completion date and notes (“I have closed this change request/Tim”). I go ahead and right-click the Logical Model in Data Modeler and select “Update model with previously exported XLS (XLSX) file”.


I select the report file Tim sent me. And let it go…

Data Modeler gives me a log on what has been updated:


And to prove to you it was really updated, see the Notes for the change request in Data Modeler:


Was that easy? It sure was!

Why did I want to have the change request in Data Modeler? Because now I have all the documentation about the database in one place. On the entity I can always go and check what has been changed and when.Entity

And I can make Impact Analysis based on the fact where this entity has been used.


Maybe you should think about using Change Requests?

Busy times

I am enjoying my busy life. And feeling honored and humble.
I got a message from RMOUG that my session was accepted for the RMOUG Training Days 2015. I am very honored since I know there was a huge amount of excellent sessions available and they took one of mine. Thank you RMOUG! The RMOUG Training Days will be in Denver in February (17-19).

I was also invited to speak at the Riga DevDays in Latvia in January (22nd). I am honored and proud they reached for me and asked me to speak. The agenda for the event is exellent.

On Sunday I will join the Nordic Oracle ACE Director Tour the first time. I am really looking forward to that. There are five ACE Directors (Debra Lilley, Jonathan Lewis, Simon Haslam, Joze Senagacnik and yours truly) traveling in four countries (Sweden, Norway, Denmark, Finland) and speaking. OTN (the ACE program) is funding this tour. Four days, four countries.

After the Nordic Tour it’s time to start preparing for the DOAG event in Germany. That will be in November (18-20) and I am very honored and happy they accepted two of my papers! I have attented DOAG conference many times and I enjoy it a lot. I am so happy I have the chance to go there again. DOAG is also organizing a meeting for user groups to gather and meet during the event and I am looking forward to the meeting too. User groups are very close to my heart and when I have a chance to network with other user groups and share best practices or help in any ways I am happy.

Traveling is fun and I love presenting but the downside of it is that I am too busy with my real work. And traveling takes a lot of time (and the jetlags, I do not want to think about that) and you need to prepare your sessions (that is a lot of work) etc. I do not remember how many times I have been asking for longer weeks (maybe 9 days?) and longer days (36 hours?):) So if you think this kind of life is pure fun, think again:) But I am not complaining: I love my work and I am very happy with my life. Just wanted to point out the downsides since I have heard so many times people saying that life like this is easy and just fun. Try it for 6 months and we talk again…

I love my work and I am so glad I have the opportunity to do things I love and enjoy. I just want to say that the only limitation is you: there is nothing in life you could not do if you just feel it’s important and you want to do it. As a child I said I want to be an author. I never actually buried that dream but there just was not a good time for writing. Now I am writing my first book and I love it even more than I was imagining as a child. Now I better get back to writing…

Have a wonderful day and remember you can do whatever you think is worth doing. The only limitation is you and your attitude!

OOW14, the end

OOW14 is now done for me. Sitting at the airport and waiting for my flight to depart.

Yesterday I attended the Bloggers’ meetup very briefly and then joined an early dinner with some friends. I decided not to attend the party since I was very tired, had a lot of work to do, needed to pack and last but not least had three sessions to present on Thursday. On Thursday I had a breakfast with a friend at 7.30 and then I checked out from my hotel and walked to Moscone. I had my first presentation at 9.30 and then I had some user groups meetings. The next session was at 12.00 and the last one at 1.15 pm. I want to thank everybody who attended my sessions during the OOW! I really hope you learned something new and that you enjoyed.

After my sessions I walked to the hotel to have some drinks and snacks with friends before heading to the airport.

Thank you ACE Program! I had fun and I can say without hesitation: this was the best OOW ever!

Safe travels to all and hope to see you soon again!

OOW14, so far

I think this has been my busiest OOW ever. I did not have had time to tweet, blog or anything. Now I took a short break before the Bloggers’ Meetup to do it.

I have not had time for sessions, I have had so much social to do. On Saturday I had a breakfast with some Finns and then joined the Finnish group to vineyards. My first time. That was just amazing. Beautiful scenery, lovely wines and food, and fantastic company.

I started my Sunday with the Bridge Run organized by That Jeff Smith. Because Debra Lilley was so excited we started our walk already at 7.30 and finished about the time the runners started. The Bridge was fantastic. We saw the sun rise and we enjoyed the lovely weather and lovely scenery. Excellent start for a day and for a conference. I visited the user group pavillion several times during the day to say hi to my friends, I met lots of people, attended the ACE dinner and the Finnish dinner.

On Monday we started with breakfast at 6.30 and then the Bay Swim by Oraclenerd Chet (unfortunately he was not there:(, Chet we missed you!) at 7.30. After that we needed some hot coffee:) I once again met lot of people, had luch with a dear friend, polished slides for my session on Tuesday, attended 4-5 parties and went to bed early.

On Tuesday I started with the IOUC Support Committee Meeting at 7.30. Then met some people and gave my first session at 10.45 for a full room. Thank you all who attended! Then we had the traditional ladies’ lunch at the Cheesecake Factory, some preparations for the presentations, lots of meeting people and 4-5 parties again. But early to bed again.

Today is Wednesday and I met a friend for breakfast at 7.30, then prepared our demo with That Jeff Smith, attended the Sustainability Innovation Awards session (I have been one of the judges for many years), attended a birthday party lunch, got my book signed by Brendan, had some birthday cake and now preparing for the bloggers’ meetup. On my way soon…

Highlights from my first ACED Briefing

I am in San Francisco now. I arrived on Wednesday afternoon and had a lovely family dinner with my Oracle family: my amazing and lovely Mom (Debra Lilley), my Dad Tim Hall who has a huge fan club (on tours my Mom keeps the line in order when people wants to get his autographs) and my ever-young and legendary grandfather Graham Wood (I call him Gram). I am so proud of my family and hope to have many, many family dinners with them in the future.

On Thursday my first two day Oracle ACE Director briefing started. If you want to hear it in short: wow! Biggest plus: Thomas Kurian. Biggest minus: not hearing enough Maria Colgan.

The ACED briefing was exactly what I expected but also much more than that. As a rookie I am still not quite aware what I am allowed to say and what not so I do not talk about details at all. I only tell you that cool things are coming and I am very convinced that Oracle knows what they are doing so keep on betting Oracle.

On Thursday we heard about Oracle Development Tools, all kinds of clouds, middleware, WebCenter, BPM, WLS, Coherence, Exalogic, OAUX, SOA and finally Thomas Kurian came in…
It was all interesting and I learned very much. The OAUX team was as amazing as can be and I was thinking this cannot get better…but it did. Before I say more I tell you I started Thomas Kurian fan club and it is already quite populated…
Thomas Kurian entered the room. He smiled and said hi to all. The whole entrance was quiet, polite and very modest. In that point I was already curious. I have seen his keynotes and presentations but I have never met him in this kind of event. Thomas started his presentation. Without slides, without notes. The way he told the whole story of Oracle products and product families now and in couple of years was facinating. He moved on logically, clear and peacefully giving us all the impression he knows everything about Oracle product, all of them. Because nobody really can people were asking him tough, deep technical questions, and he replied them all with pleasant voice and knowledge that made me speachless. He was not in a hurry. He had all the time in the world to answer every question people had. Larry, I hope you realize what a jewel you have!
So because of Thomas I cannot say much more about Thursday: I am still without words.

On Friday I was looking forward to the update in database and especially Maria Colgan. Unfortunately she was too busy and could not stay more than a few minutes (people were asking questions to keep her there longer). I understand that she was busy right before the OOW so I am not complaining;) but Maria just happens to be one of my favourite persons so I would have liked to hear more…
We heard about MySQL, met Bob Evans (chief communication officer), learnd about BI platform, APEX, Linux, virtualization and Steven Feuerstein’s inspiring YesSQL message. Stay tuned, this will be interesting!
I think the hightlight of the second day was Dan McClary explainig us Big Data and everything around that. He did a great job! I should have written about Data Modeler on my blog when 4.0.3 came out, I realized it on the briefing. Data Modeler supports (among others) Hive and people did not know that (external table of type Hive)!
I always think that if I know something everybody knows it. Not a very good feature for an expert:(

This experience was fantastic and I will remember it for a long time! Thank you OTN, the ACE Program and the organizing team!


Get every new post delivered to your Inbox.