• About Heli

HeliFromFinland

~ Heli's thoughts on Database Designing, Oracle SQL Developer Data Modeler, User Groups etc.

HeliFromFinland

Monthly Archives: October 2014

Handling Change Requests with Data Modeler

18 Saturday Oct 2014

Posted by Helifromfinland in Data Modeler

≈ 1 Comment

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.

ChangeRequest

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.

Find

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.

Search

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.

Report

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…

Result

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”.

Update

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

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

TheLog

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

notes

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.

ImpactAnalysis

Maybe you should think about using Change Requests?

Busy times

15 Wednesday Oct 2014

Posted by Helifromfinland in General

≈ Leave a comment

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

03 Friday Oct 2014

Posted by Helifromfinland in Events

≈ Leave a comment

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

01 Wednesday Oct 2014

Posted by Helifromfinland in Events

≈ Leave a comment

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

01 Wednesday Oct 2014

Posted by Helifromfinland in Events

≈ Leave a comment

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!

Newer posts →

Subscribe

  • Entries (RSS)
  • Comments (RSS)

Archives

  • October 2023
  • October 2022
  • October 2021
  • April 2020
  • October 2019
  • October 2018
  • June 2018
  • December 2017
  • October 2017
  • September 2017
  • July 2017
  • April 2017
  • March 2017
  • February 2017
  • January 2017
  • December 2016
  • November 2016
  • October 2016
  • September 2016
  • August 2016
  • July 2016
  • June 2016
  • May 2016
  • April 2016
  • March 2016
  • February 2016
  • December 2015
  • November 2015
  • October 2015
  • September 2015
  • August 2015
  • July 2015
  • June 2015
  • May 2015
  • April 2015
  • March 2015
  • January 2015
  • December 2014
  • November 2014
  • October 2014
  • September 2014
  • August 2014
  • June 2014
  • May 2014
  • April 2014
  • January 2014
  • December 2013
  • November 2013

Categories

  • Data Modeler
  • Database design
  • Events
  • General
  • Oracle
  • SQL Developer

Meta

  • Create account
  • Log in

Create a free website or blog at WordPress.com.

Privacy & Cookies: This site uses cookies. By continuing to use this website, you agree to their use.
To find out more, including how to control cookies, see here: Cookie Policy
  • Subscribe Subscribed
    • HeliFromFinland
    • Join 53 other subscribers
    • Already have a WordPress.com account? Log in now.
    • HeliFromFinland
    • Subscribe Subscribed
    • Sign up
    • Log in
    • Report this content
    • View site in Reader
    • Manage subscriptions
    • Collapse this bar
 

Loading Comments...