I import an excel file into PowerDesigner as a physical data model. The excel file associates a stereotype with each table. My stereotypes are “hub”, “sat”, “lnk”... and I'd like to be able to automatically color the tables according to the stereotype. Example: if stereotype hub, then the table is colored blue, if lnk, the table is colored red, but automatically because I have a file with 200 tables and doing it by hand is much too time-consuming. Especially since I need scalability.
I tried to add an extension, to associate a color for each stereotype but I encountered a problem, to apply the color to the table, I have to click on each table and reselect the stereotype, so not too manually. So I wanted to know if there is a manual way to do this.
===> My aim is to associate each stereotype with a color and have the table take that color, all automatically.
The result I want to have if I say that the Link stereotype is associated with the color red
So far, I've been working on an extension to add a color to each stereotype, but the problem is that the tables don't change color automatically. So here's the stereotype for lnk :
Answer by
Pooja Bajaj
To address your question:
To automatically color tables in Sybase PowerDesigner based on their stereotypes, you can create a script that loops over all tables and applies the color according to the stereotype. Unfortunately, PowerDesigner doesn't have built-in functionality to directly associate colors with stereotypes that would automatically update upon importing. However, you can use the scripting language available in PowerDesigner to automate this task. Here's a general approach using VBScript:
Open PowerDesigner and load your model.
Go to Tools -> Execute Commands -> Edit/Run Script.
Use a script like the following to automatically apply colors:
Option Explicit Dim mdl 'the current model set mdl = ActiveModel if (mdl Is Nothing) or not mdl.IsKindOf(PdPDM.cls_Model) then MsgBox "There is no valid Physical Data Model open in PowerDesigner.", vbCritical Else Dim tab 'a table object For Each tab In mdl.Tables Dim stereotype, color stereotype = tab.GetAttribute("Stereotype") Select Case stereotype Case "hub" color = RGB(0, 0, 255) ' Blue Case "sat" color = RGB(0, 255, 0) ' Green Case "lnk" color = RGB(255, 0, 0) ' Red ' Add more cases as needed Case Else color = RGB(255, 255, 255) ' Default White End Select tab.BackgroundColor = color Next MsgBox "Coloring complete!", vbInformation End If
Adjust the RGB values and stereotypes in the script as per your requirements.
Run the script.
This script uses the RGB color system to define the colors and applies them to tables based on the stereotype. It should streamline your process for models with numerous tables.
Is there any way to put new DBMS? I want to update Postgre which is at version 9.X and today it is at version 13.3 and for "Reverse Engineering" it is very important to interpret the correct model.
A
Answer by
Akash Shah
Yes, it is possible to update the DBMS in Sybase PowerDesigner. You can update the version of Postgre to the desired version (13.3) for accurate interpretation of the correct model during Reverse Engineering.
The program's name is now SAP PowerDesigner and it hasn't been developed to run on the Mac OSX operating system which means that you won't have the possibility to install it on that operating system.
The only way to do it is to install one of the versions of Windows supported by PowerDesigner using virtualization, and by virtualization I mean Paralells Desktop.
Currently the Sybase PowerDesigner is compatible with: Windows Client 32-bit, 64-bit, Windows for IA64, X86, X86_64
How to buy PowerDesigner in France? How much it costs?
A
Answer by
Alex Urbach
The PowerDesigner is available globally and the SAP offers plans and pricing for all your needs and business requirements. They have a an official page set up for this that can be accessed through the link posted below.
I import an excel file into PowerDesigner as a physical data model. The excel file associates a stereotype with each table. My stereotypes are “hub”, “sat”, “lnk”... and I'd like to be able to automatically color the tables according to the stereotype. Example: if stereotype hub, then the table is colored blue, if lnk, the table is colored red, but automatically because I have a file with 200 tables and doing it by hand is much too time-consuming. Especially since I need scalability.
I tried to add an extension, to associate a color for each stereotype but I encountered a problem, to apply the color to the table, I have to click on each table and reselect the stereotype, so not too manually. So I wanted to know if there is a manual way to do this.
===> My aim is to associate each stereotype with a color and have the table take that color, all automatically.
The result I want to have if I say that the Link stereotype is associated with the color red
So far, I've been working on an extension to add a color to each stereotype, but the problem is that the tables don't change color automatically. So here's the stereotype for lnk :
To address your question:
To automatically color tables in Sybase PowerDesigner based on their stereotypes, you can create a script that loops over all tables and applies the color according to the stereotype. Unfortunately, PowerDesigner doesn't have built-in functionality to directly associate colors with stereotypes that would automatically update upon importing. However, you can use the scripting language available in PowerDesigner to automate this task. Here's a general approach using VBScript:
- Open PowerDesigner and load your model.
- Go to Tools -> Execute Commands -> Edit/Run Script.
- Use a script like the following to automatically apply colors:
Option ExplicitDim mdl 'the current model
set mdl = ActiveModel
if (mdl Is Nothing) or not mdl.IsKindOf(PdPDM.cls_Model) then
MsgBox "There is no valid Physical Data Model open in PowerDesigner.", vbCritical
Else
Dim tab 'a table object
For Each tab In mdl.Tables
Dim stereotype, color
stereotype = tab.GetAttribute("Stereotype")
Select Case stereotype
Case "hub"
color = RGB(0, 0, 255) ' Blue
Case "sat"
color = RGB(0, 255, 0) ' Green
Case "lnk"
color = RGB(255, 0, 0) ' Red
' Add more cases as needed
Case Else
color = RGB(255, 255, 255) ' Default White
End Select
tab.BackgroundColor = color
Next
MsgBox "Coloring complete!", vbInformation
End If
This script uses the RGB color system to define the colors and applies them to tables based on the stereotype. It should streamline your process for models with numerous tables.
I am looking generate JSON schema from LDM. which version supports this?
The feature to generate JSON schema was introduced in Sybase PowerDesigner 16.6. It is not available in version 16.5.
Is there any way to put new DBMS?
I want to update Postgre which is at version 9.X and today it is at version 13.3 and for "Reverse Engineering" it is very important to interpret the correct model.
Yes, it is possible to update the DBMS in Sybase PowerDesigner. You can update the version of Postgre to the desired version (13.3) for accurate interpretation of the correct model during Reverse Engineering.
The program's name is now SAP PowerDesigner and it hasn't been developed to run on the Mac OSX operating system which means that you won't have the possibility to install it on that operating system.
The only way to do it is to install one of the versions of Windows supported by PowerDesigner using virtualization, and by virtualization I mean Paralells Desktop.
Currently the Sybase PowerDesigner is compatible with: Windows Client 32-bit, 64-bit, Windows for IA64, X86, X86_64
How to buy PowerDesigner in France? How much it costs?
The PowerDesigner is available globally and the SAP offers plans and pricing for all your needs and business requirements. They have a an official page set up for this that can be accessed through the link posted below.
Access the page, then click on Licensing & Pricing and follow the link on the left after the page scrolls down.
I've found out that the SAP developed have created a page where you can see exactly how to create Many To Many relations in the PowerDesigner.
Access the following URL to see what is the correct procedure to complete this. This is the only thing available right now that I could find.