Author Archives: Helifromfinland

Generate REST services

17 Friday Apr 2020

Posted by in Data Modeler, Database design

≈ Leave a comment

While generating the DDLs for the table you can also generate the REST services for the table easily.

To generate the DDL select File, Export, DDL File.

ddl

Then select the RDBMS Site and the relational model wanted and press Generate.

ddl2

Select Generate REST Services.

ddl3

And the script now not only includes the table generation (and whatever else you chose) but also REST enabling scripts.

ddl4

P.S. If you want to isolate the tables from users with views, you can easily create a view for a table (and then grant privileges to views instead of tables). Just like described above you can create the REST services for views as well.

To create the views for tables select Tools, Table to View Wizard.

view

Select the tables wanted.

view3

And then generate the DDLs as described.

view2

 

OGB Appreciation Day: free cloud and people

10 Thursday Oct 2019

Posted by in Events

≈ Leave a comment

Thank you, Tim Hall (oracle-base.com), for the OGB Appreciation Day!

First of all I am thankful for the people like Tim and for the people at Oracle who do not care if it’s Saturday or Sunday, they just want to help me to be able to use Oracle products better. I want to mention two names particularly: Jeff Smith and Joel Kallman. There has been several weekends I have been struggling with the weirdest problems, and in 5 min they have been helping me to solve it. Thank you! This community, including customers, partners and Oracle, is just amazing!

 

Then about the technology. Today I am extremely thankful for the Always Free Services! This is an amazing offer from Oracle! Thank you!

cloud.oracle.com/free

 

Thank you! #ThanksOGB

Heli

I am so sorry for not responding your questions and something about Windows 7

09 Wednesday Oct 2019

Posted by in Data Modeler, General, SQL Developer

≈ Leave a comment

Dear reader,

my sincere apologies for the slow replies on your questions. I have been too busy with my work, travelling, speaking, studing, teaching and researching. I will try to improve. Please keep asking and I’ll do my best to reply.

 

Oracle SQL Developer Data Modeler 19.2 is out. Just like SQL Developer, Oracle Instant Client and many other Oracle products 19.2 version is not supported on Windows 7. So if you are still a Windows 7 user, you might want to upgrade to Windows 10. If that is not possible, consider using version 18.2 of these products until you are ready to upgrade. I personally know that you will have problems with Win7 and SQL Developer 18.3+/Instant Client 19 and that they work perfectly well on version 18.2 on Win7 so it is possible that Data Modeler might have some issues as well on Win7.

 

Best regards,

Heli

ODC Appreciation Day: Oracle SQL Developer Data Modeler

11 Thursday Oct 2018

Posted by in Data Modeler, General, Oracle

≈ Leave a comment

I know this is too obvious coming from me but Data Modeler is my favourite tool and I use it every single day. Without Data Modeler I could not do my work and design databases well and efficiently and without it I could not show other people how easy and important it is to design databases. 18.3 just came out and it is ever better than the previous versions!

https://www.oracle.com/technetwork/developer-tools/datamodeler/downloads/index.html

Thank you ODC for Oracle SQL Developer Data Modeler!

Finding objects that have a certain property “null”/”empty”

28 Thursday Jun 2018

Posted by in Data Modeler

≈ Leave a comment

How can I find all the tables in SQL Server 20112 physical model that has the Text image  defined empty?

Right-click on the Browser on the physical model you want to search. Select Search. Select Advanced Mode. Select Table, press Add Property and select Text image fg as a property. Press Search.

TextImage

These are all the tables having Text image property null/empty.

The same works for any searches on logical, relational or physical property searches.

 

Setting a property to “empty” for several objects

28 Thursday Jun 2018

Posted by in Data Modeler

≈ Leave a comment

In many cases I need to find those properties that are not “empty” and set the property to “empty” to all of those. One example is when I’m desiging a data warehouse and the source tables (which I will reverse engineer as a base for the DW tables) have default values. I do not want to have default values for my DW!

Let’s see an example.

First I need to find the entities (all tables or physical tables) that has a default value.

Start Search either by pressing the Search icon in the Tool bar or right-click on the Browser on the logical model and select Search.

Select Advanced Mode. Select Attribute. Press Add Property. Select Default value. Choose Not.

Empty

And press Search.

Empty2

Then press Properties.

Empty3

Select Default value and press the arrow pointing to left, select “empty string”. Press Apply.

Empty4

Now the default value property for all the attributes listed as Serach result have been updated to empty.

 

Empty5

You can use this same method for changing any properties of logical, relational or physical model to empty.

 

 

 

 

Oracle SQL Developer Data Modeler 17.4

29 Friday Dec 2017

Posted by in Data Modeler

≈ 1 Comment

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.

If you have not downloaded it yet, do it today: http://www.oracle.com/technetwork/developer-tools/datamodeler/downloads/index.html

Why did I waited for it? Because of, for instance, these bug fixes:

27245333 – IMPORT OF DDL AS ORACLE 12CR2 DOESN’T RECOGNIZE DATA TYPES
27182476 – SQL SERVER 2012 DDL GENERATION FAILS WITH CLASS CAST EXCEPTION
26985782 – STANDARD REPORT – COLUMN DATA TYPE IS NOT INCLUDED WHEN COLLECTION
27040952 – DESIGN PROPERTIES DIALOG DOESN’T WORK
26988362 – IMPORTING LEGACY PHYSICAL MODEL RESULTS IN TABLE ITEMS LISTED RED IN HIERARCHY
27041167 – REVERSE CLAUSE FOR INDEX IS NOT PROCESSED DURING IMPORT FROM DATABASE
26918584 – SYNC TO DB CANNOT RECOGNIZE TABLES WHEN PROXY USER IS USED
26919656 – PROBLEMS WHEN EDITING UDP FOR ATTRIBUTES IN ENTITY DIALOG
26750611 – INVALID INSERT STMT ON ‘USE QUOTED IDENTIFIERS’ CHECKED AT DDL PREVIEW SCRIPT
26920080 – “INCLUDE SCHEMA IN DDL” SETTING IS NOT CONSIDERED FOR PROCEDURES
26932946 – ANNOYING BEHAVIOR WHEN CREATING COLUMNS

On my way HOME…

05 Tuesday Dec 2017

Posted by in Events

≈ Leave a comment

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

 

 

Reporting with Data Modeler 17.3

28 Saturday Oct 2017

Posted by in Data Modeler, Database design

≈ Leave a comment

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:

reporting1

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:

reporting3

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

reporting2

 

Default System Types Directory

13 Friday Oct 2017

Posted by in Data Modeler, Database design

≈ 3 Comments

Why would I define the Default System Types Directory in Preferences?

SystemTYpes

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:

Report templates
Report configurations
Saved searches
Custom report templates
Domains
RDBMS Sites
Custom Scripts
Types
Global Design Level Settings

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