Federation Manager Guide › Getting Started with a Simple Partnership › Configure the SP Partner › Establish a User Directory Connection › Set up the Sample Users for the Data Source

Set up the Sample Users for the Data Source

Set up the sample users for the data source by importing the ODBC schema and sample data.

Federation Manager provides script files to create the schema and data for storing sample users in the CA FedManager data source. You can store this data in the same SQL Server or Oracle database that you specified when installing Federation Manager.

To import the schema for sample users

1. Navigate to the following directory:

   Windows (default location): federation_mgr_home\siteminder\db\SQL

   Solaris: federation_mgr_home/siteminder/db/sql

2. Import the necessary schema files to populate the database with sample users. Use the tool for your database to perform the import.

   Import the following files:

   • smsampleusers_sqlserver.sql

     Creates the schema for sample users in a SQL Server database and populates the database with sample users.

   • smsampleusers_oracle.sql

     Creates the schema for sample users in an Oracle database and populates the database with sample users.

   For example, if you look in the script, you can see a sample user named GeorgeC with a password of siteminder.

3. After the schema is imported, connect to the directory.