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

Read triggers definition in PowerDesigner

How to read triggers definition from database when use option "Update Model from Database" in PowerDesigner 16? This option recognizes that I have new triggers in database and read them, but Definition field is empty. Inspecting dialog box for…
veljasije
  • 6,722
  • 12
  • 48
  • 79
0
votes
1 answer

How to determine the child of an inheritance in Power Designer

I have an entity object in Power Designer and walk through its inheritances but I do not know how to get the child object. Could someone post an example code? It is also important to get the Object ID of the inheritance. Edit: solution Idea based on…
user2722077
  • 462
  • 1
  • 8
  • 21
0
votes
1 answer

manipulating datatype in Power Designer by vbscript

How to change the column data type in PowerDesigner by VB script? I am trying to change the datatype globally in the model from varchar to varbinary, but I am unable to do it with the help with VB script.
0
votes
1 answer

PowerDesigner reverse engeering index column missing

I am having some issue with validating my physical model against a DB2 V9.7 AIX database by using the "Apply Model Changes to Database" option. After the database was successfully reverse engineered, the Index Columns were missing on the database…
0
votes
1 answer

PowerDesigner - Access BusinessRules of Model

How I can iterate in C# over the BusinessRules of a powerdesigner model? This does not work: private static void importModelPackages(PdCDM.Model pdModel){ foreach (PdCDM.ObjectCol curPDBusinessRule in pdModel.BusinessRules){ /*...*/ } }
user2722077
  • 462
  • 1
  • 8
  • 21
0
votes
1 answer

PowerDesigner backend - "Location" in PMTEXT

PowerDesigner verion: 16.5.3.1 (64-bit) Repository backend: SQL Server In our shop we structure the models in various folders/sub-folders, and the same model name can exists in multiple sub-folders. From the PowerDesigner client front-end, right…
0
votes
0 answers

Check model from VBScript in PowerDesigner and change selected objects

I need to check Physical Data Model in PowerDesigner 16.5 from VBScript and change selection of objects, which should be checked, but following test case does not work: I press F4 and create in GUI some saved (persistent) selections named Sel1 and…
morto
  • 57
  • 1
  • 6
0
votes
1 answer

Existence of relationship or association link (PowerDesigner)

Im doing a database model using PowerDesigner and Im having some alerts that Im not see how I can solve. I have some tables that have relationship, but I have 4 tables that dont have any relationship. And in tables that dont have relationship, I´m…
UserX
  • 1,295
  • 7
  • 25
  • 39
0
votes
0 answers

PowerDesigner: How to get reason for "No data can be generated for the table xyz"

I've reverse engineered a database via PowerDesigner. Now I want to create test data for this database (lot of tables, lot of references...) but failing during process with message: No data can be generated for the table xyz Unfortunately xyz are…
frlan
  • 6,950
  • 3
  • 31
  • 72
0
votes
1 answer

How to represent a use case diagram with many use cases

I'm using PowerDesigner and I have a use case diagram with one actor and 28 use cases, I'm looking for the best way to represent it in one paper. I tried the vertical center alignment of use cases, but it takes a lot of space. Can I split them in…
hichamORCL
  • 11
  • 4
0
votes
3 answers

Auto-renaming columns in PowerDesigner LDM/PDM

I want to rename columns in a PowerDesigner LDM/PDM according to the state of the Primary checkbox. To be more specific, I want the column renamed from "oldname" to "id_oldname" if Primary is checked. I think it is possible with a custom…
gemisigo
  • 205
  • 4
  • 12
0
votes
2 answers

Power designer, generate procedures before tables

I am using Power Designer to create a database model. In one of my tables, I have created a Check constraint that calls a function to validate the attribute. The script for my table creation looks like this create table tbl_Inventory ( Id …
Wei Ma
  • 3,125
  • 6
  • 44
  • 72
0
votes
1 answer

UML Class Diagram Java - what relationship connects package and class

What relationship we use to connect class and package for a class diagram? I'm using Power Designer tool.
user3385945
  • 1,245
  • 3
  • 11
  • 10
0
votes
2 answers

Reverse Engineer Database Automatically Using SAP PowerDesigner

Is it possible to automatically create (running a script) a physical database model of the (.pdm) by doing a reverse engineer of a Sybase 15.7 server? I know I can do it manually, but is it possible to do it via script?
aF.
  • 64,980
  • 43
  • 135
  • 198
0
votes
1 answer

PowerDesigner Internal Database - Relating Entities to Diagrams

I am tring to write some ETL to extract Conceptual Models, and their assoicated Diagrams and Entities, out of a powerdesigner database. So Far, I have the querys that return: 1/ The list of Conceptual Models (based on the class name 'Conceptual…
Declan_K
  • 6,726
  • 2
  • 19
  • 30