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

Accessing PowerDesigner Repository Models via COM

I have been trying to get live models directly from the PowerDesigner repository using the COM API without success. Here's what I've been trying in VBA: Set pd = CreateObject("PowerDesigner.Application") Set conn = pd.RepositoryConnection conn.Open…
C. Connar
  • 21
  • 5
1
vote
2 answers

How do I go about this relationship?

novice in SQL here. I've got this relationship: Teams have references to all 5 members and each player has reference to his team. Now, should I also make teamPlayer1,2,... a FK of PLAYERS entity? Cause so far I've only worked with relationships…
user1255410
  • 856
  • 1
  • 9
  • 15
1
vote
0 answers

How to select many diagram symbols of tables from search results?

After doing some sophisticated search of tables with several criterias (part of name, specific stereotype, etc.) and got result list of many tables. It's not clear how to select all of them at once on diagram (for example to group them, or move to…
Andrey Bark
  • 11
  • 2
1
vote
2 answers

Model deleted from PowerDesigner repository

I am working on Power Designer 16.1, the repository is installed on a Linux server. I have an issue with the repository sometimes dropping my models, in most cases I am able to check-in the models to the repository and check-out correctly, but…
s.moussa
  • 21
  • 2
1
vote
3 answers

How to associate an Sequence to a column in PowerDesigner?

I'm using powerdesigner 15.2 to model an postgresql database, but i can't associate sequences with PKs... read on internet that: "To associate the sequence with the column, double-click the column entry. Then, in the General tab, specify the name of…
Igor Souza
  • 53
  • 2
  • 8
1
vote
2 answers

Sybase: Generate a script Between two SQL?

I've a Sybase database where I will make a LOT of changes, and I would like to make my changes (currently using PowerDesigner 16), save it as .SQL then generate a .SQL to migrate my initial database to the new database structure. I don't care about…
J4N
  • 19,480
  • 39
  • 187
  • 340
1
vote
0 answers

many-to-many mandatory relationship enforce mandatory value

I have a many-to-many relationship, and one direction is mandatory, like the following diagrams, conceptual model and physical model. A UserAccount has to have one or more Permission to it. When we insert a UserAccount, how can we enforce at least…
5YrsLaterDBA
  • 33,370
  • 43
  • 136
  • 210
1
vote
1 answer

Change default variable name in trigger PowerDesigner

....Hi all!.... I wonder if it's possible and how to change default variable name in triggers template of PowerDesigner 16.5. e.g. in template: create trigger % TRIGGER % after insert order % ORDER % on[ % TABLQUALIFIER % ] % TABLE % referencing…
Illia Levandovskyi
  • 1,228
  • 1
  • 11
  • 20
1
vote
1 answer

Mandatory relationship m:n

I have a conceptual scheme (Power Designer) for school homework and between the tables torrent and server I have a mandatory relationship (a torrent must have at least one server). I generate the physical model, then the code (Oracle 10g) and then…
AMDcze
  • 516
  • 3
  • 13
1
vote
0 answers

How to introduce changes in pdm with sql script via PowerDesigner

~~~~~~~~~~~~~~~~ Hi, all! I have a database model xxx.pdm and a sql script I want to apply to the db (so that generated xxx_db.sql, xxx_triggers.sql, etc will contain the changes - the files are used in whole application building process to generate…
Illia Levandovskyi
  • 1,228
  • 1
  • 11
  • 20
1
vote
2 answers

#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version

I am using Sybase Power Designer to create a database from a physical data model (Sybase creates an SQL file) . When i import the SQL file with phpMyAdmin I have the following error: #1064 - You have an error in your SQL syntax; check the manual…
user3759619
  • 11
  • 1
  • 3
1
vote
0 answers

Power Designer can not open file

I have three logical design files. When I try to open them, Power designer throws an error message: Sybase power designer can not open the specified file. But there are no details at the error message so I can not understand what causes the problem…
user3234299
  • 11
  • 2
1
vote
0 answers

SQL Collation mismatching issue

Have some collation(?) troubles when getting data from ADODB.RecordSet. When selecting with SQL Management studio everything looks fine like PriceMonitoring Справочник конкурентов2_Temp Table 6142061 dbo Buuut, when i get data from…
Andrii Horda
  • 170
  • 1
  • 16
1
vote
0 answers

PowerDesigner error by generating physical model: 'Existence of attribute'

I have the error named 'Existence of attribute' when I try to generate the physical data model. So, what is it about? Google isn't helping :( And how can I generate the Java classes after I generate the physical data model?
user3035691
  • 11
  • 1
  • 2
1
vote
1 answer

PowerDesigner 16 - generate a list of tables and column definitions

Does anyone know how to generate a simple report showing all tables in a model, and their columns (name and a few attributes including NOT NULL)? I worked through the Report Wizard and got totally confused.
Chap
  • 3,649
  • 2
  • 46
  • 84
1 2 3
…
13 14