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

Class Diagram in PowerDesigner 15 and C# 3.0 Properties

I am using PowerDesigner 15 and I want the generated code preview of each class designed to be using C# 3.0 Properties, not attributes and a "set_Att get_Att" of java! How can I do it? Tnx
Bassam Bsata
  • 1,075
  • 2
  • 10
  • 13
0
votes
1 answer

powerdesigner how to generate sql using `backquote`

Sybase PowerDesigner Version 16.0.0.3514 Current DBMS mysql 5.0 Generate SQL In fact, I want to add backquote around the field name, like this How to configure it?
iuha
  • 1
0
votes
1 answer

power designer CHECK constraint behind tables and function

Could I change order in generated script for CHECK constraint on TABLE? I need to generate Check Constraint at the end (when tables and functions exists). Because I have a function F (Select COUNT (*) from table X), and I have a constraint on…
user2408345
  • 17
  • 2
0
votes
1 answer

SAP PowerDesigner Data API

I am want to create CDM in powerdesigner using import functionality. I have explored the option of importing excel but this requires user to refresh the imported excel in case of any changes. What I want is to call an API, which will provide…
Rahul Pol
  • 1
  • 1
0
votes
0 answers

Generate schema name on column domains

I have a schema named "Core" and this schema has several domains (Id, Name, ...) My DBMS is Microsoft SQL Server 2014. This is the definition for "Name" domain: When I generate Sql the column tables haven't the domain schema: If I run the sql as…
Javier Ros
  • 3,511
  • 2
  • 21
  • 41
0
votes
2 answers

Powerdesigner VBA - how to switch active model

Working with powerdesigner models with excel vba. I have multiple models open that I am trying to access. In my code I can easily access the current active model using: Dim pd_App As PDCommon.Application Set pd_App = New PDCommon.Application Dim…
user3120960
  • 179
  • 1
  • 3
  • 11
0
votes
1 answer

powerdesigner vb/vba how to set default table mapping for excel source 2 target extract

I'm working on a script to extract source to target data from powerdesigner 16. I have a table that is sourced from multiple mappings in powerdesigner MAPPING_1, MAPPING_2, ETC. I can't figure out how to set the default mapping with vba code. I'm…
user3120960
  • 179
  • 1
  • 3
  • 11
0
votes
1 answer

Batch table/Column update in powerdesigner reading from excel using vb script

I am looking for developing a vb script which would extract all the table/columns from powerdesigner model to a excel file. After changing few properties I will be updating it to the model using vbscript. So I would like to know if there is any…
Sunil
  • 1
  • 1
0
votes
0 answers

Could not open table in Visual Basic 6.0, generated in PowerDesigner 6 AppModeler

I'm trying to make an app using Microsoft Visual Basic 6.0. My problem is that VB cannot open tables, outputing a message "Could not open table 'Table'!" though Visual Data Manager opens it fine. What could be the problem? Could it be something…
HardRock4Life
  • 177
  • 1
  • 9
0
votes
0 answers

changing attributes in PowerDesigner via vba-script

I have a data model in PowerDesigner. I wrote a vba-script that changes the description of a column to the value of the comment of the column. It does well. When I look at the column-properties I can see the new description. The problem is, that the…
derzeit
  • 1
0
votes
1 answer

How i can show default values of each column in ERD that generated by powerdesiner

I want to show default value of each column in my ERD.How I can do that ? I don't see something about it in content tab in symbol format windows. Only in preview tab in table properties, I can see default values for columns in generated SQL. the…
HFDev
  • 131
  • 2
  • 4
  • 11
0
votes
1 answer

How to correct these syntax errors in a SQL script generated by PowerDesigner in SQL Server?

Msg 156 Level 15 State 1 Incorrect syntax near the keyword 'if' Msg 156 Level 15 State 1 Incorrect syntax near the keyword 'then' Msg 156 Level 15 State 1 Incorrect syntax near the keyword 'delete' Msg 156 Level 15 State 1 Incorrect…
Sona Legends
  • 27
  • 1
  • 7
0
votes
3 answers

PowerDesigner 12 from Sybase and Django

Am pretty new to Django but I do have long experience in web development. Usually, I always use PowerDesigner to create the table structure of my solution, export to SQL to use as my backend. With Django its a different story and I was hoping if…
Mo J. Mughrabi
  • 6,747
  • 16
  • 85
  • 143
0
votes
1 answer

PowerDesigner create table grants in VB

I'm trying to create a script to automatically grant select,update,delete,insert on tables to specific users. Dim ModelTables, table, tab, newPerm SET ModelTables = obj.Tables For Each table in ModelTables If IsObject(table) Then Set tab =…
user7646609
  • 1
  • 1
0
votes
1 answer

Is it a correct procedure to link a Relationship Table with other tables?

I would like to know if it is right to link a relationship table with other tables. I tried it in PowerDesigner, but it give me a warning about it. However: I have two table called "Client" and "Staff" in Many-to-Many relations. In the given…
Giacomo Brunetta
  • 1,409
  • 3
  • 18
  • 38
1 2 3
…
13 14