Stack Overflow
Stack Overflow

Questions tagged [erwin]

CA ERwin Modeling provides a collaborative data modelling environment to manage enterprise data.

CA ERwin® Modeling provides a collaborative data modelling environment to manage enterprise data.

Both business and technical stakeholders can have a common view of information in context, through both a web-based portal and desktop-based design tools supported by an enterprise-class model repository. With a centralized view of key data definitions, you can have a better understanding of corporate data, managed in a more efficient and cost-effective way—using Collaboration by Design.

48 questions
0
votes
0 answers

C# Exception on creating a instance of a object of a Erwind DLL

// I must to create a program that run by a DLL library of the //Software Erwin. // I imported the DLL the project and this is the code : // The exception is : Error 80040154 unregistered interface // What' s wrong ? How I can do that ? // …
Christian Scarselli
  • 67
  • 10
0
votes
0 answers

Erwin commuity editon and ms-access

I am looking for examples or tips related to developing logical and physical data models and to forward engineer same to MS Access. In r9 of the community edition, there is no output specific for Access. I'm hoping someone has an example (vba) for…
Orange
  • 73
  • 1
  • 1
  • 7
0
votes
2 answers

Cross-table data validation

need your help I have 2 connected entities: library reader (subscriber) and book issues. Reader can be locked for some period in days because of breaking library rules: I need to add check so that reader, who's lock period isn't ended yet, couldn't…
JGDger
  • 105
  • 1
  • 5
0
votes
1 answer

Exporting ERwin models to XML or .erwin files programmatically

I have a requirement to programmatically export models in ERwin data modeler. The exported files could be saved in a directory (on server or local machine). We also want the process to export only the models that were changed after previous…
Vivek
  • 1
  • 1
0
votes
1 answer

How to schedule tasks in Erwin Data Modeler?

I am using Erwin Data Modeler 9.5. I want to automate a task for copying Master model copy to local drive every week at a particular time. Is that possible? Is there any add in that we can add in Erwin data modeler and schedule a task? Kindly guide…
Amogh
  • 11
  • 2
0
votes
1 answer

Convert ER-Win model to Aqua Data Studio

I am looking at converting some existing CA ER-Win data models (.erwin [9.x file]) over to Aqua Data Studio. Is there any direct way of doing this? One can of course do a forward engineer into a DB and the reverse engineer. However, that kind of…
El Architect
  • 138
  • 1
  • 5
0
votes
2 answers

Customizing Industry standard data models

I am considering using a industry standard data model, more specifically ACORD reference data model for an insurance company. The standard model is developed to support data requirements of a a typical property and casualty insurance company. One…
john paddington
  • 1
  • 1
0
votes
1 answer

Trouble inputting code from Erwin in access (mostly with datatypes)

This is quite a basic level question sorry, I've only been doing this a couple of weeks. Our task is to create a database in both Oracle and Access after generating our model in Erwin. The model has been created in Erwin, and we generated the SQL…
Maki
  • 1
  • 2
0
votes
1 answer

How to represent a descriptive attribute of a relationship in ERwin modeler?

In the modeler, relationship is represented by a line between two entities. It would be no problem if the relationship has no descriptive attributes. But if it has, how can I represent the descriptive attributes? For example, the relationship set…
user4147874
  • 61
  • 10
0
votes
1 answer

Import a table from oracle 11g to create ER diagram using ERWIN tool

I am trying to import the table from the oracle database into the Erwin tool in order to create the ER diagram. can anyone please let me know how i can do this???
user3361609
  • 11
  • 1
  • 3
0
votes
2 answers

Subtracting 2 values from a query and sub-query using CROSS JOIN in SQL

I have a question that I'm having trouble answering. Find out what is the difference in number of invoices and total of invoiced products between May and June. One way of doing it is to use sub-queries: one for June and the other one for May, and…
fixnode
  • 97
  • 3
  • 8
  • 32
0
votes
1 answer

Oracle: Using Sub-Queries, JOIN and distinct function together

Here is how I contructed the step-by-step: M1. create a sub-query that will return CustomerId and total invoiced for that customer M2. A second subquery that will give a list of distinct ProductIDs (along with product SKUs) and CustomerIDs. M3. The…
fixnode
  • 97
  • 3
  • 8
  • 32
0
votes
1 answer

Exporting Visio 2010 Database Diagram to Erwin

I have an ERD in MS Visio 2010 64-bit Edition. I would like to get the diagram into CA Erwin 7.3. Ideally, I'd like to find something that exports from Visio into a format that Erwin understands (I've read a lot about ERX - Visio doesn't seem to…
StewartR
  • 1
  • 3
0
votes
1 answer

3NF Database normalization (Erwin)

I have a table and I'm trying to split it in a few more tables to get a 3nf, can someone help me? When I validate my tables with Erwin Data Model Validator I get no warnings...but it's not a 3nf( http://i43.tinypic.com/35mmuwx.png and my Erwin…
user1343639
-1
votes
1 answer

Why the same nsm file(Naming Stardard file) can translate words to Abbrivations in one erwin file, but it doesn't work for another erwin file?

the nsm file is like this and it successfully translated for one erwin. See below picture. but I don't know why the same nsm file doesn't work for another of my erwin file? I don't know what the difference with these two erwin file. Maybe some…
TonyRen
  • 11
  • 4
1 2
3
4