HeliFromFinlandhttps://helifromfinland.blog
Heli's thoughts on Database Designing, Oracle SQL Developer Data Modeler, User Groups etc.Wed, 17 Jan 2018 10:31:42 +0000enhourly1http://wordpress.com/https://s2.wp.com/i/buttonw-com.pngHeliFromFinlandhttps://helifromfinland.blog
Oracle SQL Developer Data Modeler 17.4https://helifromfinland.blog/2017/12/29/oracle-sql-developer-data-modeler-17-4/
https://helifromfinland.blog/2017/12/29/oracle-sql-developer-data-modeler-17-4/#commentsFri, 29 Dec 2017 17:59:48 +0000http://helifromfinland.blog/?p=3124Continue reading →]]>This is a version I have been waiting: so many important bug fixes! I downloaded it immediatelly the evening it was available and finished one of my projects using it.

]]>https://helifromfinland.blog/2017/12/29/oracle-sql-developer-data-modeler-17-4/feed/1helifromfinlandOn my way HOME…https://helifromfinland.blog/2017/12/05/on-my-way-home/
https://helifromfinland.blog/2017/12/05/on-my-way-home/#respondTue, 05 Dec 2017 13:49:44 +0000http://helifromfinland.blog/?p=3122Continue reading →]]>I am at the Birmingham airport on my way home from UKOUG Tech 2017. This was my last event for this year. Cannot wait to be home to celebrate the independence of Finland tomorrow. 100 years independent!

My year was busier than ever, I kind of hope next year will be easier but it is not an easy wish because I really enjoyed this year a lot. In addition to my everyday work I have been teaching at the university, studying, researching and speaking in different kinds of events about many different topics. In 2017 I spoke at

UKOUG, Birmingham, UK

DOAG, Nuremberg, Germany

Devoxx Morocco, Casablanca, Morocco

Nordic ACE Tour
Denmark
Sweden
Norway
Finland

HrOUG, Rovinj, Croatia

SIOUG, Portoroz, Slovenia

Oracle Open World, San Francisco, USA

Tajikistan TechDay, Dushanbe, Tajikistan

POUG, Krakow, Poland

Oracle Code Seoul, South Korea

APEX Day, Oracle House, Finland

Oracle Code Bengaluru, India

KScope17, San Antonio, USA

E4 2017, Dallas, USA

BGOUG, Bulgaria

OTN EMEA Tour
Baku, Azerbaijan
Madrid, Spain

Riga DevDays 2017, Riga, Latvia

APEX Connect, Berlin, Germany

BIWA Summit, Redwood City, Oracle HQ, USA

If I counted correctly that would be 23 events in a year. Now it is time to take a break for holidays. Next year does not start very slowly because I have already agreed to go to Israel in January and Ireland in March. But until that: enjoy December. Let’s hope it will be a white Christmas and that Santa (from Finland!) pays a visit

Cheers,

Heli

]]>https://helifromfinland.blog/2017/12/05/on-my-way-home/feed/0helifromfinlandReporting with Data Modeler 17.3https://helifromfinland.blog/2017/10/28/reporting-with-data-modeler-17-3/
https://helifromfinland.blog/2017/10/28/reporting-with-data-modeler-17-3/#respondSat, 28 Oct 2017 08:36:12 +0000http://helifromfinland.blog/?p=3107Continue reading →]]>In version 17.3 there are some changes in the reporting user interface. The reporting itself works as before.

The reporting form has been devided into two tabs: General and Objects.

General includes things that define how the report looks like, including templates and output formats:

You can also define the Company name, some reporting preferences, Reports Directory and Saxon XSLT 2.0 jar file path in the General tab. The defaults can be set in Preferences as before:

And Objects tab include selecting the source (open design/reporting repository) and configurations (which objects will be included to the report):

If that directory has been defined you do not need to worry about domains etc. when upgrading Data Modeler. All the system type kind of things are automatically available even though you upgrade.Things like:

And you can also add this directory to version control to be able to keep track of the changes…

]]>https://helifromfinland.blog/2017/10/13/default-system-types-directory/feed/1helifromfinlandSystemTYpesSharing Design Properties/Design Level Settingshttps://helifromfinland.blog/2017/10/12/sharing-design-propertiesdesign-level-settings/
https://helifromfinland.blog/2017/10/12/sharing-design-propertiesdesign-level-settings/#respondThu, 12 Oct 2017 05:54:40 +0000http://helifromfinland.blog/?p=3073Continue reading →]]>I have defined the Naming Standards, Templates etc for one design and I would like to have those same settings for another design I am working on. How can I do that?

