Increased Flexibility for Oracle SQL Developer Data Modeler Diagrams in v4

thatjeffsmith SQL Developer 0 Comments

I recently talked about how you could tell the modeler to use custom classification types for your tables. But, I forgot to tell you where you could find these settings in version 4! Surprise – we moved them. Excellent… Sometimes I think developers change stuff because they’re bored or maybe even because they don’t realize even the smallest change can …

Defining Redaction Policies for Oracle Database 12c Data Models in Oracle SQL Developer

thatjeffsmith SQL Developer 5 Comments

Oracle SQL Developer Data Modeler version 4 was released as an Early Adopter just last week. You can go download it here and read about the new features here. A snippet of those new feature release notes… Masking Mask templates can be defined and used in definition of columns with sensitive information. Support for REDACTION policy definition on table and …

Oracle SQL Developer Data Modeler: What Tables Aren’t In At Least One SubView?

thatjeffsmith SQL Developer 6 Comments

Organizing your data model makes the information easier to consume. One of the organizational tools provided by Oracle SQL Developer Data Modeler is the ‘SubView.’ In a nutshell, a SubView is a subset of your model. The Challenge: I’ve just created a model which represents my entire ____________ application. We’ll call it ‘residential lending.’ Instead of having all 100+ tables …

Querying Your Oracle SQL Developer Data Modeler Designs

thatjeffsmith SQL Developer 7 Comments

Oracle SQL Developer Data Modeler has a multi-user repository that makes it very easy to control and version changes to your data models and designs. However, it’s stored in a Subversion (think files) repository. Many of our users are accustomed to having EVERYTHING stored in the database. And when something is in a database, then it can be accessed via …

How to Synch your Oracle SQL Developer Data Model to a Different Database

thatjeffsmith SQL Developer 5 Comments

First a couple of quick notes: You can synchronize your model or your database and generate an ALTER script When you import one or more objects from a data dictionary to your model, it ties that model to that particular database So the challenge presnted is: who do I compare my model against a different database and generate an ALTER …

How to Quickly Set Classification Types for Tables in Oracle SQL Developer Data Modeler

thatjeffsmith SQL Developer 0 Comments

Your relational model may for a data warehouse or star schema where you need to define a table as being a dimension or fact. Or maybe you’re like my friend who asked me this question last night: If I’m looking at about 90 Dimension tables which all have the name prefaced by “Dim” how can I assign them all to …

Won’t You Be My Neighbor? Selecting Related Objects in Oracle SQL Developer Data Modeler

thatjeffsmith SQL Developer 4 Comments

I loved Fred Rogers. He helped raise me. Nicest guy ever? So what does he have to do with Oracle SQL Developer Data Modeler? One word, ‘neighbors.’ I got a good question from a new user yesterday: Is there a quick way to add all the tables (to a subview) directly related to a specific table? First, you know what …