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
0
votes
1 answer

Customisation of PowerDesigner model

I've got a DWH logical model in SAP PowerDesigner. How can I choose the properties to display on the diagram? For example, instead of showing the Attribute's data type on the scheme, I would like to represent its description. I've tried doing…
Philipp
  • 183
  • 1
  • 9
0
votes
0 answers

Powerdesigner Issues Converting Logical Model to Physical Model

I have this logical model And I have some domains that I created as helpers I generate a PDM: In the table, the columns are associated with a domain, depending on the datatype intended. When I get my generated PDM, the domain name is used as the…
Ken Ingram
  • 1,538
  • 5
  • 27
  • 52
0
votes
1 answer

Recover Powerdesigner auto save file 16.7

Powerdesigner crashed and I can't find my files. Under General Options > General I set "Save recovery backup file" to every 5 minutes but cannot find any recovery file.
J. Doe
  • 522
  • 6
  • 22
0
votes
0 answers

Generating SQL data with CSV files Powerdesigner with 16.7

It is possible to create test data for a Physical Data Model. PowerDesigner creates then for every table a CSV file with test data. Is it possible to feed a PDM in Powerdesigner with CSV files (The other way round)? Example: I have folowing table ID…
J. Doe
  • 522
  • 6
  • 22
0
votes
1 answer

How to create a Trigger and assign a TriggerTemplate using PowerDesigner VBScript?

I'm using PowerDesigner v16 and I created an Extension; in this Extension a MetaClass of the Table type was added; in this MetaClass an Event Handler was created, using VBScript, to go through all the tables and create some fields / columns…
0
votes
1 answer

PowerDesigner engineering Unicode

I am using PowerDesigner to model my SQL Server database. I am creating a Physical Data Model. My problem is that comment data does show "???" instead of a text I entered. Does anybody know how to get the root of the problem?
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…
0
votes
1 answer

Enterprise Architect add-in .dll crashes when deployed on to a Windows 7 machine

I have created a C# add-in in VS2015 to import and synchronise data models from Power Designer into Enterprise Architect. It has dependencies for PDPDM, PDLDM, PDCDM, and Interop.EA. The problem is that it crashes when I deploy and then run it on a…
0
votes
0 answers

can't generate the foreign keys in mysql ddl generation with PD9

i'm using PD9.5. i'm generating ddl for mysql 3.23.but under the "generate database" below, in the "keys & indexes" tab, i dont have "create foreign key" option checked and i cant do it. but when i change the target to oracle 9i, i get the foreign…
satcha
  • 129
  • 1
  • 13
0
votes
2 answers

Polymorphism association in Sybase PowerDesigner

I want to make polymorphism between 4 Entities in Sybase PowerDesigner tool, but there is no explanation how to do this in conceptual data model. Can you help me with this?
dormitkon
  • 2,526
  • 4
  • 39
  • 60
0
votes
0 answers

Can I insert column/field comments in PowerDesigner to be used in a generated report?

I have a Conceptual Model in PowerDesigner with 150+ tables and a few thousand columns/fields in total. The columns have been documented separately outside of powerdesigner and I would like to import/insert these comments to each column/field. Is…
0
votes
1 answer

How insert default columns when creating a table in PowerDesigner

We have several columns that are required in all tables. Columns are used for audit, record dates, etc. What is the process for configuring PowerDesigner to automatically add these columns to the table when created in the physical model? I am using…
0
votes
1 answer

Use Guid type in SAP PowerDesigner

I would like to use a GUID for the type of my primary key. Do you know how to do that in SAP powerdesigner 16.5 ?
Toothgip
  • 469
  • 6
  • 14
0
votes
1 answer

Datatype equivalent to nvarchar(max) in powerdesigner

I created PDM from LDM in Powerdesigner.I need to generate the DB scripts for SQL Server 2014 Database. In create table script , I have one column : status nvarchar(max) null, I need a equivalent column in Powerdesigner to nvarchar(max) datatype. I…
Vasu
  • 9
  • 1
  • 5
0
votes
0 answers

powerdesigner : Edit column length

I imported all entities and attributes from excel and generated Logical Diagram in PowerDesigner. From Logical , I created Physical Diagram. But to generate sql scripts I need to update the column length for each tables. I tried to update the…
Vasu
  • 9
  • 1
  • 5