Home Blog 30 Ways to Customize Sybase PowerDesigner – Data Modeling

Warning: strtotime(): It is not safe to rely on the system's timezone settings. You are *required* to use the date.timezone setting or the date_default_timezone_set() function. In case you used any of those methods and you are still getting this warning, you most likely misspelled the timezone identifier. We selected the timezone 'UTC' for now, but please set date.timezone to select your timezone. in /home/powerd5/public_html/libraries/joomla/utilities/date.php on line 56

Warning: strtotime(): It is not safe to rely on the system's timezone settings. You are *required* to use the date.timezone setting or the date_default_timezone_set() function. In case you used any of those methods and you are still getting this warning, you most likely misspelled the timezone identifier. We selected the timezone 'UTC' for now, but please set date.timezone to select your timezone. in /home/powerd5/public_html/libraries/joomla/utilities/date.php on line 56

Warning: date(): It is not safe to rely on the system's timezone settings. You are *required* to use the date.timezone setting or the date_default_timezone_set() function. In case you used any of those methods and you are still getting this warning, you most likely misspelled the timezone identifier. We selected the timezone 'UTC' for now, but please set date.timezone to select your timezone. in /home/powerd5/public_html/libraries/joomla/utilities/date.php on line 198

Warning: date(): It is not safe to rely on the system's timezone settings. You are *required* to use the date.timezone setting or the date_default_timezone_set() function. In case you used any of those methods and you are still getting this warning, you most likely misspelled the timezone identifier. We selected the timezone 'UTC' for now, but please set date.timezone to select your timezone. in /home/powerd5/public_html/libraries/joomla/utilities/date.php on line 198
30 Ways to Customize Sybase PowerDesigner – Data Modeling PDF Print E-mail
Written by Jay Stevens   

30 Ways to Customize Sybase PowerDesigner – Data Modeling

Here is a beginning list of ways to customize Conceptual, Logical or Physical data model behavior within PowerDesigner.  Please comment on your thoughts, additional ideas or corrections.

1.      Alter datatype mapping when generating from CDM to LDM or PDM.

2.      Customize generated DDL to include standard SQL header / comment block.

3.      Customize generated triggers.

4.      Customize default stored procedure templates.

5.      Customize default function templates.

6.      Create templates to jump start your new models to company standards possibly including standard domains, pre-build diagrams / packages and display options.

7.      Enhance PowerDesigner meta model with additional information required by your company like data sensitivity information to track different security levels.

8.      Add additional check model logic to verify that synonyms have been created for all Oracle tables and views.

9.      Add additional check model logic to insure standard naming conventions are being adhered to for table and column names.

10.  Add logic to automatically fix customized check model errors.

11.  Generate additional files to support your data models like XML Schemas for selected tables.

12.  Execute logic which will export selected data to Excel, CSV, database file.

13.  Alter reverse engineering behavior to include additional information from system or application tables.

14.  Alter reverse engineering to exclude information not needed by you to make it more efficient.

15.  Create script to ensure standard permissions are maintained.

16.  Trigger a script based on an event like table create or modify like creating or updating a matching view.

17.  Change symbol color based on criteria like table size or owner.

18.  Create script to create standard audit columns for a table.

19.  Create variations of a table or any object using stereotypes such as categorizing tables as Master, Transaction, History, Lookup, Temp or Reporting.

20.  Vary symbol format based on object stereotype.

21.  Create custom check model logic based on object stereotype to ensure corporate standards.

22.  Generate different DDL based on object stereotype.

23.  Don’t use users in PowerDesigner, remove them from the interface.

24.  Add additional standard default values in order to avoid getting quotation marks default declarations.

25.  Automate repetitive task like setting permissions, creating views, synonyms and/or sequences.

26.  Enhance database support to handle new functionality not yet supported by Sybase such as a beta DBMS release.

27.  Create support for an entirely new database that Sybase does not currently include.

28.  Set default physical options to your database standards.

29.  Load information into PowerDesigner from an Excel spreadsheet like setting physical options based on estimated record counts.

30.  Automate reverse engineering process for consistent results.

 

 

Warning: strftime(): It is not safe to rely on the system's timezone settings. You are *required* to use the date.timezone setting or the date_default_timezone_set() function. In case you used any of those methods and you are still getting this warning, you most likely misspelled the timezone identifier. We selected the timezone 'UTC' for now, but please set date.timezone to select your timezone. in /home/powerd5/public_html/libraries/joomla/utilities/date.php on line 250

Warning: strftime(): It is not safe to rely on the system's timezone settings. You are *required* to use the date.timezone setting or the date_default_timezone_set() function. In case you used any of those methods and you are still getting this warning, you most likely misspelled the timezone identifier. We selected the timezone 'UTC' for now, but please set date.timezone to select your timezone. in /home/powerd5/public_html/libraries/joomla/utilities/date.php on line 250

Warning: ereg_replace(): It is not safe to rely on the system's timezone settings. You are *required* to use the date.timezone setting or the date_default_timezone_set() function. In case you used any of those methods and you are still getting this warning, you most likely misspelled the timezone identifier. We selected the timezone 'UTC' for now, but please set date.timezone to select your timezone. in /home/powerd5/public_html/modules/mod_footer/mod_footer.php on line 24

Deprecated: Function ereg_replace() is deprecated in /home/powerd5/public_html/modules/mod_footer/mod_footer.php on line 24

Warning: ereg_replace(): It is not safe to rely on the system's timezone settings. You are *required* to use the date.timezone setting or the date_default_timezone_set() function. In case you used any of those methods and you are still getting this warning, you most likely misspelled the timezone identifier. We selected the timezone 'UTC' for now, but please set date.timezone to select your timezone. in /home/powerd5/public_html/modules/mod_footer/mod_footer.php on line 30

Deprecated: Function ereg_replace() is deprecated in /home/powerd5/public_html/modules/mod_footer/mod_footer.php on line 30
Copyright © 2019 powerdesignerplus.com. All Rights Reserved.
Joomla! is Free Software released under the GNU/GPL License.