Service Virtualization

  • 1.  Connect IAM to Oracle Service

    Posted 04-17-2019 08:58 AM

    Hi all,


    when I run {INSTALL_DIR}/IdentityAccessManager/bin/DatasourceUpdater and try to configure an Oracle database, it ask the database name but I want to configure the database access throught an Oracle service.



    I want:



    instead of:



    is there a way to achiveve this ?



  • 2.  Re: Connect IAM to Oracle Service

    Broadcom Employee
    Posted 04-17-2019 09:14 AM

    What happens when you give the service name?  Are you facing any errors? 



  • 3.  Re: Connect IAM to Oracle Service
    Best Answer

    Broadcom Employee
    Posted 04-17-2019 09:35 AM
    IAM only supports only a SID, but the connection url in the configuration file can be updated to use service name.


    1. Navigate to /IdentityAccessManager/standalone/configuration
    2. Open standalone.xml
    3. Search for pool-name="KeycloakDS"
    4. Update the connection url as needed.


    Change the connection-url to your service:


    Service format: jdbc:oracle:thin:@//[HOST][:PORT]/SERVICE


    Verify tables created with a JDBC connection tool.


    Let us know if this works.

  • 4.  RE: Re: Connect IAM to Oracle Service

    Posted 12-04-2019 05:26 AM
    It works fine.