30 Friday Sep 2016
Posted in Data Modeler
Starting in version 4.2.0 (build 917) known as 4.2EA there are new preferences for reporting that allow you to generate even better Standard template reports.
The Preferences before this release were:
And since 4.2EA:
There are five new preferences that will make your reports look and work even better than before. I will explain these Preferences in detail on my next blog posts 🙂 Stay tuned 😀
29 Thursday Sep 2016
Posted in Data Modeler
Starting in version 4.2.0 (build 917) known as 4.2EA you can define the query for a view without using the Query Builder. You can simply type or copy/paste the SQL query wanted to the new Query box in a new Query tab located in the View Properties:
You can test the query by pressing the Test Query button. If I had pressed that button I had noticed that I made a typo on table name (load vs. loan) 😀 This button is very useful…
Of course the Query Builder is also available if you rather use that. But when and why would I like to use this new functionality? I know that using this functionality there will be no lost of formatting, no problems with hints, no problems with the comments inside the query etc. In short no editing that is not done by me 🙂
28 Wednesday Sep 2016
Posted in Data Modeler
Enhancements in Change Requests
Starting in version 4.2.0 (build 917) known as 4.2EA you can create Change Requests in the Browser. Right-click the Change Request in the Browser and select New Change Request.
There is also a new tool for managing the Change Requests called Change Requests Administration. You can find it under the Tools menu:
And this is how the tool looks like:
Are you interested in learning more about Change Requests?
https://helifromfinland.wordpress.com/2014/10/18/handling-change-requests-with-data-modeler/
27 Tuesday Sep 2016
Posted in Data Modeler
4.2EA is mostly bug fixes but there are also some new features that I think you should know about. I will blog about some of them in a serie of What’s new in Data Modeler 4.2EA posts. This is the first one of that serie.
Design rules for a subview or a selected set of objects
Starting in version 4.2.0 (build 917) known as 4.2EA you can apply design rules to objects in a subview (they will not be applied to objects that do not exist in this subview). Simply right-click on the canvas of a subview and select Design Rules.
You can also select one or more objects from the canvas, right-click and select Design Rules. The rules will only apply to the selected objects.
What is a Design Rule?
https://helifromfinland.wordpress.com/2016/07/21/design-rules/
25 Sunday Sep 2016
Posted in Events
I am home! After a very intense 10 days in San Francisco.
Quite jetlagged and so much work waiting for me to finish 🙂 But I am happy. It was such a privilege to be able to attend both the Oracle ACE Director briefing and the Oracle Openworld 2016!
People often ask me, after the OOW, what is new in the Oracle space. I am sorry but I cannot answer that question. The ACED briefing has a very strict NDA that does not allow me to tell anything I heard during those two days and because I am always too busy during the OOW to really see and hear what is publicly announced I have decided not to say anything, just to be sure I do not violate the NDA. So please do not get upset that my answer is I do not say anything.
It all started with the ACED briefing at the Oracle HQ. I was staying at the Sofitel hotel with a beautiful view (too bad I was not in my room except for sleeping):
The ACED briefing was for two days (Thursday and Friday), including highlights like meeting Thomas Kurian:
Working intensively with my friends and colleagues:
And attending a morning exercise session by my friend Kent Graziano:
After the intense two days at the HQ we moved to San Francisco to start the OOW. I gave two sessions during the event: one about Big Data together with my friend Elise Valin-Raki and another sessions about (still) my favourite topic on how to design databases using Oracle SQL Developer Data Modeler. Elise and I were pretty cordinated with our dresscode:
I also attended the WIT panel organized by OTN and Laura Ramsay:
And stayed after the panel to talk with people and answer their questions as well as I could:
OTN and Oracle Press also organized a book signing event for our new book:
It was a fun book to write. I hope you will like reading it 🙂
I am a member of the ACE community but also a member of the user group community. Part of that commitment is helping at the user group kiosk. I scanned everybody with my new toy 😀
Besides of the huge amount of content OOW is also all about parties and meeting people. Every evening there are plenty of parties… This photo is from the reception organized by Loïc Le Guisquet:
The best part of both these events is still meeting friends and making new friends. Just a few eaxmples 🙂
And to meet these friends from the Oracle community gets even more exciting when you start to know them better. This year I learned that my friend Arup Nanda is not just a great Oracle expert and a wonderful person but also a gifted artist. This is a painting he gave me as a present:
I love it!
Now the OOW is over and I’m back to home again. It was a great 10 days. Thank you for letting me speak, thank you for all the great feedback and thank you Oracle ACE Program and OTN for treating me so well! I cannot wait for OOW17!
Cheers,
Heli
18 Sunday Sep 2016
Posted in Data Modeler
I love the Oracle OpenWorld time: interesting things happen!
Data Modeler 4.1.5 is out but so is the EA for 4.2!
Go and download:
http://www.oracle.com/technetwork/developer-tools/datamodeler/downloads/datamodeler-087275.html
What’s new in 4.1.5? Plenty of bugs fixed:
“Date: September 2016
This list contains only a selection of higher priority bugs, customer bugs and issues raised by the community on the OTN Forum since the release of version 4.1.3.
| 24642626 – MODIFIED OBJECTS DO NOT APPEAR IN INCOMING CHANGES |
| 23214498 – NEED TO DELETE TWICE WHEN DELETE STRUCTURED TYPE |
| 24618730 – CANNOT GENERATE DDL WHEN TABLE HAS $ IN THE NAME – FOR AUTOINCREMENT COLUMN |
| 24570374 – LIKE CONDITION IS IMPORTED AS LOV CONSTRAINT |
| 22596042 – FOREIGN KEYS NOT RECOGNIZED IN SYNC USING THIRD PARTY JDBC DRIVER |
| 23504656 – UDP LIBRARIES PUT INTO DESIGN’S FILES DIRECTORY ARE NOT LOADED |
| 23258992 – [IMPLICIT] AS OWNER SHOULD NOT BE INCLUDED IN DDL FOR DB2/390 |
| 24009706 – ADVANCED SEARCH – CANNOT USE TWO OR MORE FILTERS WITH THE SAME PROPERTY |
| 23561479 – DYNAMIC/USER DEFINED PROPERTIES DO NOT APPEAR IN SECOND LEVEL OBJECTS IN REPORT |
| 23737449 – CHANGING PRIMARY KEY NAME IS NOT SAVED |
| 22681021 – SAVED MODEL INCOMPLETE AFTER SAVE UPON EXIT |
| 22761767 – LABELS IN RELATIONAL MODEL ARE NOT SIZED PROPERLY AND TEXT IS WRAPPED AND HIDDEN |
| 22394744 – EDIT ONE DOMAIN PROPERTY – CAN NOT ADD COMMENT |
| 22462199 – MANY TO MANY RELATIONSHIP NOT ENGINEERED PROPERLY – RELATIONSHIP ATTRIBUTES |
”
Let’s talk more about EA 4.2 a bit later…
Cheers,
Heli
HeliFromFinland 