Adding a Connection for a Generic Database

If you store documents in a document management system that is not currently supported by West km, you can use a generic database to index those documents in West km. To implement this solution, you create a new database in Microsoft SQL Server or Oracle Database, import data about the documents you want to index into the database, and then designate the database and document collection in West km for indexing.

For information on creating the generic database and importing data, refer to the West km Administrator Guide.

To add a connection for a generic database,

1. Point to the Setup link, and then click Data Source Management.
2. Click Add Connection from the Tasks list.

3. Enter the following information.

Field Name	Description
Connection Type	The data source used to manage the documents (i.e., Generic Database).
Server	The name of the server containing the generic database/tablespace. (The server name must use only alphanumeric characters; underscores are not allowed.)
Database	For Microsoft SQL Server, the name of the generic database; for Oracle Database, the net service name (e.g., orcl) that connects to the database instance containing the generic tablespace.
Database Type	The type of database that is used for the generic database.
Use Windows authentication for database	If your organization uses SQL Server for the generic database, you can choose whether West km accesses the database via a database account or a Windows account. A database account is used by default. To use a Windows account instead, select this option.
Database User ID and Database Password	When using database account credentials to access the generic database, the user ID and password for the database user account (e.g., kmuser, kmgenericuser).
Domain User ID and Domain Password	When using Windows account credentials to access the generic database, the user ID and password for a network domain account with administrator rights on the SQL Server machine.
Novell ID and Novell Password	If your organization uses Novell network software, the user ID and password for the Novell server on which documents are stored.
Novell IP	If your organization uses Novell network software, the Novell NDS Server IP address.
Use Novell Credentials for Security	If your organization (1) uses Novell network software, (2) uses either the Full or Always Display Titles document security level in West km, and (3) has user accounts in your DMS mapped to Novell accounts, then select this option. With this option selected, you must also populate the Novell Network ID field for active members in the Professionals table. For details, see Administering West km Members.



4. If you want to select a library group for this data source, see Selecting a Library Group for details.
5. Click Save.

[top of page]