API Interfaces Reference › Location and Disposition in Model Directories and Persistence Units › Locator Property

Previous Topic: Location and Disposition in Model Directories and Persistence Units

Next Topic: Disposition Property

Locator Property

The following table describes the syntax supported by the Locator property:

Syntax

Arguments

 
[provider://]pathinfo[?param=value[;param=value]…n]

provider: This is a type of persistence storage. Use erwin to specify file system, and use mmart for a mart. If this is skipped, erwin is the default.

pathinfo: This is the path to the storage location, which is either a file path or the mart path.

param: This is either a parameter name or a keyword.

value: This is a text string.

There are no param keywords defined for the file system persistence storage.

A list of Locator param keywords for use with the mmart type of provider for models stored in a mart is described in the following table.

Note: There is a special arrangement for the CA ERwin Data Modeler Workgroup Edition Locator. Part of the Locator string with params can be omitted if an application has connections open with one or more mart repositories. In this case, the params part of the Locator string can have only partial information or not be present at all, as long as it is clear to which connection from the available list it refers.

Currently, CA ERwin Data Modeler Workgroup Edition allows only one open connection to a mart repository at any given time. Therefore, it is possible, after establishing a connection, to omit the params part of the Locator string completely and to provide the model path information only.

The following table provides a list of Locator param keywords for use with the mmart type of provider for models stored in a mart:

Complete Name

Abbreviation

Description

Server

SRV

The mart server.

Server Type

SRT

Type of server connection.

Trusted Connection

TRC

For SQL Server 2000 or later and Oracle 9.x or later. When set to YES, it instructs the database driver to use Windows Authentication Mode for login validation, in which case the UID and PSW keywords are optional. When set to NO, it instructs the database driver to use a database username and password for login validation, in which case the UID and PSW keywords must be specified.

User

UID

Login user name. UID need not be specified when using Windows Authentication.

Password

PSW

User login password. You do not need to specify PSW if the login has a NULL password or if you use Windows Authentication (Trusted Connection set to YES).

Submodel Name

SBN

Name of a submodel to access.

Library ID

Model ID

Submodel ID

LID

MID

SID

Optional library, model, and submodel IDs. When provided, you reduce the access time required to open a model.

Note: More information about SRT (Server Type) is located in the Application.Persistence.ModelMart section.

The following table describes various scenarios in which you can use the Locator param keyword along with the mmart type of provider for models stored in a mart:

Scenario

Description

CA ERwin Data Modeler Workgroup Edition using SQL Server

If you have a model called MyModel located in MyLib, which is in MyMart, you can use the following:

mmart://MyMart/MyLib/MyModel?SRV=MyServer;SRT=SQL Server 2000/2005 (using db-lib);UID=<mm user id>;PSW=<password>

CA ERwin Data Modeler Workgroup Edition using Oracle

If you have a model called MyModel located in MyLib, which is on OracleHome (the database name is not indicated, and the additional slash ( / ) is required), you can use the following:

mmart:///MyLib/MyModel?SRV=OracleHome;SRT=Oracle Vers. 8.xx/9i/10g;UID=<mm user id>;PSW=<password>

Local drive

If you have a model called mod.erwin located in the models directory on the C drive, you can use the following:

C:\models\mod.erwin