[\/et_pb_text][et_pb_text ul_type=\"square\" _builder_version=\"4.20.0\" _module_preset=\"default\" text_font=\"Open Sans||||||||\" link_font=\"Open Sans||||on||||\" link_text_color=\"#00A9A0\" ul_font=\"Open Sans||||||||\" ul_font_size=\"17px\" ul_line_height=\"1.6em\" header_2_line_height=\"1.6em\" header_6_font_size=\"16px\" custom_margin=\"1vh||0px||false|false\" custom_padding=\"||||true|false\" text_font_size_tablet=\"20px\" text_font_size_phone=\"17px\" text_font_size_last_edited=\"on|tablet\" header_font_size_tablet=\"\" header_font_size_phone=\"28px\" header_font_size_last_edited=\"on|phone\" global_colors_info=\"{%22gcid-32812186-bc94-4de4-814c-2bf202477fd5%22:%91%22header_text_color%22,%22header_2_text_color%22,%22header_3_text_color%22,%22header_4_text_color%22,%22header_5_text_color%22,%22header_6_text_color%22%93}\" theme_builder_area=\"et_body_layout\"]<\/p>\n
[\/et_pb_text][et_pb_text ul_type=\"square\" _builder_version=\"4.20.0\" _module_preset=\"default\" text_font=\"Open Sans||||||||\" text_text_color=\"gcid-0becd5ff-19fc-4653-a221-c8c75771a987\" text_font_size=\"22px\" link_font=\"Open Sans||||on||||\" link_text_color=\"#00A9A0\" ul_font=\"Open Sans||||||||\" ul_font_size=\"17px\" ul_line_height=\"1.6em\" header_2_line_height=\"1.6em\" header_6_font_size=\"16px\" custom_margin=\"5px||0px||false|false\" custom_padding=\"||||true|false\" text_font_size_tablet=\"20px\" text_font_size_phone=\"17px\" text_font_size_last_edited=\"on|tablet\" header_font_size_tablet=\"\" header_font_size_phone=\"28px\" header_font_size_last_edited=\"on|phone\" global_colors_info=\"{%22gcid-32812186-bc94-4de4-814c-2bf202477fd5%22:%91%22header_text_color%22,%22header_2_text_color%22,%22header_3_text_color%22,%22header_4_text_color%22,%22header_5_text_color%22,%22header_6_text_color%22,%22header_text_color%22,%22header_2_text_color%22,%22header_3_text_color%22,%22header_4_text_color%22,%22header_5_text_color%22,%22header_6_text_color%22,%22header_text_color%22,%22header_2_text_color%22,%22header_3_text_color%22,%22header_4_text_color%22,%22header_5_text_color%22,%22header_6_text_color%22%93,%22gcid-0becd5ff-19fc-4653-a221-c8c75771a987%22:%91%22text_text_color%22%93}\" theme_builder_area=\"et_body_layout\"]<\/i><\/a><\/i><\/a><\/i><\/a>[\/et_pb_text][\/et_pb_column][\/et_pb_row][\/et_pb_section][et_pb_section fb_built=\"1\" _builder_version=\"4.16\" _module_preset=\"default\" custom_padding=\"0vh||10vh||false|false\" global_colors_info=\"{}\" theme_builder_area=\"et_body_layout\"][et_pb_row use_custom_gutter=\"on\" _builder_version=\"4.17.3\" _module_preset=\"default\" custom_padding=\"0px||0px||true|false\" global_colors_info=\"{}\" theme_builder_area=\"et_body_layout\"][et_pb_column type=\"4_4\" _builder_version=\"4.16\" _module_preset=\"default\" global_colors_info=\"{}\" theme_builder_area=\"et_body_layout\"][et_pb_text _builder_version=\"4.25.1\" _module_preset=\"default\" background_enable_color=\"off\" custom_padding=\"0px||0px||true|false\" hover_enabled=\"0\" inline_fonts=\"Times New Roman\" global_colors_info=\"{%22gcid-32812186-bc94-4de4-814c-2bf202477fd5%22:%91%22header_text_color%22,%22header_2_text_color%22,%22header_3_text_color%22%93,%22gcid-0becd5ff-19fc-4653-a221-c8c75771a987%22:%91%22background_color%22%93}\" theme_builder_area=\"et_body_layout\" sticky_enabled=\"0\"]<\/p>\n It is a quite common requirement to integrate Oracle E-Business Suite instances running on Oracle Cloud Infrastructure (OCI) through Oracle Integration Cloud (OIC). In the past this required - since E-Business Suite is nevertheless an \"on Premise Solution\" to install a Connectivity Agent to connect to the database of Oracle E-Business Suite through the database adapter. Recently it is possible to skip that step by using a private endpoint.<\/p>\n Let us have a closer look at this!<\/p>\n Traditionally when connecting from Oracle Integration Cloud (that runs in the OCI data center) to on premise environments the natural solution is to leverage a Connectivity Agent. This is described over there (for OIC3): https:\/\/docs.oracle.com\/en\/cloud\/paas\/application-integration\/integrations-user\/downloading-and-running-premises-agent-installer.html#GUID-C12FA0F2-6264-4C60-BC90-C76850317304<\/a><\/p>\n My colleague Yves Chassein has covered that in great detail over here<\/a>.<\/p>\n Note: It doesn't matter here if the \"Customer on prem application\" is technically running on OCI as well. You still had to install the Connectivity Agent on a virtual machine in OCI to allow (private) connectivity between OIC (on OCI) and your own Virtual Cloud Networks (on OCI as well).<\/p>\n Luckily recently Oracle OIC is providing more and more \"private endpoints\". This results in an architecture as follows:<\/p>\n So using this concept you're able to directly connect from the OIC instance that runs in a \"special network\" in OCI to a Virtual Cloud Network (VCN) of your own OCI Tenancy.<\/p>\n The actual setup is very easy:<\/p>\n First, we create an appropriate subnet in your OCI VCN and allow it to access your target instance; here that is an OCI Base Database Service:<\/p>\n After that we can create a private endpoint in the Oracle Integration Cloud (OCI console part):<\/p>\n Finally, you can change your database connection to be a DBaaS (instead of a regular Database) Adapter Connection and then enter the details to connect to the database as follows:<\/p>\n The DBaaS adapter has the same capabilities as the \"regular\", \"onPrem\" Database adapter of OIC. Note: as the documentation states, it is mandatory to provide the hostname and NOT the IP address of the database to be connected; otherwise, you'll get a very difficult to understand or correlate error:<\/p>\n {\"detail\":\"\",\"status\":\"HTTP 500 Internal Server Error\",\"title\":\"Operation [testConnection] failed: This connection is configured with an address which is not in an allowable range\",\"type\":\"https:\/\/www.w3.org\/Protocols\/rfc2616\/rfc2616-sec10.html#sec10.5.1\"}<\/p>\n<\/blockquote>\n The documentation for this can be found here: https:\/\/docs.oracle.com\/en\/cloud\/paas\/application-integration\/dbaas-adapter\/using-oracle-database-cloud-service-adapter-oracle-integration-3.pdf<\/a><\/p>\n![](\"\/.\/wp-content\/uploads\/2023\/02\/ACE-Director-Logo_175x51.jpg\"){kind=logo}
Executive Vice President<\/strong> \u2013\u00a0Head of Platforms\u00a0&\u00a0Development<\/p>\nArchitecture when using the Connectivity Agent<\/h2>\n
![\"\"](\"https:\/\/promatis.com\/de\/wp-content\/uploads\/2024\/08\/oic-to-oci-database-private-endpoint_2.jpg\")
Integration Pattern when using the Connectivity Agent<\/em><\/p>\nPrivate Endpoints<\/h2>\n
![\"\"](\"https:\/\/promatis.com\/de\/wp-content\/uploads\/2024\/08\/oic-to-oci-database-private-endpoint_1.jpg\")
Architecture with private endpoints<\/em><\/p>\nSetup Step-by-Step<\/h2>\n
![\"\"](\"https:\/\/promatis.com\/de\/wp-content\/uploads\/2024\/08\/oic-to-oci-database-private-endpoint_3.jpg\")
Subnets used for the OIC private endpoint (named soa-subnet here)<\/em><\/p>\n![\"\"](\"https:\/\/promatis.com\/de\/wp-content\/uploads\/2024\/08\/oic-to-oci-database-private-endpoint_4.jpg\")
Ingress rule attached to the database network allowing connectivity from the OIC private endpoint network<\/em><\/p>\n![\"\"](\"https:\/\/promatis.com\/de\/wp-content\/uploads\/2024\/08\/oic-to-oci-database-private-endpoint_5.jpg\")
Private endpoint connecting OIC to a OCI VCN Subnet<\/em><\/p>\n![\"\"](\"https:\/\/promatis.com\/de\/wp-content\/uploads\/2024\/08\/oic-to-oci-database-private-endpoint_6.jpg\")
Connecting through a Base Database through a private endpoint<\/em><\/p>\n\n
Summary<\/h2>\n