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] 3
16
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

17
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?

18
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?

19
Hi,

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

Libor

20
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.

21
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.

22
All the MDG technologies are enabled. Even that "Core Extensions".

23
There has been made substantial changes in the data modelling in version 12. We have created some application which depends on some data modelling features from version 10. Now, we would like to migrate, but we see couple of serious issues, because following elements are no more accessible in EA version 12:
   Columns - no more tagged values and additional stereotypes
   Table operation - impossible to create operations of new stereotypes (and to use its columns, pre-conditions and tagged values)
Has anybody an idea how to handle this?

24
General Board / How to generate tablespace in DDL for Oracle
« on: September 04, 2015, 12:36:27 am »
Does anybody know?

25
General Board / Re: How to change password for my account
« on: May 28, 2015, 09:18:23 pm »
Thanks

26
General Board / Re: How to change password for my account
« on: May 28, 2015, 08:37:22 pm »
Account in this forum.

27
General Board / How to change password for my account
« on: May 28, 2015, 02:01:34 am »
Does anybody know?

28
Thansks for your reply, but this not what I've asked about. I want to know, how to accomplish this in scripting. It means, I'm looking for methods in EA object model, that support this.

29
Does anybody now?

30
Thanks for yor replay. I've already investigated EA repository, so I know, that operation refence is stored in Classifier_GUID column of T_Object table. So I think your solution definitely works. But it is a bit "obscure". I suppose, there must be some method how to get the operation just by traversing properties and methods of EA objects .

Pages: 1 [2] 3