2017-07-02T22:56:00Z

Reading meta-data off local ERwin model.

it_user364293 - PeerSpot reviewer
  • 1
  • 4
PeerSpot user
2

2 Answers

it_user364293 - PeerSpot reviewer
Real User
2018-04-25T05:35:07Z
Apr 25, 2018

Sorry the opening line should read "I have been repeatedly assured ...".

Search for a product comparison in Enterprise Architecture Management
it_user364293 - PeerSpot reviewer
Real User
2018-04-25T05:33:15Z
Apr 25, 2018

I have been reported assured that accessing the ERwin model via SQL is possible. However I have not done, nor has my team. Our needs were fully met by the SQL/DDL that was the output from ERwin's forward engineering feature. We found it easy to cast SQL/DDL into XLS or into our meta-data repository.

My suggestion would be:

1. If access via SQL is a must for you, then persevere to find the means.
For example, building add-on capability would require such SQL-level access to the ERwin (meta) model. It is only my guess that ERwin's commercial and therefore understandable desire to protect the IP might be the hindrance. Under NDA and commercial arrangements it ought to be possible to gain access to the ERwin's meta-model.

2. Otherwise you could adopt the approach that we took.

Regards.

Find out what your peers are saying about erwin by Quest , IDERA, SAP and others in Enterprise Architecture Management. Updated: March 2024.
765,386 professionals have used our research since 2012.
Enterprise Architecture Management
Enterprise Architecture Management (EAM) solutions are designed to help organizations effectively plan, design, and manage their enterprise architecture. These tools provide a comprehensive view of an organization's business processes, IT systems, and their relationships, enabling better decision-making and alignment between business and IT strategies.
Download Enterprise Architecture Management ReportRead more

Related Q&As

Enterprise Architecture Management experts

BPMexp67 - PeerSpot reviewer
DominicMackenzie - PeerSpot reviewer
GeorgeDiaz - PeerSpot reviewer
AndersonMoura - PeerSpot reviewer
AF
MS
PP
KD