You can do that using the Export/Import functionality. Open the design that has the right settings. Go to either Design Properties or Design Level Settings and select Export.

Save the file. Remember to add the extension xml.

Open the design you want to implement those settings. Select Import and find the file with the exported settings. Press Open. Now the Design Properties/Design Level Settings are the same as in the original design.

P.S. If you want ALL your designs having the same design level settings simply check the “Use global design level settings” box and no need to do any export/import.

P.S.2. You might be interested in this too: helifromfinland.blog/2017/10/13/default-system-types-directory/

Now in Data Modeler 17.3 you can find those Design Properties also under Tools menu by a name Design Level Settings:

These are the sames you can still find under Design Properties too and you should definitely check them (either under Design Properties or Design Level Settings), because they are important.

P.S. You might be interested in this too: helifromfinland.blog/2017/10/13/default-system-types-directory/

]]>https://helifromfinland.blog/2017/10/12/design-level-settings/feed/0helifromfinlandDesignL0DesignL1Where are my domains?https://helifromfinland.blog/2017/10/12/where-are-my-domains/
https://helifromfinland.blog/2017/10/12/where-are-my-domains/#respondThu, 12 Oct 2017 05:36:24 +0000http://helifromfinland.blog/?p=3035Continue reading →]]>I just upgraded Data Modeler to the latest release/installed Data Modeler to a new computer but all my domains are gone. Is there any way to get them back or do I need to define them manually again? Of course there is a way!

Select File, Import, Domains.

Then find the file your domains are saved to using Open Domain File.

Import.

Go and check the domains.

And there they are.

P.S. You might be interested in this too: helifromfinland.blog/2017/10/13/default-system-types-directory/

]]>https://helifromfinland.blog/2017/10/12/where-are-my-domains/feed/0helifromfinlandDomains1Domains2Domains3Domains4How can I change the table/column names to uppercase?https://helifromfinland.blog/2017/10/11/how-can-i-change-the-tablecolumn-names-to-uppercase/
https://helifromfinland.blog/2017/10/11/how-can-i-change-the-tablecolumn-names-to-uppercase/#respondWed, 11 Oct 2017 16:27:52 +0000http://helifromfinland.blog/?p=3016Continue reading →]]>When I desing the ER model I want to use mixed case naming but in my tables I want to have all the names uppercase. Is there a way to automatically change the names uppercase? YES!

These are my tables and as you can see the names of the tables and some of the columns are very mixed cased notation. What I need now is a Transformation Script:

In the Custom Trasformation Scripts I can find a script called Tables to upper case – Rhino.

I press Apply. And this is what I get:

]]>https://helifromfinland.blog/2017/10/11/how-can-i-change-the-tablecolumn-names-to-uppercase/feed/0helifromfinlandUpper1Upper11Upper15Upper2How can I create triggers automatically for the journaling columns?https://helifromfinland.blog/2017/10/11/how-can-i-create-triggers-automatically-for-the-journaling-columns/
https://helifromfinland.blog/2017/10/11/how-can-i-create-triggers-automatically-for-the-journaling-columns/#respondWed, 11 Oct 2017 16:12:14 +0000http://helifromfinland.blog/?p=2985Continue reading →]]>Every single table in our database has columns USER_CREATED, USER_MODIFIED, DATE_CREATED, DATE_MODIFIED. Is there a way to get Data Modeler to create the triggers for inserting data to those columns? YES!

]]>https://helifromfinland.blog/2017/10/11/how-can-i-create-triggers-automatically-for-the-journaling-columns/feed/0helifromfinlandTableDDL1TableDDL2TableDDL3TableDDL4How can I get technical columns to the relational model?https://helifromfinland.blog/2017/10/11/how-can-i-get-technical-columns-to-the-relational-model/
https://helifromfinland.blog/2017/10/11/how-can-i-get-technical-columns-to-the-relational-model/#respondWed, 11 Oct 2017 15:52:56 +0000http://helifromfinland.blog/?p=2964Continue reading →]]>I always define columns like USER_CREATED, USER_MODIFIED, DATE_CREATED, DATE_MODIFIED for my tables but I would not like to design them in the logical model. Is there a way to get them automatically to the relational model? YES!