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

When exporting a SQL script, how do I conditionally quote object names that begin with a digit?

Using PowerDesigner 16.5, I am trying to export a SQL script from a model that I have reversed from an existing Oracle schema. Some object names in this schema begin with a digit. When the script is exported, these object names are emitted verbatim…
jaguild
  • 91
  • 1
  • 5
1
vote
0 answers

Unable to acces Power Designer web portal

I'm trying to access the Power Designer portal from a browser; something like this: https://powerdesigner-web/resources/index.html But the page is not loading, and this is the message displayed: This page can’t be displayed. Do you have any…
Madalin Dobrin
  • 11
  • 3
1
vote
1 answer

Creating a Ternary Relationship

How can I make ternary relationship using power designer?
Sara
  • 11
  • 2
1
vote
0 answers

How do I use the primary key of a table in a fact table? [PowerDesigner]

I have to create a database model in university and there are several tables. I want to add all of the primary keys of these tables to a fact table. But somehow I'm not able to check the "Primary key box" when using it in both tables with the same…
uknowumoe
  • 11
  • 2
1
vote
1 answer

Sequence Diagram: What is the difference?

I'm new to using Sequence Diagrams, and I'm trying to find references but too many things make me ambiguous. There are a number of questions that I will ask about this problem. From this references Ref1 and Ref2 I see a difference between Image1 1…
AdityaDees
  • 1,022
  • 18
  • 39
1
vote
0 answers

showing description in powerdesigner

I have a physical data model in powerdesigner and want to show description for every fact and dimension and their attributes in the model. Following the powerdesigner add comment column in physical data answer, I have a column shows the description…
programmer21
  • 173
  • 11
1
vote
1 answer

How to implement a Physical Data Model without Foreign Keys in PowerDesigner

I have a PDM in Power Designer that I need to implement on my Oracle database. I want to test two cases, one with the constraints like Primary Key & Foreign Key and one without those constraints. I don't know how to do the 2nd case, do I need to…
LPK
  • 526
  • 2
  • 21
1
vote
0 answers

Database generation in powerdesigner

I designed a PhysicalDataModel (PDM) in SAP powerdesigner that contain 280 tables with indexes,primary keys, foreign keys and sequences. I've checked model for many times and no errors returned. I generate database from PDM and in generated file i…
masoud
  • 11
  • 2
1
vote
2 answers

MySQL Workbench out of range value for decimal number

I wanted to create an table create table Oceny_projekty ( OProj_Id int not null comment '', ID_Projektu int comment '', ID_Studenta int comment '', OProj_Ocena decimal(1,1) comment '', …
Aleksandra Skoczypiec
  • 91
  • 1
  • 8
1
vote
0 answers

Sybase change name for the Database

I need to change name for the Database. Strange but it is specified the data type as User I am trying to to do that: new User(raw.GetChildren().Item(3)).SetNameAndCode("____"+system+"_raw",system+"_raw")) But this is not a good solution to go in…
rholdberh
  • 475
  • 1
  • 5
  • 19
1
vote
1 answer

How to use short Java property name in Powerdesigner?

When using PowerDesigner to generate javaBean I got this preview,problem is I don't know how to replace the "java.lang.String" with "String" Preview Code: public java.lang.String userName;
J John
  • 299
  • 1
  • 3
  • 15
1
vote
1 answer

Powerdesigner domain auto_increment

I'm building a database for a website, using PowerDesigner. I'm using domains for the ID's and want an ID to be auto_increment. Is there a way to get the DDL/CREATE script with auto_increment in it, using Microsoft SQL server 2014?
Jelle
  • 758
  • 2
  • 14
  • 36
1
vote
2 answers

PowerDesigner : Import table structure with columns and types with Excel

I'm trying to find a way for import my structures in Powerdesigner with Excel. There is an option for importing Excel file so it possible but noway... I don't know how must be the Excel file, can I find a template somewhere ? Have you ever success…
TomTomLux
  • 11
  • 1
  • 3
1
vote
1 answer

Missing CREATE DATABASE code in PowerDesigner script

I've created PDM in PowerDesigner and I want to generate a database of it. When I choose Database -> Generate database option in main menu, pop-up dialog is shown where I need to configure database properties like data source, credentials and…
veljasije
  • 6,722
  • 12
  • 48
  • 79
1
vote
0 answers

Find column Vbscript PowerDesigner

I would like to find column in tables. Why I have mistake when I run VBscript in Power Designer? Dim table, column for each table in activeModel.tables for each column in table.columns output column.name next next Mistake is Object doesn't support…
monika01
  • 29
  • 2
  • 10
1 2
3
…
13 14