Symantec Access Management

Tech Tip : CA Single Sign-On : How to implement ODBC LoadBalancing for User Store

  • 1.  Tech Tip : CA Single Sign-On : How to implement ODBC LoadBalancing for User Store

    Broadcom Employee
    Posted Dec 04, 2017 03:02 AM

    Question:


    I'd like to get help to implement ODBC LoadBalancing for User Store. Could you guide me through the changes on system_odbc.ini?

     

    Answer:

     

    In the system_odbc.ini datadirect file, "LoadBalancing" is actually doing failover. To get it work, you need the following attributes configured :

     

    HostName

    PortNumber

    AlternateServers

    LoadBalancing

     

    The difference between 0 and 1 for LoadBalancing is the way the driver will pick up the next server from the AlternateServers list : 0 = sequential, 1 = random

     

    Here's a configuration sample :

     

    [SiteMinder Oracle Data Source]

    Driver=/opt/CA/siteminder/odbc/lib/NSora23.so

    Description=DataDirect 5.3 Oracle Wire Protocol

    HostName=data1.training.com

    PortNumber=1521

    ServiceName=myservice1

    AlternateServers=(Hostname=data2.training.com:PortNumber=1521:ServiceName=myservice1,Hostname=data3.training.com:PortNumber=1521:ServiceName=myservice1)

    LoadBalancing=1

     

    KB : TEC1478737