Layer 7 API Management

Expand all | Collapse all

How to authenticate user against external database(RDBMS) in OTK?

Jump to Best Answer
  • 1.  How to authenticate user against external database(RDBMS) in OTK?

    Posted 04-24-2018 02:11 AM

    I have a scenario where I need to authenticate the user in Oauth from RDBMS instead of Internal Identity Provider.

     

    please guide how I can achieve it. I am using OTK 4.2 and Gateway 9.3.



  • 2.  Re: How to authenticate user against external database(RDBMS) in OTK?

    Posted 04-24-2018 11:10 AM

    Hi Rhythm,

     

    This may help in getting you started: Database Authentication 

     

    Regards,

    Joe



  • 3.  Re: How to authenticate user against external database(RDBMS) in OTK?

    Posted 04-25-2018 01:49 AM

    Hi Joe,

     

    Thanks for this reference it was helpful, However, this only covers LDAP authentication. I am more interested in RDMS authentication. is it recommended to run DB query from API gateway to authenticate against RDBMS and what variables I need to set or fetch from DB to successfully authenticate and token generation?



  • 4.  Re: How to authenticate user against external database(RDBMS) in OTK?
    Best Answer

    Posted 05-01-2018 09:20 PM

    Do you mean the user info and credential are saved in external database?

    You might think of using Policy-Backed Identity Providers - CA API Gateway - 9.3 - CA Technologies Documentation with a jdbc connection to the external database to retrieve user info.