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.


Messages - bilon

Pages: [1] 2
1
Is there anybody capable to help me?

2
MDA transformations are quite new topic for me. After reading some kind of "documentation", I must say I have no idea what I should manipulate. There's some DDL Transformation, but this (according the documentation) is the process of transforming logical model into physical model. My problem is, that I have valid physical (data) model for Sql Server, but EA generates bad DDL script from it. Anyway, manipulating MDA transformations looks like pretty low level activity - it is in no way "simple workaround" of core product error.

3
General Board / Sql Server Datetime2 datatype length poorly generated in DDL
« on: September 15, 2017, 10:34:50 pm »
When setting DATETIME2 length to non-zero value, it's ok. For zero length EA generates DATETIME without length, which defaults to 7 in Sql Server. Does anybody know some workaround?

4
For index, TABLESPACE property works well, for primary{unique key it doesn't. Any idea how to do it?

5
General Board / Re: How to remove foreign keys from duplicated tables
« on: September 15, 2017, 08:12:23 pm »
No other idea?

6
General Board / Re: How to remove foreign keys from duplicated tables
« on: September 12, 2017, 08:21:03 pm »
I tried this at the very beginning. It creates completely new key.

7
General Board / Re: How to remove foreign keys from duplicated tables
« on: September 11, 2017, 06:58:39 pm »
The connectors can't overlap. They join different tables (original table with master table vs. duplicate table with master table).

8
General Board / How to remove foreign keys from duplicated tables
« on: September 09, 2017, 01:19:11 am »
I've duplicated table (through Copy / Paste element) with foreign key. I want to remove that key from the duplicate. When trying this through constraint, it tells me that correct way is through association. But I can't see any association for the duplicate in the diagram? Any idea how to do it?

9
We have recently migrated from EA10 to EA12 and some of our report templates give different rtf output then in EA10. It looks, EA12 inserts additional newline at the end of the "Notes" field. Any idea how to remove it?

10
Setting of database at the table level influences offer of physical properties for columns and constraints. For example there's a "Clustered" property for unique constraint applicable only in Sql Server. I need to know, where to find list of these properties. The reason is, that we have to implement our own user interface for data modelling. You can see the details here http://sparxsystems.com/forums/smf/index.php/topic,37596.msg237897.html#msg237897

11
This is a follow up to my post http://sparxsystems.com/forums/smf/index.php/topic,37596.0.html, where you recommended me to program our own interface (actually the same has recommended me one guy from your support).
Ok, we are trying to program our own UI. Because our classes are in fact normal tables, we need to duplicate most of standard functionality of EA. But we are not able to find resources for some features. Could you tell me where to find list of extended properties for individual databases?

12
We are trying to program our own UI. Because our classes are in fact normal tables, we need to duplicate most of standard functionality of EA. But we are not able to find sources for some features. Could you tell me where to find list of extended properties for individual databases?

13
Hi,

is it possible to find automation scripta somewhere in the object model?

Libor

14
I'm able to access tagged values using Ctrl+Shift+6, but not the properties window. Alt+1 displays property dialog for the table, not for the column.

15
Ok, here are all the problems in more detail.

1. Column description
We use EA primarily for modelling of datawarehouses. In DW world, it is common to have more fields for description of a column. One for column comment (which goes to the database), another one for business description and another one for technical description. You can check competitive CASE tools, that they, mostly, support more descriptive fields for columns. Even EA did this, but from version 12 it is no more possible. There is only one field for column description and that's all. In version 10, we added fields for business and technical description as tagged values (see pic11), but in version 12 we are not able to access these tagged values (see pic12). When migrated to version 12, our models would be unusable.

2. Column stereotype
In version 10, there was possibility to add another stereotypes to columns. We used this to add some important information about column behaviour (see pic21). But additional stereotypes are no more possible in version 12.

3. Column operation
In version 10, there was possibility to add operations of user defined stereotypes (except of standard PK, FK, unique, index, check, trigger, proc). We used it to add operations of two additional sterotypes (Phase_Basic and Phase_Update). This is no more possible in version 12. User defined operation are visible though, but not all of it's properties are accessible (we used columns, which are still accessible and pre-conditions and tagged values, which are inaccessible) and there is not possible to add such a new operations. You can see situation from versions 10 resp. 12 at pictures pic31 resp. pic32. The way we used operation columns (pic33), pre-conditions (pic34) and tagged values (pic35) you can see at mentioned pictures.

I would like to attach pictures, but it looks I'm not allowed to do it. If you give me your address, I will sent it to you.

Pages: [1] 2