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

Datetime conversion issue with SQL server

I've generated some fake data for a database i've created using PowerAMC. This database as some filed with timedate format. But when i'm running the file in SQL server (Express edition), i've the following : The conversion of a varchar data type to…
Derbie
  • 413
  • 1
  • 12
  • 28
1
vote
1 answer

How to change Object Length when Generating Database Script using PowerDesigner 16?

I'm doing a reverse engineer of a MySQL database to pass it to a Sybase database. When I generate the Database Script (for the Sybase database), it gives me errors because it only allows a 30 length object name. The thing is, with ASE 15.X versions,…
aF.
  • 64,980
  • 43
  • 135
  • 198
1
vote
1 answer

PowerAMC and SQLite

I just wanted to know if there is any way to generate a SQLite database from Poweramc ? At first sight, it seems not, and Google isn't helping me much on this... Thank you for your hints ;)
Jan
  • 253
  • 1
  • 13
1
vote
3 answers

how to model this database relationship? (sybase powerdesigner)

I'm doing a conceptual model in Sybase PowerDesigner. The restriction is following: One doctor can work in only one office at a time during his working time (shift). I guess Doctor - Office relationship should be many-many, but what about time…
dragan.stepanovic
  • 2,955
  • 8
  • 37
  • 66
1
vote
1 answer

Connection from PowerDesigner to MS SQL Server 2008 R2

I'm trying to connect from Sybase PowerDesigner 15 to MS SQL SERVER 2008 R2. I basically entered the following into the Connection Profile Definition dialog: Connection Type: Native DBMS Type: Microsoft SQL Server Server Name: MSSQLSERVER (which is…
Kassem
  • 8,116
  • 17
  • 75
  • 116
0
votes
1 answer

Powerdesigner: Difference between Modification Date and Overall Modification Date

Using PD v15.0.0.2675 in a PDM file. I have number of tables where Modification Date is different from Overall Modification Date. Trying to determine the difference between the two and what sets each, I have found minimal documentation on Mod Date…
user901135
  • 11
  • 2
0
votes
1 answer

PowerDesigner - Assign a TriggerTemplate to a trigger through VBScript?

In PowerDesigner v12, how would one, through use of VBScript, assign a TriggerTemplate to triggers that are missing the definition? We have a script now that can loop through the triggers and display the triggertemplate (if it has one), but all…
Calvin Allen
  • 4,176
  • 4
  • 31
  • 31
0
votes
1 answer

Advantage Database ERD, from existing database.

Anyone aware of any tool which I can use to get ERD for existing advantage database? I am messing around with Advantage Data Architect but unable to find any option for ERD. I have also tried PowerDesigner but can't find Advantage Database option…
Adnan Bhatti
  • 3,410
  • 4
  • 25
  • 38
0
votes
2 answers

Generate UML from a conceptual data model

I have an conceptual data model (Relational model) created using powerAMC for my database but i wanted to generate DAO from it using acceleo and for that i need it in UML , is there a way to generate UML from a conceptual data model model ?
Mouna Cheikhna
  • 38,870
  • 10
  • 48
  • 69
0
votes
1 answer

PowerDesigner (Database design) - add PK to cross-reference table

i would like to know how to add PK to cross - reference table which is created from converting Conceptual Model to Physical Model and associate it with other table as FK. Conceptual Model Physical Model Expected Result Physical Model Job…
xyz
  • 2,277
  • 2
  • 25
  • 41
0
votes
1 answer

How to change the default naming style of component instances in PowerDesigner 15.x?

By default, when dragging existing components into different PowerDesigner models (e.g. deployment), the component instance is named as ComponentInstance_X where X is an incremental counter. How can I change this naming style to something different…
TonySalimi
  • 8,257
  • 4
  • 33
  • 62
0
votes
0 answers

Source Model Name when copy object

How to get, when copying one object from model to model, the name of the Source model? I Need it in table EventHandler initialize. Thank you David
user2408345
  • 17
  • 2
0
votes
0 answers

How to get Replication name of table

How can I Get Replication name of table in Package? for exmaple I Know how can I get table name in event handler Function %Initialize%(obj) Output obj.Name End Function Thank you for your help - PD:…
user2408345
  • 17
  • 2
0
votes
0 answers

Prevent MsgBox to opening in PowerDesigner

I need to checkout models automatically using VBScript, but when the model DBMS is not valid a MsgBox showed up and the human action becomes needy. I am looking to way to supress this MsgBox with a cancel command and just skip the model. I tried to…
Lucas Maraal
  • 39
  • 10
0
votes
1 answer

PowerDesigner : format MCD display

Doing reverse engineering with powerDesigner, I have complicated CDM. Is there a way to ask powerDesigner to display it properly (nicely) ? thank you
mlwacosmos
  • 4,391
  • 16
  • 66
  • 114
1 2 3
…
13 14