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

URL of a ERwin data model

I would like to post the URL of a ERwin logical data model on a Word page so that when someone clicks on they can view the model. Is there a way to do it? I tried to copy the model at the top from ERwin but it is not a clickable URL, nor does it go…
sjobs12
  • 1
0
votes
0 answers

How to generate DDL script for schema differences with Python?

i`m looking for ways to generate DDL ALTER script between different versions of the same model using python. Let`s say i have two DDL scripts for different versions of the model(newer and older), i need to compare those two and then generate DDL…
bogomol
  • 1
0
votes
0 answers

Erwin 2021 - Selecting DynamoDB as Target

We recently upgraded to Erwin DM 2021 R1 and I am attempting a POC for a DynamoDB design. However, I don't see it listed as a Target Database option when creating my Erwin model. What am I missing? Thanks J.R.
JRansdell
  • 1
0
votes
1 answer

Unable to remove index in SQL Server

When the user activates the FK index removal option, DDL is generated for it, and when the PK index removal option is activated, the DDL is created for this application. Two tables were created with the example below. CREATE TABLE [dbo].[TABLE3] ( …
user13746660
0
votes
0 answers

Salesforce datamodel from Erwin DDL

I'm relatively new to salesforce - trying to create a custom application with 20+ custom objects, fields, relationships etc. I have built the physical model in Erwin data modeller. Is it possible to use DDL from erwin to create data model in sales…
Sunny
  • 1
  • 1
0
votes
1 answer

Creating a header with custom model information in erwin generated ddl

What is the most practical, automated way to generate a header comment with model information such as title, author, model version, db version, create and last modification date in an Erwin generated ddl script taken from the physical or better…
matz3
  • 88
  • 8
0
votes
1 answer

Erwin data modeler 2020 R1 copy definitions from another database's template

We are using Erwin Data Modeler to document our databases.  We have already finished with one of our databases (started from reverse engineering and compiled manually all the entity and attribute definitions) and now moved on to the second…
erik
  • 1
0
votes
1 answer

ERD files from Common Data Model - how to open? Erwin / PowerDesigner?

I'm trying to access the ERD files here: https://github.com/microsoft/Industry-Accelerator-Health/tree/master/documentation Now, I would prefer to use a tool like PowerDesigner / Erwin to actually see the Physical Structure. Any suggestions would…
karim jessani
  • 11
  • 2
0
votes
1 answer

How to list the libraries and models in Model Mart through the API?

I have written a Python script that loops through the file system and lists all of the Erwin files that I find. I then process these files in some fashion and save the results. I'm now trying to do the same thing with the repository. I can open a…
Jeff Fletcher
  • 11
  • 2
0
votes
1 answer

IMPORT DDL to CA Erwin Data Modeller r9.64 with comments

We are using Erwin to document and create our datamodels, i need to do some reverse engineering from time to time in order to import new data models after it has been developed. I have been playing around with importing DDL from MSSQL and it work…
havmaage
  • 573
  • 7
  • 25
0
votes
1 answer

Dimensional Model

I am working on a Data Migration project. The legacy system is IBM Toad DB2, and the target system is MS SQL SERVER Azure. The data at the source system is in XML format. I have to use ERwin, to first create a model and then generate the DDL, and…
Y_Architect
  • 1
  • 4
0
votes
0 answers

Need help - Could not allocate space Error while saving Erwin data model (attached pic)

I am getting this error when I am trying to save my data model in Erwin. The database for Erwin is SQL server installed on windows server. I am not from SQL server background. Need some help.
v83rahul
  • 283
  • 2
  • 7
  • 20
0
votes
0 answers

Trying to reverse engineer a Teradata view in ERwin

I am a newbie to Teradata . I am trying to create a DDL script file for a few tables and a view so I can reverse engineer them into Erwin to integrate them into an existing model. I don't have access to the schema with the underlying table for the…
DuraRangu
  • 1
  • 1
0
votes
0 answers

Are these relationships at ERwin diagram correct?

I have to create database application called "Club of alpinists". I have 5 entities: Alpinist, who can be a part of a Team which go to a peak, or Ascend alone. Also there is a Peak, which may have a lot of Routes. 6th entity (Membership) is…
ellie
  • 9
  • 3
0
votes
0 answers

I need the connection string for CA ERWIN Data modeler

What is the connection string value format for CA Erwin DA modeler to Oracle? I know you can't simply type in the database name. Thanks,
mitzy
  • 39
  • 1
  • 3
  • 9
1
2
3 4