CA SiteMinder® Federation Standalone Guide › Getting Started with a Simple Partnership › Configure the IdP 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 store by importing the ODBC schema and sample data.

The product 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 CA SiteMinder® Federation Standalone.

Follow these steps:

1. Navigate to the following directory:

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

   UNIX: federation_install_dir/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.