Convert a Service Connection (Static to Dynamic or Dynamic to Static)

You can convert an existing service connection, either from static to dynamic or dynamic to static, to suit your application's requirements that may change over the course of its lifecycle.

Typically, it's useful to create a dynamic service connection during an application's development stage, when endpoints defined in the service metadata are still evolving. A dynamic connection fetches the service's OpenAPI3 metadata from the source URL whenever the app is opened, enabling your application to get all the updates included in the current version of the metadata. When you deem the service metadata to be stable and your application ready for production, you might want to switch the dynamic service connection to static—because while dynamic connections provide the most recent updates, they may impact performance. A static connection, on the other hand, has better performance because the service metadata is part of your application's code.

Conversely, if your application's service metadata is changing and you want to include these updates as you work on your app, you can convert your static service connection to a dynamic one. In this case, the service metadata is copied from the source URL and saved to the application's sources.

For ADF Describe services, however, always choose the recommended option for optimal runtime performance. This option copies minimal service metadata for the endpoints you select from the source URL to the application and dynamically retrieves the request/response schema when required. It provides the benefits of a static and a dynamic service connection and is recommended for both static and dynamic ADF Describe-based service connections:
Screenshot of a service connection's Overview tab, where the recommended option is highlighted

  • To convert your service connection to dynamic:
    1. Open the Overview tab of a static service connection, then click the dynamically retrieving metadata link.
    2. In the Edit Service Connection dialog box, notice the Dynamically retrieve metadata option that's selected. You'll also see a message about the number of endpoints that will be added to the connection. Remember that dynamic service connections always include whole resources, rather than individual endpoints.

      If you want all LOVs for the selected objects/endpoints in an Oracle Cloud Applications catalog to be automatically included in the service metadata, select Automatically include list of values (LOV).


      Description of static_sc_edit.png follows
      Description of the illustration static_sc_edit.png

    3. Click Convert.

      The static service connection becomes dynamic.

  • To convert your service connection to static:
    1. Open the Overview tab of a dynamic service connection, then click the copying full OpenAPI link.
    2. In the Edit Object Selection dialog box, select the endpoints you want to use in your application.


      Notice the Copy full OpenAPI to the application option that's selected and a message about the number of endpoints that will be removed from the connection.

    3. Click Convert.

      The dynamic service connection becomes static.