Show Posts

This section allows you to view all posts made by this member. Note that you can only see posts made in areas you currently have access to.


Topics - Bryan Donohue

Pages: [1]
1
Suggestions and Requests / Import DB objects from Oracle
« on: April 22, 2015, 03:54:48 am »
Hello, I am trying to Reverse Engineer into EA from an Oracle DB (11g).  I have noticed several discrepancies when pulling this information.  I was wondering if there is a way to customize this import (more than from the 'Import DB schema from ODBC source' window?  Or if there is any documentation specific to Data Modeling for Oracle.
Here is a quick list of the type of issues I have come across:
 - Not Null check constraints --> explicit constraints are not pulled into EA
- For VARCHAR2 column types, explicit 'BYTE' or 'CHAR' storage is not pulled.
- Materialized Views are pulled in as Tables

2
General Board / Data Model Validation
« on: May 29, 2015, 11:05:30 pm »
Hello,
Thought I would throw this question out here...
I have a data model in EA and would like to validate it.
Would I use the 'model validation' within the package menu for this?

I ask this because I tried testing this, and it does not seem to validate.
The case I use was an oracle physical data model.  I named a table something over 30 characters, and added multiple constraints with the same name.  Both of these are not allowed in oracle.
When I did the validation, EA said it was all good...

Am I using the 'Model validation' wrong?  

3
General Board / DDL Template Editor - Lists of valid macros ...etc
« on: April 30, 2015, 12:41:54 am »
Hello,
I have been playing around with DDL Template Editor in EA (V. 12.0.01211), and specifically looking at the DDL for Oracle, but I think this is a broader question/inquiry...

It is really nice how the editor signifies keywords, such as Macros, options... etc.
I also like how if you hover the mouse over the word, it will give you a little description...
My issue is, Where can I get a full list of all possible valid 'keywords'.  
My biggest concern is the field reference macros, as I am trying to display certain things in my script.
Let me give you a couple of examples...
First, please note these come from the default DDL Templates...

TEMPLATE: DDL Name, Lines 49 & 50:
   %elseIf $parameter2 == "CONSTRAINT"%
     $name=%[highlight]ddlConstraintName[/highlight]%
ddlConstraintName is clearly the Name of the Constraint (as viewed through Database Builder).  But what other properties can be displayed through macros?
<I will point out currently, I am looking for the condition info from Constraint window (lower/left hand pain).
I could not find any documentation (or search) that mentions Macros like ddlConstraintName... Where can I get these?

TEMPLATE: DDL Check Constraint
Line 15: (%[highlight]constraintProperty[/highlight]:"CHECKSTATEMENT"%)
In the above case, the command is pulling the value from constraintProperty for the property 'CHECKSTATEMENT'.  
How is this property created?  Where do I store this information?

Is there a guide or document somewhere that shows all possible values?

Thanks,
Bryan


Pages: [1]