Stack Overflow
Stack Overflow

Questions tagged [powerdesigner]

PowerDesigner is an enterprise modeling tool from SAP.

PowerDesigner is an enterprise modeling tool from Sybase, an SAP company.

It runs on Windows, and allows modeling Data, Business Process, Object-Oriented system (using UML), XML schemas, Enterprise Architecture... It features code generation and reverse engineering and has a module to allow collaboration between several designers.
There is another module providing a Web interface.

It's quite extensible, allowing the definition of user-defined metaclasses, meta-attributes, meta-collections; or through an Automation interface.

In France, there used to be a version named PowerAMC, with support for the MERISE method. Now PowerDesigner has a French optional UI, and the Merise module is obsolete.

198 questions
11
votes
2 answers

PowerDesigner - Prevent DB name to be uppercase in generated SQL

I am currently beginning playing around with Sybase PowerDesigner and its Physical Data Model (PDM). I have managed to create some entities/tables, columns, et cetera, and the case in the generated SQL (to create the database from the model) is like…
JC P
6
votes
1 answer

How to specify a database schema in PowerDesigner

I want to export my model to a PostgreSQL database. If I do so as is, the objects are built in the Public schema, because the model doesn't specify a schema, and Public happens to be the default. Does anyone know a way to specify a schema in…
Henry
  • 600
  • 2
  • 7
  • 22
5
votes
2 answers

Inheritance in CDM/LDM models in PowerDesigner 15.3?

I downloaded PowerDesigner 15.3's trial version, and I want to build a Logical Data Model of a database. The problem is that this database must use inheritance heavily, and I can't find a way to build an inheritance relationship... The 'Inheritance'…
Miguel
  • 3,466
  • 8
  • 38
  • 67
5
votes
3 answers

Conceptual model vs Logical model vs Physical model

I'm doing a work about database, and now I need to show three different images, one image with the conceptual model, other with logical model and other with physical model of a database. But Im here with some difficults to understand which image…
UserX
  • 1,295
  • 7
  • 25
  • 39
4
votes
1 answer

How to generate SQL tables from ER diagram in Power Designer 15?

I want to generate Sql tables from ER diagram in Powerdesigner ,but ,I don't know how can i do that? Which Tools i should use?
aden
  • 1,907
  • 3
  • 16
  • 16
4
votes
2 answers

Add a comments for tables columns in a physical data diagram

I can see my column comments through double-clicking on table and selecting a Columns tab. But when I choose Display Preferenses-> Table-> Advanced...-> Columns-> List Columns [select] - I cant't find this attribute "Comment" there. Is it possible…
egor7
  • 4,678
  • 7
  • 31
  • 55
4
votes
1 answer

How to enable PowerDesigner 16.5 auto increment primary key for MySQL database?

I am using PowerDesigner 16.5 to model my MySQL database. Anybody knows how to enable its auto-increment primary key feature?
5YrsLaterDBA
  • 33,370
  • 43
  • 136
  • 210
4
votes
2 answers

differance between ER Diagram and Entiy Assication Diagram

I am trying to create a conceptual data model using PowerDesigner, I found a conflie between two methods: Create two entities and relations between them Create an association and three entities and two relationships. knowing that both methods give…
user2354035
3
votes
4 answers

How do you convert a document in UML 1.3 - XMI 1.1 format to UML 2.1 XMI?

I am trying to convert a file exported from PowerDesigner in the UML 1.3 - XMI 1.1 format to the UML 2.1 XMI Interchange Model from Rational Software Architect. How can I do this?
DFG
  • 2,217
  • 3
  • 22
  • 24
3
votes
4 answers

PowerDesigner + Reverse engineering

I am using PowerDesigner to model my SQL Server database. I used the reverse engineering option in order to import my database. My problem is that the default data in the tables is not imported. Does anybody know how to import the data in the…
Ghyath Serhal
  • 7,466
  • 6
  • 44
  • 60
3
votes
3 answers

Sybase PowerDesigner Change Many (Find/Replace/Convert) Data Item's Data Types

I have a relatively large Conceptual Data Model in PowerDesigner. After generating a Physical Data Model and seeing the DBMS data types, I need to update all of data types(NUMBER/TEXT) for each data item. I'd like to either do a find/replace within…
whitespy9
  • 148
  • 3
  • 10
2
votes
2 answers

How to hide the symbol number on PowerDesigner?

In Sybase PowerDesigner, when designing an UML diagram that takes 2 copies/instances of the same XXXX object (ie. objects), the application adds a number identifier like "XXXX : 2" to that symbol. Is it possible to remove it? Thanks in advance!
luizcancado
  • 21
  • 1
  • 3
2
votes
1 answer

Does SAP PowerDesigner have an API?

Does PowerDesigner have an Java/Python etc. API that can be called so that I can retrieve a physical table's columns and data types programmatically? Googling did not help me locate a documentation and possibly a tutorial. Any directions would me…
laplacesdaemon
  • 21
  • 4
2
votes
1 answer

Activity diagram multy-choice at the beginning

I am working on my first activity diagram and I really got stuck. To be more specific its about Sudoku game. Well what my problem is, let's say that user at the beginning has option to choose game difficulty. For example hard easy and medium…
Milos
  • 394
  • 2
  • 19
2
votes
3 answers

how to generate sqlite database from CDM Model in PowerDesigner?

I have a Conceptual Data Model in powerdesigner and I want generate Sqlite DB from it, how to generate sqlite database from CDM Model in PowerDesigner?
zahra
  • 21
  • 3
1
2 3
…
13 14