WCM connectors are configured only for content objects, not for system objects.

Database administrators may wish to configure a new connector in the following circumstances:

• You have added a new database to your network;
• You have created new content types that require a new connector.

 

Connector

• Code

  Enter a string that will serve as the connector ID in the system.

• Name

  Enter a descriptive name for the connector.

• Connection string

  Enter a connection string to create a data source name. This information is used to connect using PHP extension and application repository data source name (PEAR DSN) syntax. The format of the supplied DSN must be as follows:

  phptype://username:password@hostname[:port]/database_name

  For a MySQL database, you would enter (for example):

  mysql://jdoe:jdoe198@wcmserver/bizdb2.

• Table prefix

  Enter the prefix used in your properties table.

  Each content type has its own properties table in the database. A table prefix is a string that precedes each table name in your database to prevent conflicts between table names and reserved words. The default code used by WCM is biz_.

When you are done, select Save or Check-in (according to your selected lock mode) to save your connector configuration.