Federated content data source configuration

Portal, V6.1

Federated content data source configuration

To use the federated content component, first configure your WCM Server to link to a federated data source. Only one federated data source can be used per Web content server.
To link to a federated data source, edit the following properties in the WCM ConfigService.properties file.
connect.connector.federatedconnector.defaultserveralias= connect.connector.federatedconnector.defaultusername= connect.connector.federatedconnector.defaultpassword= connect.connector.federatedconnector.connectionstring= connect.connector.federatedconnector.maxresultsreturned=100 connect.connector.federatedconnector.connectiontimeout=300 connect.connector.federatedconnector.defaultauthoringusername= connect.connector.federatedconnector.defaultauthoringpassword=
connectionstring The connection string used to access the federated data source, including the name of the schema used by the data source. For example: SCHEMA=ICMNLSDB.
connectiontimeout This is a timeout value in seconds. This will force the cache to be cleared. The default value, if not specified, is 300 seconds (5 minutes).
defaultserveralias This is the alias name created when the federated data source's "II4C" client was created.
defaultusername This is the user name used to preview or view the federated data source.
The user name 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 user name and password entered in the federated content component form are attempted first. If the federated reference cannot be accessed, the default user name and password specified in the WCM ConfigService.properties file are used. If the federated reference still cannot be accessed, the current 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.
defaultpassword This is the password of the user name used to preview or view the federated data source.
maxresultsreturned The maximum number of results returned by a search query can be set here. The default value is 100.
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.

IBM Content Manager or IBM Information Integrator configuration
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.
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 IBM 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.

IBM Content Manager configuration
To enable the use of federated content from IBM Content Manager run the following command:
Open a DB2 development window or command window:
Issue a "connect" to your DB2 database. This is the database where Content Manager is installed. To issue a "connect" use the following command:
db2 connect to database_name user user_name using password
Then issue the following DB2 grant command:
db2 grant update on table schema_name.faoptions to user icmconct
Disconnect and close the DB2 development window.
Parent topic
Federated content element

Parent topic
Work with federated content

connectionstring	The connection string used to access the federated data source, including the name of the schema used by the data source. For example: SCHEMA=ICMNLSDB.
connectiontimeout	This is a timeout value in seconds. This will force the cache to be cleared. The default value, if not specified, is 300 seconds (5 minutes).
defaultserveralias	This is the alias name created when the federated data source's "II4C" client was created.
defaultusername	This is the user name used to preview or view the federated data source. The user name 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 user name and password entered in the federated content component form are attempted first. If the federated reference cannot be accessed, the default user name and password specified in the WCM ConfigService.properties file are used. If the federated reference still cannot be accessed, the current 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.
defaultpassword	This is the password of the user name used to preview or view the federated data source.
maxresultsreturned	The maximum number of results returned by a search query can be set here. The default value is 100.
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.