{"id":407074,"date":"2023-11-06T05:38:45","date_gmt":"2023-11-06T05:38:45","guid":{"rendered":"https:\/\/webkul.com\/blog\/?p=407074"},"modified":"2023-11-21T08:36:34","modified_gmt":"2023-11-21T08:36:34","slug":"oracle-akeneo-connector-user-guide","status":"publish","type":"post","link":"https:\/\/webkul.com\/blog\/oracle-akeneo-connector-user-guide\/","title":{"rendered":"Oracle Akeneo Connector &#8211; User Guide"},"content":{"rendered":"\n<p>The <a href=\"https:\/\/webkul.com\/blog\/oracle-akeneo-connector-user-guide\/\" target=\"_blank\" rel=\"noreferrer noopener\">Oracle Akeneo Connector<\/a> facilitates the user to export various data on the Oracle database with the help of multiple export jobs. <\/p>\n\n\n\n<p>Users can create various jobs and export them on the Oracle database. They can also remove stored data from the Oracle database. <\/p>\n\n\n\n<div class=\"wk-index-wrap\"><div class=\"block-wrap\">\n<h2 class=\"wp-block-heading index-title\">Basic Requirements<\/h2>\n<\/div><\/div>\n\n\n\n<ul class=\"wp-block-list\">\n<li>This module works with Akeneo 7.0.x. Download Akeneo from&nbsp;<a href=\"https:\/\/www.akeneo.com\/download\/\" target=\"_blank\" rel=\"noreferrer noopener nofollow\">here<\/a><\/li>\n\n\n\n<li>This module is compatible with the Akeneo community and Enterprise(Flexibility) edition.<\/li>\n\n\n\n<li>If you want to use this extension on Akeneo EE Serenity mode, please&nbsp;<a href=\"mailto:support@webkul.com\" target=\"_blank\" rel=\"noreferrer noopener\">contact us<\/a>.<\/li>\n\n\n\n<li>For the Akeneo installation, your Akeneo server should meet these&nbsp;<a href=\"https:\/\/docs.akeneo.com\/7.0\/install_pim\/manual\/system_requirements\/system_requirements.html\" target=\"_blank\" rel=\"noreferrer noopener nofollow\">system requirements<\/a>.<\/li>\n<\/ul>\n\n\n\n<div class=\"wk-index-wrap\"><div class=\"block-wrap\">\n<h2 class=\"wp-block-heading index-title\">Features of Oracle Akeneo Connector <\/h2>\n<\/div><\/div>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Export Association types from Akeneo to Oracle Database.<\/li>\n\n\n\n<li>The admin can export Attribute Group, Attributes, and Family from Akeneo to the Oracle Database.<\/li>\n\n\n\n<li>Export Channel, Locale, and Currencies from Akeneo to Oracle Database.<\/li>\n\n\n\n<li>They can also export Categories from Akeneo to Oracle Database.<\/li>\n\n\n\n<li>Export Products from Akeneo to Oracle Database.<\/li>\n\n\n\n<li>Remove data from the Oracle database.<\/li>\n<\/ul>\n\n\n\n<p><strong>Note<\/strong> &#8211; If you want to back up your Akeneo database and assets you can use the <a href=\"https:\/\/webkul.com\/blog\/akeneo-backup-management\/\" target=\"_blank\" rel=\"noreferrer noopener\">Akeneo backup Management <\/a>extension.  <\/p>\n\n\n\n<div class=\"wk-index-wrap\"><div class=\"block-wrap\">\n<h2 class=\"wp-block-heading index-title\">Installation of Oracle Akeneo Connector <\/h2>\n<\/div><\/div>\n\n\n\n<p>Two different types of module installation processes are available for the module.<\/p>\n\n\n\n<ol class=\"wp-block-list\">\n<li>Composer Installation<\/li>\n\n\n\n<li>Manual Installation<\/li>\n<\/ol>\n\n\n\n<h3 class=\"wp-block-heading\" id=\"installation-using-composer\">Installation using Composer<\/h3>\n\n\n\n<p><a href=\"https:\/\/webkul.com\/blog\/how-to-install-webkul-akeneo-connector-via-composer\/\"><strong>Read This Blog<\/strong><\/a><\/p>\n\n\n\n<p>Before beginning the composer installation<\/p>\n\n\n\n<p><strong>1<\/strong>: Get the&nbsp;<strong>ACCESS KEYS<\/strong>&nbsp;[Create a&nbsp;<a href=\"https:\/\/webkul.uvdesk.com\/en\/customer\/create-ticket\/\">support ticket<\/a>]<br><strong>2<\/strong>: In Akeneo&nbsp;<strong>composer.json<\/strong>, add our repository as well as the installation script.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\"><strong>For Akeneo 6.x&nbsp;<\/strong>&nbsp;<strong>and 7.x<\/strong><\/h3>\n\n\n\n<pre class=\"EnlighterJSRAW\">```\n{\n  &quot;scripts&quot;: {\n        &quot;post-update-cmd&quot;: &#091;\n           &quot;vendor\/webkul\/akeneooraclebundle\/src\/Webkul\/AkeneoOracleBundle\/install\/config.sh COMPOSER=true NO_DOCKER=true&quot;\n        ],\n        &quot;post-install-cmd&quot;: &#091;\n           &quot;vendor\/webkul\/akeneooraclebundle\/src\/Webkul\/AkeneoOracleBundle\/install\/config.sh COMPOSER=true NO_DOCKER=true&quot;\n        ],\n        &quot;post-create-project-cmd&quot;: &#091;\n          &quot;vendor\/webkul\/akeneooraclebundle\/src\/Webkul\/AkeneoOracleBundle\/install\/config.sh COMPOSER=true NO_DOCKER=true&quot;\n       ]\n   },\n  &quot;repositories&quot;: &#091;{\n    &quot;type&quot;: &quot;composer&quot;,\n    &quot;url&quot;: &quot;https:\/\/akeneorepo.webkul.com\/&quot;\n  }]\n}<\/pre>\n\n\n\n<p>Step 3: Install the extension using Composer.<\/p>\n\n\n\n<pre class=\"EnlighterJSRAW\">composer require webkul\/akeneooraclebundle<\/pre>\n\n\n\n<p>Step4: Fill in the authentication.<\/p>\n\n\n\n<p>Step 5: Success Message<\/p>\n\n\n\n<p>Step 6: Clear Browser cache<\/p>\n\n\n\n<h3 class=\"wp-block-heading\">Manual Installation: Version 7.x and 6.x<\/h3>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Unzip the respective extension zip and then merge &#8220;src&#8221; folder into akeneo project<\/li>\n<\/ul>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Run the below command over the NO-DOCKER Instance from the PIM directory<\/li>\n<\/ul>\n\n\n\n<pre class=\"EnlighterJSRAW\">.\/src\/Webkul\/AkeneoOracleBundle\/install\/config.sh COMPOSER=false NO_DOCKER=true<\/pre>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Run the below command over the docker Instance from the PIM directory<\/li>\n<\/ul>\n\n\n\n<pre class=\"EnlighterJSRAW\">.\/src\/Webkul\/AkeneoOracleBundle\/install\/config.sh COMPOSER=false NO_DOCKER=false<\/pre>\n\n\n\n<h3 class=\"wp-block-heading\">Version 5.x<\/h3>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Unzip the respective extension zip and then merge the &#8220;src&#8221; folder into the akeneo project. Goto app\/Bundles.php and add line<\/li>\n<\/ul>\n\n\n\n<pre class=\"EnlighterJSRAW\">Webkul\\AkeneoOracleBundle\\AkeneoOracleBundle::class =&gt; &#091;&#039;all&#039; =&gt; true],<\/pre>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Copy to the &#8220;config&#8221; folder into the akeneo project root directory for routing.<\/li>\n<\/ul>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Run this command after SSH to your akeneo server by terminal<\/li>\n<\/ul>\n\n\n\n<h4 class=\"wp-block-heading\">For non-docker instance:<\/h4>\n\n\n\n<pre class=\"EnlighterJSRAW\">rm -rf var\/cache &amp;&amp; php bin\/console ca:warmup &amp;&amp; php bin\/console wk_oracle:setup:install<\/pre>\n\n\n\n<h4 class=\"wp-block-heading\">For docker instance:<\/h4>\n\n\n\n<pre class=\"EnlighterJSRAW\">    alias docker_php=&#039;docker-compose run -u www-data --rm php php&#039;;\n    alias docker_yarn=&#039;docker-compose run -u node --rm node yarn&#039;;\n    docker_php bin\/console cache:clear --env=prod;\n    docker_php bin\/console pim:installer:assets --symlink --clean --env=prod;\n    docker_php bin\/console d:s:u --force;\n    docker_yarn run webpack;\n    docker_yarn run update-extensions;\n    docker_yarn run less;<\/pre>\n\n\n\n<h3 class=\"wp-block-heading\">Uninstall Module: Version 7.x<\/h3>\n\n\n\n<p>Run the below command over the NO-DOCKER Instance from the PIM directory.<\/p>\n\n\n\n<pre class=\"EnlighterJSRAW\">.\/src\/Webkul\/AkeneoOracleBundle\/uninstall\/uninstall.sh COMPOSER=false NO_DOCKER=true<\/pre>\n\n\n\n<p>Run the below command over the DOCKER Instance from the PIM directory.<\/p>\n\n\n\n<pre class=\"EnlighterJSRAW\">.\/src\/Webkul\/AkeneoOracleBundle\/uninstall\/uninstall.sh COMPOSER=false NO_DOCKER=false<\/pre>\n\n\n\n<div class=\"wk-index-wrap\"><div class=\"block-wrap\">\n<h3 class=\"wp-block-heading index-title\"><strong>How can I Generate API Credentials for Oracle Database &amp; Securing with OAuth2?<\/strong><\/h3>\n<\/div><\/div>\n\n\n\n<p>To generate the API credentials please follow the mentioned steps below: <\/p>\n\n\n\n<ol class=\"wp-block-list\">\n<li><strong>Create a Role and Privilege:<\/strong> You need to navigate to <strong>SQL Workshop &gt; RESTful Services<\/strong>. From the left side of the tree, click on &#8220;Roles.&#8221; Create a new Role, e.g., &#8220;WebkulRole.&#8221;<\/li>\n<\/ol>\n\n\n\n<figure class=\"wp-block-image size-full\"><img decoding=\"async\" width=\"1120\" height=\"880\" src=\"https:\/\/cdnblog.webkul.com\/blog\/wp-content\/uploads\/2023\/11\/apex.oracle.com_pls_apex_r_apex_rest_role-definition_clearRP180session15277057399753webkul-store.png\" alt=\"apex.oracle.com_pls_apex_r_apex_rest_role-definition_clearRP180session15277057399753webkul-store\" class=\"wp-image-412067\" srcset=\"https:\/\/cdnblog.webkul.com\/blog\/wp-content\/uploads\/2023\/11\/apex.oracle.com_pls_apex_r_apex_rest_role-definition_clearRP180session15277057399753webkul-store.png 1120w, https:\/\/cdnblog.webkul.com\/blog\/wp-content\/uploads\/2023\/11\/apex.oracle.com_pls_apex_r_apex_rest_role-definition_clearRP180session15277057399753webkul-store-300x236.png 300w, https:\/\/cdnblog.webkul.com\/blog\/wp-content\/uploads\/2023\/11\/apex.oracle.com_pls_apex_r_apex_rest_role-definition_clearRP180session15277057399753webkul-store-250x196.png 250w, https:\/\/cdnblog.webkul.com\/blog\/wp-content\/uploads\/2023\/11\/apex.oracle.com_pls_apex_r_apex_rest_role-definition_clearRP180session15277057399753webkul-store-768x603.png 768w\" sizes=\"(max-width: 1120px) 100vw, 1120px\" loading=\"lazy\" \/><\/figure>\n\n\n\n<p>From the left side of the tree, click on &#8220;Privileges.&#8221;<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img decoding=\"async\" width=\"1120\" height=\"880\" src=\"https:\/\/cdnblog.webkul.com\/blog\/wp-content\/uploads\/2023\/11\/apex.oracle.com_pls_apex_r_apex_rest_privilege-definition_p160_privilege_id3800649p0_selected_nodePP3800649clear160session114243393108887webkul-store.png\" alt=\"apex.oracle.com_pls_apex_r_apex_rest_privilege-definition_p160_privilege_id3800649p0_selected_nodePP3800649clear160session114243393108887webkul-store\" class=\"wp-image-412090\" srcset=\"https:\/\/cdnblog.webkul.com\/blog\/wp-content\/uploads\/2023\/11\/apex.oracle.com_pls_apex_r_apex_rest_privilege-definition_p160_privilege_id3800649p0_selected_nodePP3800649clear160session114243393108887webkul-store.png 1120w, https:\/\/cdnblog.webkul.com\/blog\/wp-content\/uploads\/2023\/11\/apex.oracle.com_pls_apex_r_apex_rest_privilege-definition_p160_privilege_id3800649p0_selected_nodePP3800649clear160session114243393108887webkul-store-300x236.png 300w, https:\/\/cdnblog.webkul.com\/blog\/wp-content\/uploads\/2023\/11\/apex.oracle.com_pls_apex_r_apex_rest_privilege-definition_p160_privilege_id3800649p0_selected_nodePP3800649clear160session114243393108887webkul-store-250x196.png 250w, https:\/\/cdnblog.webkul.com\/blog\/wp-content\/uploads\/2023\/11\/apex.oracle.com_pls_apex_r_apex_rest_privilege-definition_p160_privilege_id3800649p0_selected_nodePP3800649clear160session114243393108887webkul-store-768x603.png 768w\" sizes=\"(max-width: 1120px) 100vw, 1120px\" loading=\"lazy\" \/><\/figure>\n\n\n\n<p>Create a new Privilege with the following details:<br>Name: &#8220;WebkulAccess&#8221;<br>Title: &#8220;WebkulAccess&#8221;<br>Roles: &#8220;WebkulRole&#8221;<br>Protected Modules: &#8220;Akeneo&#8221;<\/p>\n\n\n\n<h4 class=\"wp-block-heading\">2. <strong>Test the Web Service Method:<\/strong><\/h4>\n\n\n\n<p>After setting up the Privilege, test one of the methods of your web service. It should return a 401 Unauthorized response, indicating that the access is protected.<\/p>\n\n\n\n<p>3. <strong>Create a New Client<\/strong>: Execute the following script to create a new client with client_credentials grant type. Path: <strong>SQL workshop &gt; SQL Commands<\/strong>.<\/p>\n\n\n\n<pre class=\"EnlighterJSRAW\">BEGIN\nOAUTH.create_client(\np_name =&gt; &#039;Webkul Access Client&#039;,\np_grant_type =&gt; &#039;client_credentials&#039;,\np_owner =&gt; &#039;OracleExampleWebkul&#039;,\np_description =&gt; &#039;An example client created for my blog.&#039;,\np_support_email =&gt; &#039;akeneo@webkul.in&#039;,\np_privilege_names =&gt; &#039;WebkulAccess&#039;\n);\nCOMMIT;\nEND;<\/pre>\n\n\n\n<figure class=\"wp-block-image size-large\"><img decoding=\"async\" width=\"1200\" height=\"498\" src=\"https:\/\/cdnblog.webkul.com\/blog\/wp-content\/uploads\/2023\/11\/Screenshot-2023-11-17T170145.936-1200x498.png\" alt=\"Screenshot-2023-11-17T170145.936\" class=\"wp-image-412072\" srcset=\"https:\/\/cdnblog.webkul.com\/blog\/wp-content\/uploads\/2023\/11\/Screenshot-2023-11-17T170145.936-1200x498.png 1200w, https:\/\/cdnblog.webkul.com\/blog\/wp-content\/uploads\/2023\/11\/Screenshot-2023-11-17T170145.936-300x125.png 300w, https:\/\/cdnblog.webkul.com\/blog\/wp-content\/uploads\/2023\/11\/Screenshot-2023-11-17T170145.936-250x104.png 250w, https:\/\/cdnblog.webkul.com\/blog\/wp-content\/uploads\/2023\/11\/Screenshot-2023-11-17T170145.936-768x319.png 768w, https:\/\/cdnblog.webkul.com\/blog\/wp-content\/uploads\/2023\/11\/Screenshot-2023-11-17T170145.936.png 1288w\" sizes=\"(max-width: 1200px) 100vw, 1200px\" loading=\"lazy\" \/><\/figure>\n\n\n\n<p>4. <strong>Grant Client to Role:<\/strong> Execute the following script to grant the newly created client to the &#8220;WebkulRole&#8221; role:<\/p>\n\n\n\n<pre class=\"EnlighterJSRAW\">BEGIN\noauth.grant_client_role(p_client_name =&gt; &#039;Webkul Access Client&#039;, p_role_name =&gt; &#039;WebkulRole&#039;);\nCOMMIT;\nEND;<\/pre>\n\n\n\n<figure class=\"wp-block-image size-large\"><img decoding=\"async\" width=\"1200\" height=\"508\" src=\"https:\/\/cdnblog.webkul.com\/blog\/wp-content\/uploads\/2023\/11\/Screenshot-2023-11-17T183813.274-1200x508.png\" alt=\"Screenshot-2023-11-17T183813.274\" class=\"wp-image-412091\" srcset=\"https:\/\/cdnblog.webkul.com\/blog\/wp-content\/uploads\/2023\/11\/Screenshot-2023-11-17T183813.274-1200x508.png 1200w, https:\/\/cdnblog.webkul.com\/blog\/wp-content\/uploads\/2023\/11\/Screenshot-2023-11-17T183813.274-300x127.png 300w, https:\/\/cdnblog.webkul.com\/blog\/wp-content\/uploads\/2023\/11\/Screenshot-2023-11-17T183813.274-250x106.png 250w, https:\/\/cdnblog.webkul.com\/blog\/wp-content\/uploads\/2023\/11\/Screenshot-2023-11-17T183813.274-768x325.png 768w, https:\/\/cdnblog.webkul.com\/blog\/wp-content\/uploads\/2023\/11\/Screenshot-2023-11-17T183813.274.png 1291w\" sizes=\"(max-width: 1200px) 100vw, 1200px\" loading=\"lazy\" \/><\/figure>\n\n\n\n<p>5. <strong>Check Client ID and Secret<\/strong>: Use the following query to check if a record is created for the Client ID and Secret:<\/p>\n\n\n\n<pre class=\"EnlighterJSRAW\">SELECT id, client_id, client_secret FROM user_ords_clients WHERE name = &#039;Webkul Access Client&#039;;<\/pre>\n\n\n\n<figure class=\"wp-block-image size-large\"><img decoding=\"async\" width=\"1200\" height=\"541\" src=\"https:\/\/cdnblog.webkul.com\/blog\/wp-content\/uploads\/2023\/11\/Screenshot-2023-11-17T170711.452-1200x541.png\" alt=\"Screenshot-2023-11-17T170711.452\" class=\"wp-image-412074\" srcset=\"https:\/\/cdnblog.webkul.com\/blog\/wp-content\/uploads\/2023\/11\/Screenshot-2023-11-17T170711.452-1200x541.png 1200w, https:\/\/cdnblog.webkul.com\/blog\/wp-content\/uploads\/2023\/11\/Screenshot-2023-11-17T170711.452-300x135.png 300w, https:\/\/cdnblog.webkul.com\/blog\/wp-content\/uploads\/2023\/11\/Screenshot-2023-11-17T170711.452-250x113.png 250w, https:\/\/cdnblog.webkul.com\/blog\/wp-content\/uploads\/2023\/11\/Screenshot-2023-11-17T170711.452-768x346.png 768w, https:\/\/cdnblog.webkul.com\/blog\/wp-content\/uploads\/2023\/11\/Screenshot-2023-11-17T170711.452.png 1287w\" sizes=\"(max-width: 1200px) 100vw, 1200px\" loading=\"lazy\" \/><\/figure>\n\n\n\n<p>With these steps, your Oracle APEX application&#8217;s RESTful APIs will be secured using OAuth2. You will need to obtain an access token using the client_credentials grant type and include it in the Authorization header of their requests to access the protected resources. The access token can be obtained by making an OAuth2 token request using the Client ID and Secret you created earlier.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\">Configure the module-<\/h3>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Open the <strong>ORDS_REST_WKSP_WEBKUL_Akeneo.sql<\/strong> file change <code><strong>p_schema<\/strong><\/code> with your schema and <code><strong>p_url_mapping_pattern<\/strong><\/code> with your Workspace name and save the file.<\/li>\n\n\n\n<li>p_schema => &#8216;schema-name&#8217;,<\/li>\n\n\n\n<li>p_url_mapping_pattern => &#8216;schema-alias&#8217;,<\/li>\n<\/ul>\n\n\n\n<p>Where: schema-name is the database schema name in all-uppercase.<\/p>\n\n\n\n<p>schema-alias is an alias for the schema name that will appear in the URL the user will use to access Database Actions.<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img decoding=\"async\" width=\"1200\" height=\"447\" src=\"https:\/\/cdnblog.webkul.com\/blog\/wp-content\/uploads\/2023\/11\/screenshot__4_-1200x447.png\" alt=\"screenshot__4_\" class=\"wp-image-412265\" srcset=\"https:\/\/cdnblog.webkul.com\/blog\/wp-content\/uploads\/2023\/11\/screenshot__4_-1200x447.png 1200w, https:\/\/cdnblog.webkul.com\/blog\/wp-content\/uploads\/2023\/11\/screenshot__4_-300x112.png 300w, https:\/\/cdnblog.webkul.com\/blog\/wp-content\/uploads\/2023\/11\/screenshot__4_-250x93.png 250w, https:\/\/cdnblog.webkul.com\/blog\/wp-content\/uploads\/2023\/11\/screenshot__4_-768x286.png 768w, https:\/\/cdnblog.webkul.com\/blog\/wp-content\/uploads\/2023\/11\/screenshot__4_.png 1309w\" sizes=\"(max-width: 1200px) 100vw, 1200px\" loading=\"lazy\" \/><\/figure>\n\n\n\n<p>Configure the Module SQL file:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Import RESTful Service Module using <strong>ORDS_REST_WKSP_WEBKUL_Akeneo.sql<\/strong> to your Oracle APEX RESTful services on the path: <strong>SQL Workshop-&gt;RESTful Data Services-&gt;Import<\/strong><\/li>\n<\/ul>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Create Table and Sequence in your Oracle Apex using the file <strong>WebkulTableSequence.sql<\/strong> on the path: <strong>SQL Workshop-&gt;SQL Scripts-&gt;Upload<\/strong><\/li>\n<\/ul>\n\n\n\n<p>You need to open the Oracle website and select Oracle Apex. <\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img decoding=\"async\" width=\"1120\" height=\"880\" src=\"https:\/\/cdnblog.webkul.com\/blog\/wp-content\/uploads\/2023\/11\/apex.oracle.com_pls_apex___landingwebkul-store.png\" alt=\"apex.oracle.com_pls_apex___landingwebkul-store\" class=\"wp-image-410433\" srcset=\"https:\/\/cdnblog.webkul.com\/blog\/wp-content\/uploads\/2023\/11\/apex.oracle.com_pls_apex___landingwebkul-store.png 1120w, https:\/\/cdnblog.webkul.com\/blog\/wp-content\/uploads\/2023\/11\/apex.oracle.com_pls_apex___landingwebkul-store-300x236.png 300w, https:\/\/cdnblog.webkul.com\/blog\/wp-content\/uploads\/2023\/11\/apex.oracle.com_pls_apex___landingwebkul-store-250x196.png 250w, https:\/\/cdnblog.webkul.com\/blog\/wp-content\/uploads\/2023\/11\/apex.oracle.com_pls_apex___landingwebkul-store-768x603.png 768w\" sizes=\"(max-width: 1120px) 100vw, 1120px\" loading=\"lazy\" \/><\/figure>\n\n\n\n<p>Once you create the Workspace you will get the Workspace ID, username, and password that needs to be entered <a href=\"https:\/\/apex.oracle.com\/pls\/apex\/_\/landing\" target=\"_blank\" rel=\"noreferrer noopener nofollow\">here<\/a>. <\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img decoding=\"async\" width=\"1120\" height=\"880\" src=\"https:\/\/cdnblog.webkul.com\/blog\/wp-content\/uploads\/2023\/11\/apex.oracle.com_pls_apex_r_apex_workspace-sign-in_oracle-apex-sign-in_session12329611423600webkul-store.png\" alt=\"apex.oracle.com_pls_apex_r_apex_workspace-sign-in_oracle-apex-sign-in_session12329611423600webkul-store\" class=\"wp-image-410434\" srcset=\"https:\/\/cdnblog.webkul.com\/blog\/wp-content\/uploads\/2023\/11\/apex.oracle.com_pls_apex_r_apex_workspace-sign-in_oracle-apex-sign-in_session12329611423600webkul-store.png 1120w, https:\/\/cdnblog.webkul.com\/blog\/wp-content\/uploads\/2023\/11\/apex.oracle.com_pls_apex_r_apex_workspace-sign-in_oracle-apex-sign-in_session12329611423600webkul-store-300x236.png 300w, https:\/\/cdnblog.webkul.com\/blog\/wp-content\/uploads\/2023\/11\/apex.oracle.com_pls_apex_r_apex_workspace-sign-in_oracle-apex-sign-in_session12329611423600webkul-store-250x196.png 250w, https:\/\/cdnblog.webkul.com\/blog\/wp-content\/uploads\/2023\/11\/apex.oracle.com_pls_apex_r_apex_workspace-sign-in_oracle-apex-sign-in_session12329611423600webkul-store-768x603.png 768w\" sizes=\"(max-width: 1120px) 100vw, 1120px\" loading=\"lazy\" \/><\/figure>\n\n\n\n<p>Once you enter the details you can open the Oracle database.<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img decoding=\"async\" width=\"1120\" height=\"880\" src=\"https:\/\/cdnblog.webkul.com\/blog\/wp-content\/uploads\/2023\/11\/apex.png\" alt=\"apex\" class=\"wp-image-410435\" srcset=\"https:\/\/cdnblog.webkul.com\/blog\/wp-content\/uploads\/2023\/11\/apex.png 1120w, https:\/\/cdnblog.webkul.com\/blog\/wp-content\/uploads\/2023\/11\/apex-300x236.png 300w, https:\/\/cdnblog.webkul.com\/blog\/wp-content\/uploads\/2023\/11\/apex-250x196.png 250w, https:\/\/cdnblog.webkul.com\/blog\/wp-content\/uploads\/2023\/11\/apex-768x603.png 768w\" sizes=\"(max-width: 1120px) 100vw, 1120px\" loading=\"lazy\" \/><\/figure>\n\n\n\n<p>You can check the exported data in the SQL workshop with exported job names.<\/p>\n\n\n\n<p>Note- Please explore our&nbsp;<a href=\"https:\/\/webkul.com\/akeneo\/\" target=\"_blank\" rel=\"noreferrer noopener\">Akeneo Development Services<\/a>&nbsp;and Quality&nbsp;<a href=\"https:\/\/store.webkul.com\/Akeneo.html\" target=\"_blank\" rel=\"noreferrer noopener\">Akeneo Extensions<\/a>.<\/p>\n\n\n\n<div class=\"wk-index-wrap\"><div class=\"block-wrap\">\n<h3 class=\"wp-block-heading index-title\">How to Setup Oracle in Akeneo <\/h3>\n<\/div><\/div>\n\n\n\n<p>Go to the&nbsp;Credentials&nbsp;tab, enter your Rest API URL, Client ID, and Client Secret, and then save your credentials.<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img decoding=\"async\" width=\"1120\" height=\"880\" src=\"https:\/\/cdnblog.webkul.com\/blog\/wp-content\/uploads\/2023\/10\/akeneo-demo.webkul.com_7219_webkul-store.png\" alt=\"Oracle Akeneo Connector\" class=\"wp-image-407111\" srcset=\"https:\/\/cdnblog.webkul.com\/blog\/wp-content\/uploads\/2023\/10\/akeneo-demo.webkul.com_7219_webkul-store.png 1120w, https:\/\/cdnblog.webkul.com\/blog\/wp-content\/uploads\/2023\/10\/akeneo-demo.webkul.com_7219_webkul-store-300x236.png 300w, https:\/\/cdnblog.webkul.com\/blog\/wp-content\/uploads\/2023\/10\/akeneo-demo.webkul.com_7219_webkul-store-250x196.png 250w, https:\/\/cdnblog.webkul.com\/blog\/wp-content\/uploads\/2023\/10\/akeneo-demo.webkul.com_7219_webkul-store-768x603.png 768w\" sizes=\"(max-width: 1120px) 100vw, 1120px\" loading=\"lazy\" \/><\/figure>\n\n\n\n<div class=\"wk-index-wrap\"><div class=\"block-wrap\">\n<h3 class=\"wp-block-heading index-title\">How to Export Data to Oracle Database<\/h3>\n<\/div><\/div>\n\n\n\n<p>Go to&nbsp;Export jobs&nbsp;and Create a job by entering a&nbsp;code,&nbsp;and label,&nbsp;and Selecting&nbsp;Akeneo Oracle Export Job.<\/p>\n\n\n\n<p>You can export the following jobs to export the product data to the Oracle database. <\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Association type export<\/li>\n\n\n\n<li>Attribute export<\/li>\n\n\n\n<li>Category export<\/li>\n\n\n\n<li>Channel export<\/li>\n\n\n\n<li>Currency export<\/li>\n\n\n\n<li>Family export<\/li>\n\n\n\n<li>Locale export<\/li>\n\n\n\n<li>Product export<\/li>\n<\/ul>\n\n\n\n<figure class=\"wp-block-image size-full\"><img decoding=\"async\" width=\"1120\" height=\"880\" src=\"https:\/\/cdnblog.webkul.com\/blog\/wp-content\/uploads\/2023\/11\/akeneo-demo.webkul.com_7298_webkul-store.png\" alt=\"akeneo-demo.webkul.com_7298_webkul-store\" class=\"wp-image-412092\" srcset=\"https:\/\/cdnblog.webkul.com\/blog\/wp-content\/uploads\/2023\/11\/akeneo-demo.webkul.com_7298_webkul-store.png 1120w, https:\/\/cdnblog.webkul.com\/blog\/wp-content\/uploads\/2023\/11\/akeneo-demo.webkul.com_7298_webkul-store-300x236.png 300w, https:\/\/cdnblog.webkul.com\/blog\/wp-content\/uploads\/2023\/11\/akeneo-demo.webkul.com_7298_webkul-store-250x196.png 250w, https:\/\/cdnblog.webkul.com\/blog\/wp-content\/uploads\/2023\/11\/akeneo-demo.webkul.com_7298_webkul-store-768x603.png 768w\" sizes=\"(max-width: 1120px) 100vw, 1120px\" loading=\"lazy\" \/><\/figure>\n\n\n\n<p>After creating the job, go to&nbsp;the Content tab&nbsp;and add the necessary filters in&nbsp;FILTER THE DATA&nbsp;and&nbsp;FILTER THE PRODUCTS. After that, Save the job.<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img decoding=\"async\" width=\"1120\" height=\"880\" src=\"https:\/\/cdnblog.webkul.com\/blog\/wp-content\/uploads\/2023\/10\/akeneo-demo.webkul.com_7203_webkul-store-2.png\" alt=\"Oracle Akeneo Connector\" class=\"wp-image-407387\" srcset=\"https:\/\/cdnblog.webkul.com\/blog\/wp-content\/uploads\/2023\/10\/akeneo-demo.webkul.com_7203_webkul-store-2.png 1120w, https:\/\/cdnblog.webkul.com\/blog\/wp-content\/uploads\/2023\/10\/akeneo-demo.webkul.com_7203_webkul-store-2-300x236.png 300w, https:\/\/cdnblog.webkul.com\/blog\/wp-content\/uploads\/2023\/10\/akeneo-demo.webkul.com_7203_webkul-store-2-250x196.png 250w, https:\/\/cdnblog.webkul.com\/blog\/wp-content\/uploads\/2023\/10\/akeneo-demo.webkul.com_7203_webkul-store-2-768x603.png 768w\" sizes=\"(max-width: 1120px) 100vw, 1120px\" loading=\"lazy\" \/><\/figure>\n\n\n\n<p>Run the job whenever you want to Export data by navigating to Export profiles &gt;&gt; Akeneo Oracle Job and Clicking on Export Now.<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img decoding=\"async\" width=\"1120\" height=\"880\" src=\"https:\/\/cdnblog.webkul.com\/blog\/wp-content\/uploads\/2023\/10\/akeneo-demo.webkul.com_7203_webkul-store-5.png\" alt=\"Oracle Akeneo Connector\" class=\"wp-image-407388\" srcset=\"https:\/\/cdnblog.webkul.com\/blog\/wp-content\/uploads\/2023\/10\/akeneo-demo.webkul.com_7203_webkul-store-5.png 1120w, https:\/\/cdnblog.webkul.com\/blog\/wp-content\/uploads\/2023\/10\/akeneo-demo.webkul.com_7203_webkul-store-5-300x236.png 300w, https:\/\/cdnblog.webkul.com\/blog\/wp-content\/uploads\/2023\/10\/akeneo-demo.webkul.com_7203_webkul-store-5-250x196.png 250w, https:\/\/cdnblog.webkul.com\/blog\/wp-content\/uploads\/2023\/10\/akeneo-demo.webkul.com_7203_webkul-store-5-768x603.png 768w\" sizes=\"(max-width: 1120px) 100vw, 1120px\" loading=\"lazy\" \/><\/figure>\n\n\n\n<p>Once the exporting starts you can check the progress in the progress bar.<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img decoding=\"async\" width=\"1120\" height=\"880\" src=\"https:\/\/cdnblog.webkul.com\/blog\/wp-content\/uploads\/2023\/10\/akeneo-demo.webkul.com_7937_webkul-store-1.png\" alt=\"Oracle Akeneo Connector\" class=\"wp-image-407619\" srcset=\"https:\/\/cdnblog.webkul.com\/blog\/wp-content\/uploads\/2023\/10\/akeneo-demo.webkul.com_7937_webkul-store-1.png 1120w, https:\/\/cdnblog.webkul.com\/blog\/wp-content\/uploads\/2023\/10\/akeneo-demo.webkul.com_7937_webkul-store-1-300x236.png 300w, https:\/\/cdnblog.webkul.com\/blog\/wp-content\/uploads\/2023\/10\/akeneo-demo.webkul.com_7937_webkul-store-1-250x196.png 250w, https:\/\/cdnblog.webkul.com\/blog\/wp-content\/uploads\/2023\/10\/akeneo-demo.webkul.com_7937_webkul-store-1-768x603.png 768w\" sizes=\"(max-width: 1120px) 100vw, 1120px\" loading=\"lazy\" \/><\/figure>\n\n\n\n<p>After completion, it will display the success message. <\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img decoding=\"async\" width=\"1120\" height=\"880\" src=\"https:\/\/cdnblog.webkul.com\/blog\/wp-content\/uploads\/2023\/10\/akeneo-demo.webkul.com_7937_webkul-store-2.png\" alt=\"Oracle Akeneo Connector\" class=\"wp-image-407621\" srcset=\"https:\/\/cdnblog.webkul.com\/blog\/wp-content\/uploads\/2023\/10\/akeneo-demo.webkul.com_7937_webkul-store-2.png 1120w, https:\/\/cdnblog.webkul.com\/blog\/wp-content\/uploads\/2023\/10\/akeneo-demo.webkul.com_7937_webkul-store-2-300x236.png 300w, https:\/\/cdnblog.webkul.com\/blog\/wp-content\/uploads\/2023\/10\/akeneo-demo.webkul.com_7937_webkul-store-2-250x196.png 250w, https:\/\/cdnblog.webkul.com\/blog\/wp-content\/uploads\/2023\/10\/akeneo-demo.webkul.com_7937_webkul-store-2-768x603.png 768w\" sizes=\"(max-width: 1120px) 100vw, 1120px\" loading=\"lazy\" \/><\/figure>\n\n\n\n<p>You can check the exported data on the Oracle database.<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img decoding=\"async\" width=\"1120\" height=\"880\" src=\"https:\/\/cdnblog.webkul.com\/blog\/wp-content\/uploads\/2023\/10\/apex.oracle.com_pls_apex_r_apex_sql-workshop_ob_session13876720847344webkul-store.png\" alt=\"Oracle Akeneo Connector\" class=\"wp-image-407625\" srcset=\"https:\/\/cdnblog.webkul.com\/blog\/wp-content\/uploads\/2023\/10\/apex.oracle.com_pls_apex_r_apex_sql-workshop_ob_session13876720847344webkul-store.png 1120w, https:\/\/cdnblog.webkul.com\/blog\/wp-content\/uploads\/2023\/10\/apex.oracle.com_pls_apex_r_apex_sql-workshop_ob_session13876720847344webkul-store-300x236.png 300w, https:\/\/cdnblog.webkul.com\/blog\/wp-content\/uploads\/2023\/10\/apex.oracle.com_pls_apex_r_apex_sql-workshop_ob_session13876720847344webkul-store-250x196.png 250w, https:\/\/cdnblog.webkul.com\/blog\/wp-content\/uploads\/2023\/10\/apex.oracle.com_pls_apex_r_apex_sql-workshop_ob_session13876720847344webkul-store-768x603.png 768w\" sizes=\"(max-width: 1120px) 100vw, 1120px\" loading=\"lazy\" \/><\/figure>\n\n\n\n<p>Note: If the data is already stored im the Oracle database then the export job will throw the error while exporting if the Akeneo version is different. If the exported data is from the same version it will be exported and stored on Oracle.<\/p>\n\n\n\n<div class=\"wk-index-wrap\"><div class=\"block-wrap\">\n<h2 class=\"wp-block-heading index-title\">Remove Data from Oracle<\/h2>\n<\/div><\/div>\n\n\n\n<p>The user has to remove previously stored job data from the Oracle database. <\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img decoding=\"async\" width=\"1200\" height=\"571\" src=\"https:\/\/cdnblog.webkul.com\/blog\/wp-content\/uploads\/2023\/10\/Screenshot-from-2023-10-26-10-50-44-1200x571.png\" alt=\"Oracle Akeneo Connector\" class=\"wp-image-407633\" srcset=\"https:\/\/cdnblog.webkul.com\/blog\/wp-content\/uploads\/2023\/10\/Screenshot-from-2023-10-26-10-50-44-1200x571.png 1200w, https:\/\/cdnblog.webkul.com\/blog\/wp-content\/uploads\/2023\/10\/Screenshot-from-2023-10-26-10-50-44-300x143.png 300w, https:\/\/cdnblog.webkul.com\/blog\/wp-content\/uploads\/2023\/10\/Screenshot-from-2023-10-26-10-50-44-250x119.png 250w, https:\/\/cdnblog.webkul.com\/blog\/wp-content\/uploads\/2023\/10\/Screenshot-from-2023-10-26-10-50-44-768x365.png 768w, https:\/\/cdnblog.webkul.com\/blog\/wp-content\/uploads\/2023\/10\/Screenshot-from-2023-10-26-10-50-44.png 1291w\" sizes=\"(max-width: 1200px) 100vw, 1200px\" loading=\"lazy\" \/><\/figure>\n\n\n\n<p>The user needs to click on the Truncate table option and a popup will open to remove the table.<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img decoding=\"async\" width=\"1120\" height=\"880\" src=\"https:\/\/cdnblog.webkul.com\/blog\/wp-content\/uploads\/2023\/10\/apex.oracle.com_pls_apex_r_apex_sql-workshop_ob_session113006709195733webkul-store-1.png\" alt=\"Oracle Akeneo Connector\" class=\"wp-image-407635\" srcset=\"https:\/\/cdnblog.webkul.com\/blog\/wp-content\/uploads\/2023\/10\/apex.oracle.com_pls_apex_r_apex_sql-workshop_ob_session113006709195733webkul-store-1.png 1120w, https:\/\/cdnblog.webkul.com\/blog\/wp-content\/uploads\/2023\/10\/apex.oracle.com_pls_apex_r_apex_sql-workshop_ob_session113006709195733webkul-store-1-300x236.png 300w, https:\/\/cdnblog.webkul.com\/blog\/wp-content\/uploads\/2023\/10\/apex.oracle.com_pls_apex_r_apex_sql-workshop_ob_session113006709195733webkul-store-1-250x196.png 250w, https:\/\/cdnblog.webkul.com\/blog\/wp-content\/uploads\/2023\/10\/apex.oracle.com_pls_apex_r_apex_sql-workshop_ob_session113006709195733webkul-store-1-768x603.png 768w\" sizes=\"(max-width: 1120px) 100vw, 1120px\" loading=\"lazy\" \/><\/figure>\n\n\n\n<p>That\u2019s all about the Oracle Akeneo Connector, for any queries or doubts reach out to us at&nbsp;<a href=\"mailto:support@webkul.com\" target=\"_blank\" rel=\"noreferrer noopener\">support@webkul.com<\/a>. You can also raise a ticket at our&nbsp;<strong><a href=\"https:\/\/webkul.uvdesk.com\/en\/\" target=\"_blank\" rel=\"noreferrer noopener\">HelpDesk System.<\/a><\/strong><\/p>\n","protected":false},"excerpt":{"rendered":"<p>The Oracle Akeneo Connector facilitates the user to export various data on the Oracle database with the help of multiple export jobs. Users can create various jobs and export them on the Oracle database. They can also remove stored data from the Oracle database. Note &#8211; If you want to back up your Akeneo database <a href=\"https:\/\/webkul.com\/blog\/oracle-akeneo-connector-user-guide\/\">[&#8230;]<\/a><\/p>\n","protected":false},"author":396,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[5709,1],"tags":[],"class_list":["post-407074","post","type-post","status-publish","format-standard","hentry","category-akeneo","category-uncategorized"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v24.5 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>Oracle Akeneo Connector - User Guide<\/title>\n<meta name=\"description\" content=\"The Oracle Akeneo connector helps you to import the PIM data to the Oracle database for data exchange and update the database.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/webkul.com\/blog\/oracle-akeneo-connector-user-guide\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Oracle Akeneo Connector - User Guide\" \/>\n<meta property=\"og:description\" content=\"The Oracle Akeneo connector helps you to import the PIM data to the Oracle database for data exchange and update the database.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/webkul.com\/blog\/oracle-akeneo-connector-user-guide\/\" \/>\n<meta property=\"og:site_name\" content=\"Webkul Blog\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/webkul\/\" \/>\n<meta property=\"article:published_time\" content=\"2023-11-06T05:38:45+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2023-11-21T08:36:34+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/webkul.com\/blog\/wp-content\/uploads\/2023\/11\/apex.oracle.com_pls_apex_r_apex_rest_role-definition_clearRP180session15277057399753webkul-store.png\" \/>\n<meta name=\"author\" content=\"Shailja Gupta\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@webkul\" \/>\n<meta name=\"twitter:site\" content=\"@webkul\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Shailja Gupta\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"9 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/webkul.com\/blog\/oracle-akeneo-connector-user-guide\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/webkul.com\/blog\/oracle-akeneo-connector-user-guide\/\"},\"author\":{\"name\":\"Shailja Gupta\",\"@id\":\"https:\/\/webkul.com\/blog\/#\/schema\/person\/a8e167c820b3f455f751fe7d334741bc\"},\"headline\":\"Oracle Akeneo Connector &#8211; User Guide\",\"datePublished\":\"2023-11-06T05:38:45+00:00\",\"dateModified\":\"2023-11-21T08:36:34+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/webkul.com\/blog\/oracle-akeneo-connector-user-guide\/\"},\"wordCount\":1118,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/webkul.com\/blog\/#organization\"},\"image\":{\"@id\":\"https:\/\/webkul.com\/blog\/oracle-akeneo-connector-user-guide\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/webkul.com\/blog\/wp-content\/uploads\/2023\/11\/apex.oracle.com_pls_apex_r_apex_rest_role-definition_clearRP180session15277057399753webkul-store.png\",\"articleSection\":[\"Akeneo\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/webkul.com\/blog\/oracle-akeneo-connector-user-guide\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/webkul.com\/blog\/oracle-akeneo-connector-user-guide\/\",\"url\":\"https:\/\/webkul.com\/blog\/oracle-akeneo-connector-user-guide\/\",\"name\":\"Oracle Akeneo Connector - User Guide\",\"isPartOf\":{\"@id\":\"https:\/\/webkul.com\/blog\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/webkul.com\/blog\/oracle-akeneo-connector-user-guide\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/webkul.com\/blog\/oracle-akeneo-connector-user-guide\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/webkul.com\/blog\/wp-content\/uploads\/2023\/11\/apex.oracle.com_pls_apex_r_apex_rest_role-definition_clearRP180session15277057399753webkul-store.png\",\"datePublished\":\"2023-11-06T05:38:45+00:00\",\"dateModified\":\"2023-11-21T08:36:34+00:00\",\"description\":\"The Oracle Akeneo connector helps you to import the PIM data to the Oracle database for data exchange and update the database.\",\"breadcrumb\":{\"@id\":\"https:\/\/webkul.com\/blog\/oracle-akeneo-connector-user-guide\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/webkul.com\/blog\/oracle-akeneo-connector-user-guide\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/webkul.com\/blog\/oracle-akeneo-connector-user-guide\/#primaryimage\",\"url\":\"https:\/\/cdnblog.webkul.com\/blog\/wp-content\/uploads\/2023\/11\/apex.oracle.com_pls_apex_r_apex_rest_role-definition_clearRP180session15277057399753webkul-store.png\",\"contentUrl\":\"https:\/\/cdnblog.webkul.com\/blog\/wp-content\/uploads\/2023\/11\/apex.oracle.com_pls_apex_r_apex_rest_role-definition_clearRP180session15277057399753webkul-store.png\",\"width\":1120,\"height\":880,\"caption\":\"apex.oracle.com_pls_apex_r_apex_rest_role-definition_clearRP180session15277057399753webkul-store\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/webkul.com\/blog\/oracle-akeneo-connector-user-guide\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/webkul.com\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Oracle Akeneo Connector &#8211; User Guide\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/webkul.com\/blog\/#website\",\"url\":\"https:\/\/webkul.com\/blog\/\",\"name\":\"Webkul Blog\",\"description\":\"\",\"publisher\":{\"@id\":\"https:\/\/webkul.com\/blog\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/webkul.com\/blog\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/webkul.com\/blog\/#organization\",\"name\":\"WebKul Software Private Limited\",\"url\":\"https:\/\/webkul.com\/blog\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/webkul.com\/blog\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/cdnblog.webkul.com\/blog\/wp-content\/uploads\/2021\/08\/webkul-logo-accent-sq.png\",\"contentUrl\":\"https:\/\/cdnblog.webkul.com\/blog\/wp-content\/uploads\/2021\/08\/webkul-logo-accent-sq.png\",\"width\":380,\"height\":380,\"caption\":\"WebKul Software Private Limited\"},\"image\":{\"@id\":\"https:\/\/webkul.com\/blog\/#\/schema\/logo\/image\/\"},\"sameAs\":[\"https:\/\/www.facebook.com\/webkul\/\",\"https:\/\/x.com\/webkul\",\"https:\/\/www.instagram.com\/webkul\/\",\"https:\/\/www.linkedin.com\/company\/webkul\",\"https:\/\/www.youtube.com\/user\/webkul\/\"]},{\"@type\":\"Person\",\"@id\":\"https:\/\/webkul.com\/blog\/#\/schema\/person\/a8e167c820b3f455f751fe7d334741bc\",\"name\":\"Shailja Gupta\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/webkul.com\/blog\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/0bcbe5b07d11b71c7571417f83fc28718f48fa375d24d88ab49e6c9bda729098?s=96&d=https%3A%2F%2Fcdnblog.webkul.com%2Fblog%2Fwp-content%2Fuploads%2F2019%2F10%2Feva.png&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/0bcbe5b07d11b71c7571417f83fc28718f48fa375d24d88ab49e6c9bda729098?s=96&d=https%3A%2F%2Fcdnblog.webkul.com%2Fblog%2Fwp-content%2Fuploads%2F2019%2F10%2Feva.png&r=g\",\"caption\":\"Shailja Gupta\"},\"url\":\"https:\/\/webkul.com\/blog\/author\/shailjagupta-bd465\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Oracle Akeneo Connector - User Guide","description":"The Oracle Akeneo connector helps you to import the PIM data to the Oracle database for data exchange and update the database.","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/webkul.com\/blog\/oracle-akeneo-connector-user-guide\/","og_locale":"en_US","og_type":"article","og_title":"Oracle Akeneo Connector - User Guide","og_description":"The Oracle Akeneo connector helps you to import the PIM data to the Oracle database for data exchange and update the database.","og_url":"https:\/\/webkul.com\/blog\/oracle-akeneo-connector-user-guide\/","og_site_name":"Webkul Blog","article_publisher":"https:\/\/www.facebook.com\/webkul\/","article_published_time":"2023-11-06T05:38:45+00:00","article_modified_time":"2023-11-21T08:36:34+00:00","og_image":[{"url":"https:\/\/webkul.com\/blog\/wp-content\/uploads\/2023\/11\/apex.oracle.com_pls_apex_r_apex_rest_role-definition_clearRP180session15277057399753webkul-store.png","type":"","width":"","height":""}],"author":"Shailja Gupta","twitter_card":"summary_large_image","twitter_creator":"@webkul","twitter_site":"@webkul","twitter_misc":{"Written by":"Shailja Gupta","Est. reading time":"9 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/webkul.com\/blog\/oracle-akeneo-connector-user-guide\/#article","isPartOf":{"@id":"https:\/\/webkul.com\/blog\/oracle-akeneo-connector-user-guide\/"},"author":{"name":"Shailja Gupta","@id":"https:\/\/webkul.com\/blog\/#\/schema\/person\/a8e167c820b3f455f751fe7d334741bc"},"headline":"Oracle Akeneo Connector &#8211; User Guide","datePublished":"2023-11-06T05:38:45+00:00","dateModified":"2023-11-21T08:36:34+00:00","mainEntityOfPage":{"@id":"https:\/\/webkul.com\/blog\/oracle-akeneo-connector-user-guide\/"},"wordCount":1118,"commentCount":0,"publisher":{"@id":"https:\/\/webkul.com\/blog\/#organization"},"image":{"@id":"https:\/\/webkul.com\/blog\/oracle-akeneo-connector-user-guide\/#primaryimage"},"thumbnailUrl":"https:\/\/webkul.com\/blog\/wp-content\/uploads\/2023\/11\/apex.oracle.com_pls_apex_r_apex_rest_role-definition_clearRP180session15277057399753webkul-store.png","articleSection":["Akeneo"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/webkul.com\/blog\/oracle-akeneo-connector-user-guide\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/webkul.com\/blog\/oracle-akeneo-connector-user-guide\/","url":"https:\/\/webkul.com\/blog\/oracle-akeneo-connector-user-guide\/","name":"Oracle Akeneo Connector - User Guide","isPartOf":{"@id":"https:\/\/webkul.com\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/webkul.com\/blog\/oracle-akeneo-connector-user-guide\/#primaryimage"},"image":{"@id":"https:\/\/webkul.com\/blog\/oracle-akeneo-connector-user-guide\/#primaryimage"},"thumbnailUrl":"https:\/\/webkul.com\/blog\/wp-content\/uploads\/2023\/11\/apex.oracle.com_pls_apex_r_apex_rest_role-definition_clearRP180session15277057399753webkul-store.png","datePublished":"2023-11-06T05:38:45+00:00","dateModified":"2023-11-21T08:36:34+00:00","description":"The Oracle Akeneo connector helps you to import the PIM data to the Oracle database for data exchange and update the database.","breadcrumb":{"@id":"https:\/\/webkul.com\/blog\/oracle-akeneo-connector-user-guide\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/webkul.com\/blog\/oracle-akeneo-connector-user-guide\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/webkul.com\/blog\/oracle-akeneo-connector-user-guide\/#primaryimage","url":"https:\/\/cdnblog.webkul.com\/blog\/wp-content\/uploads\/2023\/11\/apex.oracle.com_pls_apex_r_apex_rest_role-definition_clearRP180session15277057399753webkul-store.png","contentUrl":"https:\/\/cdnblog.webkul.com\/blog\/wp-content\/uploads\/2023\/11\/apex.oracle.com_pls_apex_r_apex_rest_role-definition_clearRP180session15277057399753webkul-store.png","width":1120,"height":880,"caption":"apex.oracle.com_pls_apex_r_apex_rest_role-definition_clearRP180session15277057399753webkul-store"},{"@type":"BreadcrumbList","@id":"https:\/\/webkul.com\/blog\/oracle-akeneo-connector-user-guide\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/webkul.com\/blog\/"},{"@type":"ListItem","position":2,"name":"Oracle Akeneo Connector &#8211; User Guide"}]},{"@type":"WebSite","@id":"https:\/\/webkul.com\/blog\/#website","url":"https:\/\/webkul.com\/blog\/","name":"Webkul Blog","description":"","publisher":{"@id":"https:\/\/webkul.com\/blog\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/webkul.com\/blog\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/webkul.com\/blog\/#organization","name":"WebKul Software Private Limited","url":"https:\/\/webkul.com\/blog\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/webkul.com\/blog\/#\/schema\/logo\/image\/","url":"https:\/\/cdnblog.webkul.com\/blog\/wp-content\/uploads\/2021\/08\/webkul-logo-accent-sq.png","contentUrl":"https:\/\/cdnblog.webkul.com\/blog\/wp-content\/uploads\/2021\/08\/webkul-logo-accent-sq.png","width":380,"height":380,"caption":"WebKul Software Private Limited"},"image":{"@id":"https:\/\/webkul.com\/blog\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/www.facebook.com\/webkul\/","https:\/\/x.com\/webkul","https:\/\/www.instagram.com\/webkul\/","https:\/\/www.linkedin.com\/company\/webkul","https:\/\/www.youtube.com\/user\/webkul\/"]},{"@type":"Person","@id":"https:\/\/webkul.com\/blog\/#\/schema\/person\/a8e167c820b3f455f751fe7d334741bc","name":"Shailja Gupta","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/webkul.com\/blog\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/0bcbe5b07d11b71c7571417f83fc28718f48fa375d24d88ab49e6c9bda729098?s=96&d=https%3A%2F%2Fcdnblog.webkul.com%2Fblog%2Fwp-content%2Fuploads%2F2019%2F10%2Feva.png&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/0bcbe5b07d11b71c7571417f83fc28718f48fa375d24d88ab49e6c9bda729098?s=96&d=https%3A%2F%2Fcdnblog.webkul.com%2Fblog%2Fwp-content%2Fuploads%2F2019%2F10%2Feva.png&r=g","caption":"Shailja Gupta"},"url":"https:\/\/webkul.com\/blog\/author\/shailjagupta-bd465\/"}]}},"amp_enabled":true,"_links":{"self":[{"href":"https:\/\/webkul.com\/blog\/wp-json\/wp\/v2\/posts\/407074","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/webkul.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/webkul.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/webkul.com\/blog\/wp-json\/wp\/v2\/users\/396"}],"replies":[{"embeddable":true,"href":"https:\/\/webkul.com\/blog\/wp-json\/wp\/v2\/comments?post=407074"}],"version-history":[{"count":33,"href":"https:\/\/webkul.com\/blog\/wp-json\/wp\/v2\/posts\/407074\/revisions"}],"predecessor-version":[{"id":412268,"href":"https:\/\/webkul.com\/blog\/wp-json\/wp\/v2\/posts\/407074\/revisions\/412268"}],"wp:attachment":[{"href":"https:\/\/webkul.com\/blog\/wp-json\/wp\/v2\/media?parent=407074"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/webkul.com\/blog\/wp-json\/wp\/v2\/categories?post=407074"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/webkul.com\/blog\/wp-json\/wp\/v2\/tags?post=407074"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}