Federated Content Data Source Configuration

 

+
Search Tips   |   Advanced Search

 

Overview

To use the Federated Content Component, configure the WCM server to link to a Federated Data Source. Only one Federated Data Source can be used per WCM server.

To link to a Federated Data Source, the following parameters must be edited within the "Connector" section of the connect.cfg file. 

<FederatedConnector>
      <DefaultServerAlias value = "" />
      <DefaultUsername value = "" />
      <DefaultPassword value = "" />
      <MaxResultsReturned value = 100 />
</FederatedConnector>

DefaultServerAlias Alias name created when the Federated Data Source's "II4C" client was created.
DefaultUsername User name used to preview or view the Federated Data Source.
DefaultPassword Password of the user name used to preview or view the Federated Data Source.

The username and password specified here must have appropriate access privileges to perform searches, select references, and view content.

When viewing a Federated Content Component in a Web Page, or previewing a Federated Data source from within the Federated Content Component Form, the Username and Password entered in the Federated Content Component Form are attempted first. If the federated reference cannot be accessed, the Default Username and Password specified in the FederatedConnector section of connect.cfg are used. If the federated reference still cannot be accessed, the current WCM user's credentials are attempted.

If Federated Content cannot be accessed, a blank line will be inserted into rendered content in place of the Federated Content.

DefaultAuthoringUsername The DefaultAuthoringUsername is a valid Federated Data Source user name that will be used to logon to IBM Content Manager and IBM Information Integrator for Content when Single Sign On is not enabled. This setting is optional.
DefaultAuthoringPassword The password of the DefaultAuthoringUsername is entered here. This setting is only required when DefaultAuthoringUsername is used.
MaxResultsReturned The maximum number of results returned by a Search Query can be set here. The default value is 100.
ConnectionTimeout. Timeout value in seconds. This will force the cache to be cleared. The default value, if not specified, is 300 seconds (5 minutes).
ConnectionString This value is passed as a connection string to the Federated Connector at connection time. It allows users to provide additional connection options.

E.g. - SCHEMA=ICMADMIN;DBAUTH=SERVER;REPTYPE=DB2

When using IBM Content Manager or IBM Information Integrator for Content (II4C) with Web Content Management, Java 2 support must be enabled by running "usejdbc2.bat" or "usejdbc2.sh" as described in the IBM Content Manager or IBM Information Integrator documentation. Note: IBM Information Integrator for ContentTo use the Federated Content Component:

  • IBM Information Integrator for Content 8.2 with Fix Pack 7 or greater must be installed on your federated data server.

  • IBM Information Integrator for Content libraries need to be added to the classpath of the WebSphere Application Server running WCM. refer to IBM Information Integrator for Content documentation for the list of libraries.

    • The IBM Content Manager libraries will also be required in the classpath when incorporating content from IBM Content Manager into WCM content.

    • Be sure to have run the DB2 and Information Integrator for Content environment variable scripts (usually db2profile and cmbenv81) in the user environment from which the WebSphere server running WCM is started.
Note: Single Sign-on

To use the Federated Content Component, Single Sign-on must be enabled on you Federated Data source. Refer to your Federated Data Source documentation for further information.

 

IBM Content Manager Configuration

To enable the use of Federated Content from IBM Content Manager run the following command:

  1. Open a DB2 development window or command window:

  2. Issue a "connect" to your DB2 database. Database where Content Manager is installed. To issue a "connect" use the following command:

    db2 connect to database user user using password

  3. Then issue the following DB2 grant command:

    db2 grant update on table schema.faoptions to user icmconct

  4. Disconnect and close the DB2 development window.

Parent topic: Federated Content Component.

IBM Workplace WCM - V5.1.0.1

 

WebSphere 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.