Symantec IGA

 View Only

Use of 3rd party DB tools to pre-validate connectivity for IG

  • 1.  Use of 3rd party DB tools to pre-validate connectivity for IG

    Posted Oct 05, 2016 12:40 AM

    Team,

     

    One challenge that typically occurs during engagements is 1st time connection to a database.    If we are using the installer of a solution, it may be confusing if the terminology used by the installer is not 100% matched to what non-DB team members are used to seeing.

     

    There may also be firewall challenges (OS or network), database login/user ID permissions, database login/user ID not active, database login/user ID using mixed authentication, or the database is not configured for TCP/IP communications.

     

    To help eliminate most of these challenges, the usefulness of a 3rd party DB tool can help you keep your sanity.

     

    The CA Identity Governance / Identity Management / Identity Suite solutions use JDBC drivers.   These drivers may be typically one of the three:    Oracle JDBC, MS-SQL JDBC, jTDS JDBC.

     

    CA Identity Governance uses jTDS JDBC for communication to MS-SQL databases.

     

    The format of the jTDS JDBC URL should be:

     

    jdbc:jtds:sqlserver://ig001:1433;DatabaseName=GM_sdb

    or

    jdbc:jtds:sqlserver://ig001:1433/GM_sdb

    or

    jdbc:jtds:sqlserver://ig001:1433/GM_sdb;instance=1

    or

    jdbc:jtds:sqlserver://ig001:1433/GM_sdb;instance=xyz

     

    As you can see, there are many ways to configure the JDBC url, but the HOSTNAME PORT and DATABASE NAME are consistent.    If a "default instance" is chosen during an install, you may see the URL have "instance=1" or not have it declared.

     

     

    A few screen shots, using DBvisualizer tool, to demonstration the delta between the JDBC URL formats with the jTDS and MS-SQL drivers.

    Database Management Software Tools - DbVisualizer 

     

     

     

     

    Example with MS-SQL JDBC driver (sqljdbc4.jar)

     

     

     

     

    Example with Oracle XE

     

    jdbc:oracle:thin:@//ec2-54-218-11-241.us-west-2.compute.amazonaws.com:1521/XE

     

     

    -Cheers,

     

    Alan