Skip to content

/AWS1/IF_RDS=>MODIFYDBPROXY()

About ModifyDBProxy

Changes the settings for an existing DB proxy.

Method Signature

IMPORTING

Required arguments:

iv_dbproxyname TYPE /AWS1/RDSDBPROXYNAME /AWS1/RDSDBPROXYNAME

The identifier for the DBProxy to modify.

Optional arguments:

iv_newdbproxyname TYPE /AWS1/RDSDBPROXYNAME /AWS1/RDSDBPROXYNAME

The new identifier for the DBProxy. An identifier must begin with a letter and must contain only ASCII letters, digits, and hyphens; it can't end with a hyphen or contain two consecutive hyphens.

iv_defaultauthscheme TYPE /AWS1/RDSDEFAULTAUTHSCHEME /AWS1/RDSDEFAULTAUTHSCHEME

The default authentication scheme that the proxy uses for client connections to the proxy and connections from the proxy to the underlying database. Valid values are NONE and IAM_AUTH. When set to IAM_AUTH, the proxy uses end-to-end IAM authentication to connect to the database.

it_auth TYPE /AWS1/CL_RDSUSERAUTHCONFIG=>TT_USERAUTHCONFIGLIST TT_USERAUTHCONFIGLIST

The new authentication settings for the DBProxy.

iv_requiretls TYPE /AWS1/RDSBOOLEANOPTIONAL /AWS1/RDSBOOLEANOPTIONAL

Whether Transport Layer Security (TLS) encryption is required for connections to the proxy. By enabling this setting, you can enforce encrypted TLS connections to the proxy, even if the associated database doesn't use TLS.

iv_idleclienttimeout TYPE /AWS1/RDSINTEGEROPTIONAL /AWS1/RDSINTEGEROPTIONAL

The number of seconds that a connection to the proxy can be inactive before the proxy disconnects it. You can set this value higher or lower than the connection timeout limit for the associated database.

iv_debuglogging TYPE /AWS1/RDSBOOLEANOPTIONAL /AWS1/RDSBOOLEANOPTIONAL

Specifies whether the proxy logs detailed connection and query information. When you enable DebugLogging, the proxy captures connection details and connection pool behavior from your queries. Debug logging increases CloudWatch costs and can impact proxy performance. Enable this option only when you need to troubleshoot connection or performance issues.

iv_rolearn TYPE /AWS1/RDSARN /AWS1/RDSARN

The Amazon Resource Name (ARN) of the IAM role that the proxy uses to access secrets in Amazon Web Services Secrets Manager.

it_securitygroups TYPE /AWS1/CL_RDSSTRINGLIST_W=>TT_STRINGLIST TT_STRINGLIST

The new list of security groups for the DBProxy.

RETURNING

oo_output TYPE REF TO /aws1/cl_rdsmodifydbproxyrsp /AWS1/CL_RDSMODIFYDBPROXYRSP

Domain /AWS1/RT_ACCOUNT_ID
Primitive Type NUMC

Examples

Syntax Example

This is an example of the syntax for calling the method. It includes every possible argument and initializes every possible value. The data provided is not necessarily semantically accurate (for example the value "string" may be provided for something that is intended to be an instance ID, or in some cases two arguments may be mutually exclusive). The syntax shows the ABAP syntax for creating the various data structures.

DATA(lo_result) = lo_client->modifydbproxy(
  it_auth = VALUE /aws1/cl_rdsuserauthconfig=>tt_userauthconfiglist(
    (
      new /aws1/cl_rdsuserauthconfig(
        iv_authscheme = |string|
        iv_clientpasswordauthtype = |string|
        iv_description = |string|
        iv_iamauth = |string|
        iv_secretarn = |string|
        iv_username = |string|
      )
    )
  )
  it_securitygroups = VALUE /aws1/cl_rdsstringlist_w=>tt_stringlist(
    ( new /aws1/cl_rdsstringlist_w( |string| ) )
  )
  iv_dbproxyname = |string|
  iv_debuglogging = ABAP_TRUE
  iv_defaultauthscheme = |string|
  iv_idleclienttimeout = 123
  iv_newdbproxyname = |string|
  iv_requiretls = ABAP_TRUE
  iv_rolearn = |string|
).

This is an example of reading all possible response values

lo_result = lo_result.
IF lo_result IS NOT INITIAL.
  lo_dbproxy = lo_result->get_dbproxy( ).
  IF lo_dbproxy IS NOT INITIAL.
    lv_string = lo_dbproxy->get_dbproxyname( ).
    lv_string = lo_dbproxy->get_dbproxyarn( ).
    lv_dbproxystatus = lo_dbproxy->get_status( ).
    lv_string = lo_dbproxy->get_enginefamily( ).
    lv_string = lo_dbproxy->get_vpcid( ).
    LOOP AT lo_dbproxy->get_vpcsecuritygroupids( ) into lo_row.
      lo_row_1 = lo_row.
      IF lo_row_1 IS NOT INITIAL.
        lv_string = lo_row_1->get_value( ).
      ENDIF.
    ENDLOOP.
    LOOP AT lo_dbproxy->get_vpcsubnetids( ) into lo_row.
      lo_row_1 = lo_row.
      IF lo_row_1 IS NOT INITIAL.
        lv_string = lo_row_1->get_value( ).
      ENDIF.
    ENDLOOP.
    lv_string = lo_dbproxy->get_defaultauthscheme( ).
    LOOP AT lo_dbproxy->get_auth( ) into lo_row_2.
      lo_row_3 = lo_row_2.
      IF lo_row_3 IS NOT INITIAL.
        lv_string = lo_row_3->get_description( ).
        lv_string = lo_row_3->get_username( ).
        lv_authscheme = lo_row_3->get_authscheme( ).
        lv_string = lo_row_3->get_secretarn( ).
        lv_iamauthmode = lo_row_3->get_iamauth( ).
        lv_clientpasswordauthtype = lo_row_3->get_clientpasswordauthtype( ).
      ENDIF.
    ENDLOOP.
    lv_string = lo_dbproxy->get_rolearn( ).
    lv_string = lo_dbproxy->get_endpoint( ).
    lv_boolean = lo_dbproxy->get_requiretls( ).
    lv_integer = lo_dbproxy->get_idleclienttimeout( ).
    lv_boolean = lo_dbproxy->get_debuglogging( ).
    lv_tstamp = lo_dbproxy->get_createddate( ).
    lv_tstamp = lo_dbproxy->get_updateddate( ).
    lv_endpointnetworktype = lo_dbproxy->get_endpointnetworktype( ).
    lv_targetconnectionnetwork = lo_dbproxy->get_targetconnnetworktype( ).
  ENDIF.
ENDIF.