Previous Topic: ODBC Data Source on Solaris Configuration Requirement

Next Topic: Configure the SQL Server Wire Protocol Driver

Configure the Oracle Wire Protocol Driver

You configure the Oracle wire protocol driver to specify the settings Federation Manager should use to connect to the data source.

To configure the Oracle wire protocol driver

  1. Navigate to the directory federation_mgr_home/siteminder/db.
  2. Open the system_odbc.ini file in a text editor.
  3. Select the section [CA FedManager Data Source] and make a copy of it directly under its current location.
  4. Using the copy you created as a template, rename the heading in brackets to something appropriate for your data source.
  5. Change the values in the LogonID, Password, HostName, and Service Name entries.

    The modified text for the Oracle data source should appear as follows:

    Driver=federation_mgr_home/siteminder/odbc/lib/NSora23.so
    Description=DataDirect 5.3 Oracle Wire Protocol
    LogonID=uid
    Password=pwd
    HostName=servername
    PortNumber=1521
    ServiceName=servicename
    CatalogOptions=0
    ProcedureRetResults=0
    EnableDescribeParam=0
    EnableStaticCursorsForLongData=0
    ApplicationUsingThreads=1
    
  6. Save the file.

    The Oracle wire protocol driver is configured.

Important! Do not modify other entries in the file, especially anything listed in the [CA FedManager Data Source] section.


Copyright © 2010 CA. All rights reserved. Email CA about this topic