cancel
Showing results for 
Search instead for 
Did you mean: 

How reliable is the repository

Former Member
0 Kudos

I am thinking about using the Powerdesigner Repsoitory to store my Powerdesigner files, but I have heard comments that make me concerned about its reliability. The models that I use contain extended properties and shortcuts between packages and between models, and I have heard that the repository can't always handle these.

Does anyone have any experience of using the repository which could either support of allay my concerns?

Accepted Solutions (0)

Answers (1)

Answers (1)

Former Member
0 Kudos

Hi Georgia,

If you are several peoples working with PowerDesigner (Data Architect, DBA, Enterprise Architect, etc.) It's very good idea to use the Repository and share your models.

We use the repository for many years and we have not noticed reliability problems.

The only thing : To have a good performance check-in/check-out you must use PowerDesigner Proxy to Connect PowerDesigner to your RDBMS (repository). When you use the Proxy : PowerDesigner send large packet of data to the Proxy under a proprietary format (more efficient) and the Proxy run long transactions - many atomic SQL transactions - to the DBMS.

In "PowerDesigner World" the primary use of a direct connection to the DBMS is to create therepository by the Repository Administrator.

For adequate performance the Proxy and the repository (RDBMS) must be installed on the same server. (Also the PD Portal). Thus the thousands of transactions are executed in memory and not over the network (latency problem)

Also : Under 'C:\Program Files\Sybase\PowerDesigner 16\ you have "readme.html" file. In this document SAP give information to optimize the referential. Aka modify attribute length TDAT of table PMTEXT

We have none problem to use extended properties, shortcuts between packages and between models and save models into the repository. The repository is able to handle these without problem.

I suggest your read the installation guide. Particulary about repository creation and specific setting if you install the repository over ASE, DB2 or MS SQL Server

Do not forget to set the number of bytes per char correctly following your DBMS character set

For non-Oracle unicode or multi-byte character set databases, specify the bytes per character used by the database:

• 1-byte - [default] For SBCS (Single-Byte Character Set)

• 2-byte - For DBCS (Double-Byte Character Set)

• 3-byte - For Unicode or MBCS (Multi-Byte Character Set)

Finally if you set-up the repository you can use PowerDesigner Portal to publish your models to people in your enterprise.