Book a Demo

Author Topic: How to print the list of links (relationship)  (Read 3550 times)

w0w0w0w

  • EA Novice
  • *
  • Posts: 2
  • Karma: +0/-0
    • View Profile
How to print the list of links (relationship)
« on: October 31, 2014, 09:06:27 pm »
Hi,

I have a conceptual model done in EA that I need to importo into Embarcadero Business Architect. I know that from EA I can export to XMI and then import into ER Data Architect and from it to business architect but doing so I loose some info in the model, colors, etc.
Cause the model is comprise about 60 classes I can easily recreate it in business architect. However, I have found a way to print all classes with notes, but there is no way (or I do not find) a way to print out a list relationship, basically: parent - child - type of rel (1..0,1 1..1, 1..many).
Is there a way to do it?

thanks
Ste

qwerty

  • EA Guru
  • *****
  • Posts: 13584
  • Karma: +397/-301
  • I'm no guru at all
    • View Profile
Re: How to print the list of links (relationship)
« Reply #1 on: October 31, 2014, 09:52:03 pm »
You could create a search within t_connector and export the result as csv.

q.

w0w0w0w

  • EA Novice
  • *
  • Posts: 2
  • Karma: +0/-0
    • View Profile
Re: How to print the list of links (relationship)
« Reply #2 on: October 31, 2014, 10:09:51 pm »
Quote
You could create a search within t_connector and export the result as csv.

q.

Good....can you give me more help? sorry I do not very well the product.

qwerty

  • EA Guru
  • *****
  • Posts: 13584
  • Karma: +397/-301
  • I'm no guru at all
    • View Profile
Re: How to print the list of links (relationship)
« Reply #3 on: November 01, 2014, 02:55:12 am »
Try
Code: [Select]
SELECT o1.name, o2.name,  c.*  FROM t_connector as c, t_object as o1, t_object as o2
where c.Start_Object_id = o1.Object_ID and c.Start_Object_id = o2.object_id
In the Find/Builder/SQL tab. You will likely limit the result set for the connector to what you actually need.

q.