Data Providers

Data Providers are used to retrieve data for display. They cannot be used to enter data. The data they retrieve is a "snapshot" of the data source.

 

SQL DBMS

The SQL Data Provider is used to retrieve data from relational databases. The Request Parameter needed to invoke this data Provider is SRV=SQL

The following Parameters are recognized:

Parameter Meaning Required
DB Database protocol and server Yes
USER Database user No
PWD Password for database user No
SQL Used to define which SQL statement to execute Yes

Example: Connect Tags 

<connect MOD="TEMPLATE" SRV="SQL"
 DB="jdbc:db2:accesssample"
 SQL="Select * from employee">
     Failure text
</connect>

Example: URL 

http://host:port/wps/connect/
?MOD=TEMPLATE&DB=jdbc:db2:accesssample&SRV=SQL&USER=username&PWD=password&SQL=Select * from employee

 

LDAP

LDAP is a protocol for accessing on-line directory services. The Request Parameter needed to invoke this Data Provider is SRV=LDAP

Example: Connect Tags 

<connect MOD="TEMPLATE" SRV="LDAP" {other Request Parameters}>
     Failure text
</connect>

Example: URL 

http://host:port/wps/connect/
?MOD=TEMPLATE&SRV=LDAP&{other Request Parameters}

The following Parameters are recognized:

Parameter Meaning Required
USER The User's Distinguished Name. Yes.
PWD The User's password. No.
Host TCPIP Host Name of the LDAP Server. No.
Filter LDAP search criteria. Yes.
Note:

  • The "user", "pwd" and "host" parameters are not required if the LDAP server settings are provided in connect.cfg. See the Connector Section topic in the Installation Guide for further information.
  • The filter parameter should reference a valid LDAP attribute . The appropriate wildcard character to use is "*"Example: 
    <connect MOD="TEMPLATE" SRV="LDAP" FILTER="uid=user100">
     Failure text
</connect>

 

Configuration Parameters

Default parameters for Data Providers can be set in connect.cfg See the Connector Section topic in the Installation Guide for further information.

Parent topic: Displaying Data from Databases.

IBM Workplace Web Content Management - V5.1.0.1 -

 

Workplace Web Content Management is a trademark of the IBM Corporation in the United States, other countries, or both.

 

IBM is a trademark of the IBM Corporation in the United States, other countries, or both.