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
4
votes
0 answers

Ways to documment ETL job

the question I got might be little general and so not the best for StackOverflow- sorry for that. However, I'm googleing for answer and not finding any. In our DWH project (AWS S3 + Redshift + informatica) we have hundreds of ETL jobs. Each ETL job…
awenclaw
  • 373
  • 5
  • 20
4
votes
1 answer

Viewing a .ERWIN file

How can one open/view a .erwin file if your company does not have an ERWIN licence? Is it possible? Requesting an alternatively formatted file is not an option.
Allan Bowe
  • 12,306
  • 19
  • 75
  • 124
2
votes
0 answers

How to retain foreign key names in DDL generated by Erwin for MySQL?

I'm using ErWin 9.5 to generate DDL for MySQL 5.6 and have hit a snag when creating a foreign key. MYSQL does not use foreign key name generated by ErWin because the CONSTRAINT statement is not included in the DDL. The DDL ErWin generates for a…
Gary Hochron
  • 21
  • 1
1
vote
2 answers

HAPI FHIR - Data Model - Entity Relationship, does anyone have a link to an ERD model that is based on FHIR

I'm looking for an ERD based on the fundamental concepts of HAPI FHIR. I have access to a number of Data Architect tools (Erwin / PowerDesigner) and wanted to know if anyone has a model they can perhaps share or point to. Thanks
karim jessani
  • 11
  • 2
1
vote
2 answers

Erwin API with Python

I am trying to get clear concept on how to get the Erwin generated DDL objects with python ? I am aware Erwin API needs to be used. What i am looking if what Python Module and what API needs to used and how to use them ? I would be thankful for…
devopsnow
  • 11
  • 2
1
vote
0 answers

Not able to copy column names from erwin data modeler into a text file

I am new to Erwin data model tool. I want to copy the column names of a table into a text file, but I am not able to do by any means. Could you please help me to know how Can I achieve this. Thanks Priyaranjan
Priyaranjan Swain
  • 361
  • 4
  • 17
1
vote
1 answer

Using Erwin to create DDL for Amazon Redshift

Has anyone been successful in creating DDL using Erwin for Amazon Redshift? If not, does anyone know of a way to convert, say a MySQL DDL from Erwin, to an Amazon Redshift compliant DDL? I understand that Redshift is based on PostgreSQL 8.0.2.…
Raj
  • 549
  • 2
  • 11
  • 25
1
vote
0 answers

what is the connection string for forward engineering into oracle databases with CA erwin

I tried using the green checkmarked solution in What is the format of connection string that should be used while using ERWin tool for generating ERD for an Oracle database? typing it out as I found it in the tns.ora docs. Maybe I am doing…
user7364229
  • 9
  • 2
1
vote
0 answers

CA Erwin 9.0 - Is there a way to add a suffix or prefix to all the columns in a single table

CA Erwin 9.0 - Is there a way to add a suffix or prefix to all the columns in a single table in Erwin . I have tried using the "Model Naming Option" , however it renames all the attributes in all the entities . This is for my logical model .
renjith madhavan
  • 85
  • 8
1
vote
1 answer

How to get the ERWIN diagram in one model into another model

There is a diagram in the first model say model 1 and i need to get the diagram into the 2nd model say model 2. Is ther any way to do this in ERWIN? I have copied the diagram form the first model and tried to paste it on a balnk diagram diagram…
user1254579
  • 3,901
  • 21
  • 65
  • 104
1
vote
1 answer

What is the format of connection string that should be used while using ERWin tool for generating ERD for an Oracle database?

I have been trying to generate an ERD for some oracle database. While I am doing this via 'Actions'->'Reverse Engineering' option, I get a section that asks me for a connection string. But I am unsure of the format about how we can specify the…
pradeepradyumna
  • 952
  • 13
  • 34
1
vote
3 answers

Export erwin to xml - caveats

We're using Erwin 7.x to model our database. The process becomes very painful when we need to work on multiple versions of it - erwin format is binary and not automatically mergeable. So, what I did is I exported the model to an XML file, cleaned it…
Maxim Balaganskiy
  • 1,524
  • 13
  • 25
1
vote
1 answer

Is there a high resolution ERwin data model (.emf) viewer?

Our data modelers are using ERwin v.8 and I need usable physical data models from it, however, the output is terrible being in a .emf format. Viewing the images in a browser doesn't work as the text becomes too heavily pixelated when zooming to…
Air_Cooled_Nut
  • 129
  • 3
  • 5
  • 21
1
vote
3 answers

How to perform data lineage using Erwin

Data lineage is defined as a kind of data life cycle that includes the data's origins and where it moves over time. This term can also describe what happens to data as it goes through diverse processes. Data lineage can help with efforts to analyze…
Sindu_
  • 1,347
  • 8
  • 27
  • 67
0
votes
0 answers

Importing a SQL file created through Python into Erwin Data Modeler

I am trying to import into Erwin Data Modeler a .sql file created through Python, but when I import the file it creates an empty model. I have tried copying and pasting the sql script into a notepad and then import the new file and it works, so the…
Bebba
  • 27
  • 3
1
2 3 4