• About Heli

HeliFromFinland

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

HeliFromFinland

Category Archives: Data Modeler

Oracle SQL Developer Data Modeler

Generate REST services

17 Friday Apr 2020

Posted by Helifromfinland in Data Modeler, Database design

≈ 2 Comments

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

 

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

09 Wednesday Oct 2019

Posted by Helifromfinland 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 Helifromfinland in Data Modeler, General, Oracle

≈ 2 Comments

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 Helifromfinland 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 Helifromfinland 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 Helifromfinland 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

Reporting with Data Modeler 17.3

28 Saturday Oct 2017

Posted by Helifromfinland 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 Helifromfinland 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…

 

Sharing Design Properties/Design Level Settings

12 Thursday Oct 2017

Posted by Helifromfinland in Data Modeler, Database design

≈ Leave a comment

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.

Export.jpg

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/

 

Design Level Settings

12 Thursday Oct 2017

Posted by Helifromfinland in Data Modeler, Database design

≈ Leave a comment

I am sure you remember there are Preferences and Design Properties in Data Modeler. Preferences affect all the designs in a Data Modeler installation (in that computer) whileas Design Properties affect only that design they are defined for.

 

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

DesignL0

 

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.

DesignL1

 

 

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

 

 

← Older posts

Subscribe

  • Entries (RSS)
  • Comments (RSS)

Archives

  • 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

  • Register
  • Log in

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
  • Follow Following
    • HeliFromFinland
    • Join 49 other followers
    • Already have a WordPress.com account? Log in now.
    • HeliFromFinland
    • Customize
    • Follow Following
    • Sign up
    • Log in
    • Report this content
    • View site in Reader
    • Manage subscriptions
    • Collapse this bar
 

Loading Comments...