Mapping from logical model to fisical model

[coimbras]

Hi to all.

Im doing a job to a company, and they use enterprise.

They use a system ERP, that is a business aplication that have tons of stuff to a lot of diferent areas, that means that they only use a small part in there area.

And my job was to identify what they use and what is important and make a class diagram between them.

But to do that and to make people understand I have to use semantic names, the same as the forms, they usually work. But the fields in database have other names and have diferent tables.

But the next step is to know where are the fields I have selected on the database.


I need to map the fields of a class and give them another name, the same as the database and define their table.

This is important because is going to be use to build a datawarehouse, so we need to have some kind of diagram that tells where is the important data in the fisical model.

Is there any away I can do this using enterprise?
I need mapping from the logical model to a fisical model.

[Dermot]

If the database tables are not already laid out - you might like look at using a MDA transform to map the abstract logical data of the classes to DDL (for the Database).  See:
http://www.sparxsystems.com.au/EAUserGuide/mdastyletransforms.htm

[coimbras]

First of all thanks for your fast help.

About the help you give me, I beleve I dont explain myself that well.


1 Step - System Analyses
__________Example______________

Form Fields

Produt_Name:
Color:

Class Diagram (PIM)(Created)
__________________
Product
___________________
Product_Name:Char
Color:Char
___________________


2 Step - Relate The PIM with the real system

And The real database is

Table name : tablexxxx
fieldx : char
fieldxx: char

Im not contruction the database, that is already created.
My job is to select just a small part of it, and represent it, in a form people can understand it. And that means using Field(column) names, like people know them from the forms they work, and not from the database tables.

I need to do some kind of mapping from the classe fields to table fields.


With the help you give I can easily convert my PIM into a DLL, but that keep using the field(column) names and classe names , and dont give me some kind of ability to tell something like

Product_name ----> fieldxxxx in tablexxxx

Some type of relation, or even in the field a option that can define this.

So that when a programmer start doing a new software and need specific data ,can look in the model, and can see that a expecific column in the diagram are in table xxx and have the name xxx.

I hope this time , my explanation can give a better description of my problem.

[Dermot]

Some Alternatives you can use:
 - Use the Attributes Alias field to document the alternative fiscal model field
 - Create a Tagged Value field for each attribute and add the fiscal definitions there (see profiles to automatte this)
 - Look at creating Activity elements from the Attributes and defining the fiscal data there - see:
http://www.sparxsystems.com.au/EAUserGuide/create_object_from_attribute.htm

[mikaeel]

We've created an Add-in for EA that enables one to easily map any two elements to each other.  In our case, we have a logical model and a physical model.  Our mapping add-in enables us to select any attribute from our logical model and map it to any attribute in our physical model.  Then we created custom reports that can show the mappings from any point of view.

[coimbras]

Ok big mistake in my english when I mean fisical = Physical. (Sorry for that)

Where can I get that Add-On. Did your company developed it?

Ok going to test the options that dermot bring to the table. And see if any of them can fulfill my needs.

And mikaeel that is exactily what I need.

If you can share that I will very grateful...

[CW]

Hi,
Are you willing to share this add-in?  It sounds really useful!
Thanks!

[bioform]

I believe that is now available in 7.5 Beta (ability to map to attributes)

David

[PV]

We've created an Add-in for EA that enables one to easily map any two elements to each other.  In our case, we have a logical model and a physical model.  Our mapping add-in enables us to select any attribute from our logical model and map it to any attribute in our physical model.  Then we created custom reports that can show the mappings from any point of view.

Hi all...

I work with Mikaeel and am the developer of the above AddIn. I dont mind sharing the application with you guys..

Here's some technical info on the AddIn (in no particular order of importance):

• Installation file is approx 1.31MB.
• Written in C#.NET and requires .NET Framework 2.0 (Minimum).
• Originally developed to use a SQL Server backend, however, we migrated to Oracle and I have changed the app accordingly. The current version will therefore work on both SQL Server/Express as well as Oracle. The app DOES NOT WORK with EAP files.
• Makes use of a number of custom tables, stored procedures and a function. All of these must be present in the same DB as the EA model (ie. in the EA Repository).
• All settings are user configurable and are stored in the EA Project as a Package with classes and attributes.
• Compiled against v7.1.834 of EA. There are some issues with the previous versions of EA. So this is the minimum EA version required.
• Includes functionality to record Metadata for classes and attributes as well. These are based on specific requirements for our project and is NOT customisable.
• Includes Reporting functionality in the form of HTML reports. These include a set of standard reports only.

The application is still under development as there are a number of new requirements which need to be catered for.

PM me if you're interested and I will see what I can do to get a copy to you.

Regards,

~ PV

[rashwini]

Can you please tell me how to execute the stored procedure defined in the same EA db