{"id":6473,"date":"2022-06-16T12:45:37","date_gmt":"2022-06-16T11:45:37","guid":{"rendered":"https:\/\/bestdatasolutions.es\/?p=6473"},"modified":"2022-06-20T11:04:56","modified_gmt":"2022-06-20T10:04:56","slug":"oracle-data-integrator-odi","status":"publish","type":"post","link":"https:\/\/bestdatasolutions.es\/en\/blog\/oracle-data-integrator-odi\/","title":{"rendered":"Oracle Data Integrator (ODI)"},"content":{"rendered":"\t\t<div data-elementor-type=\"wp-post\" data-elementor-id=\"6473\" class=\"elementor elementor-6473 elementor-6472\" data-elementor-post-type=\"post\">\n\t\t\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-d32b5ac elementor-section-full_width elementor-section-height-default elementor-section-height-default\" data-id=\"d32b5ac\" data-element_type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-no\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-c1dc6d3\" data-id=\"c1dc6d3\" data-element_type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-911012a elementor-widget elementor-widget-theme-post-featured-image elementor-widget-image\" data-id=\"911012a\" data-element_type=\"widget\" data-widget_type=\"theme-post-featured-image.default\">\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<img fetchpriority=\"high\" decoding=\"async\" width=\"1920\" height=\"500\" src=\"https:\/\/bestdatasolutions.es\/wp-content\/uploads\/oracle-data-integrator.jpg\" class=\"attachment-full size-full wp-image-6477\" alt=\"oracle-data-integrator\" srcset=\"https:\/\/bestdatasolutions.es\/wp-content\/uploads\/oracle-data-integrator.jpg 1920w, https:\/\/bestdatasolutions.es\/wp-content\/uploads\/oracle-data-integrator-300x78.jpg 300w, https:\/\/bestdatasolutions.es\/wp-content\/uploads\/oracle-data-integrator-1024x267.jpg 1024w, https:\/\/bestdatasolutions.es\/wp-content\/uploads\/oracle-data-integrator-768x200.jpg 768w, https:\/\/bestdatasolutions.es\/wp-content\/uploads\/oracle-data-integrator-1536x400.jpg 1536w\" sizes=\"(max-width: 1920px) 100vw, 1920px\" title=\"\">\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-5d1c2c13 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"5d1c2c13\" data-element_type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-50 elementor-top-column elementor-element elementor-element-5aae2e0d\" data-id=\"5aae2e0d\" data-element_type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-1a3ffa42 elementor-author-box--layout-image-left elementor-author-box--align-left elementor-author-box--image-valign-middle elementor-author-box--avatar-yes elementor-author-box--name-yes elementor-author-box--biography-yes elementor-widget elementor-widget-author-box\" data-id=\"1a3ffa42\" data-element_type=\"widget\" data-widget_type=\"author-box.default\">\n\t\t\t\t\t\t\t<div class=\"elementor-author-box\">\n\t\t\t\t\t\t\t<a href=\"https:\/\/www.linkedin.com\/in\/borja-diaz-611933a3\/\" target=\"_blank\" class=\"elementor-author-box__avatar\" rel=\"noopener\">\n\t\t\t\t\t<img decoding=\"async\" src=\"https:\/\/bestdatasolutions.es\/wp-content\/uploads\/avatar_user_13_1655379752-300x300.jpg\" alt=\"Picture of Borja Diaz\" loading=\"lazy\" title=\"\">\n\t\t\t\t<\/a>\n\t\t\t\n\t\t\t<div class=\"elementor-author-box__text\">\n\t\t\t\t\t\t\t\t\t<a href=\"https:\/\/www.linkedin.com\/in\/borja-diaz-611933a3\/\" target=\"_blank\" rel=\"noopener\">\n\t\t\t\t\t\t<h4 class=\"elementor-author-box__name\">\n\t\t\t\t\t\t\tBorja Diaz\t\t\t\t\t\t<\/h4>\n\t\t\t\t\t<\/a>\n\t\t\t\t\n\t\t\t\t\t\t\t\t\t<div class=\"elementor-author-box__bio\">\n\t\t\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\n\t\t\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-41a959e0 elementor-widget elementor-widget-heading\" data-id=\"41a959e0\" data-element_type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t\t<h3 class=\"elementor-heading-title elementor-size-large\">Other Articles:<\/h3>\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t<div class=\"elementor-column elementor-col-50 elementor-top-column elementor-element elementor-element-6c75b22c\" data-id=\"6c75b22c\" data-element_type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-5795bde9 elementor-widget elementor-widget-theme-post-title elementor-page-title elementor-widget-heading\" data-id=\"5795bde9\" data-element_type=\"widget\" data-widget_type=\"theme-post-title.default\">\n\t\t\t\t\t<h1 class=\"elementor-heading-title elementor-size-xl\">Oracle Data Integrator (ODI)<\/h1>\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-561b31d1 elementor-widget elementor-widget-post-info\" data-id=\"561b31d1\" data-element_type=\"widget\" data-widget_type=\"post-info.default\">\n\t\t\t\t\t\t\t<ul class=\"elementor-inline-items elementor-icon-list-items elementor-post-info\">\n\t\t\t\t\t\t\t\t<li class=\"elementor-icon-list-item elementor-repeater-item-869d2fb elementor-inline-item\" itemprop=\"datePublished\">\n\t\t\t\t\t\t<a href=\"https:\/\/bestdatasolutions.es\/en\/2022\/06\/16\/\">\n\t\t\t\t\t\t\t\t\t\t\t<span class=\"elementor-icon-list-icon\">\n\t\t\t\t\t\t\t\t<svg aria-hidden=\"true\" class=\"e-font-icon-svg e-fas-calendar\" viewBox=\"0 0 448 512\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\"><path d=\"M12 192h424c6.6 0 12 5.4 12 12v260c0 26.5-21.5 48-48 48H48c-26.5 0-48-21.5-48-48V204c0-6.6 5.4-12 12-12zm436-44v-36c0-26.5-21.5-48-48-48h-48V12c0-6.6-5.4-12-12-12h-40c-6.6 0-12 5.4-12 12v52H160V12c0-6.6-5.4-12-12-12h-40c-6.6 0-12 5.4-12 12v52H48C21.5 64 0 85.5 0 112v36c0 6.6 5.4 12 12 12h424c6.6 0 12-5.4 12-12z\"><\/path><\/svg>\t\t\t\t\t\t\t<\/span>\n\t\t\t\t\t\t\t\t\t<span class=\"elementor-icon-list-text elementor-post-info__item elementor-post-info__item--type-date\">\n\t\t\t\t\t\t\t\t\t\t<time>16\/06\/2022<\/time>\t\t\t\t\t<\/span>\n\t\t\t\t\t\t\t\t\t<\/a>\n\t\t\t\t<\/li>\n\t\t\t\t<\/ul>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-7476169 elementor-share-buttons--view-icon-text elementor-share-buttons--skin-gradient elementor-share-buttons--shape-square elementor-grid-0 elementor-share-buttons--color-official elementor-widget elementor-widget-share-buttons\" data-id=\"7476169\" data-element_type=\"widget\" data-widget_type=\"share-buttons.default\">\n\t\t\t\t\t\t\t<div class=\"elementor-grid\" role=\"list\">\n\t\t\t\t\t\t\t\t<div class=\"elementor-grid-item\" role=\"listitem\">\n\t\t\t\t\t\t<div class=\"elementor-share-btn elementor-share-btn_linkedin\" role=\"button\" tabindex=\"0\" aria-label=\"Share on linkedin\">\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<span class=\"elementor-share-btn__icon\">\n\t\t\t\t\t\t\t\t<svg aria-hidden=\"true\" class=\"e-font-icon-svg e-fab-linkedin\" viewBox=\"0 0 448 512\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\"><path d=\"M416 32H31.9C14.3 32 0 46.5 0 64.3v383.4C0 465.5 14.3 480 31.9 480H416c17.6 0 32-14.5 32-32.3V64.3c0-17.8-14.4-32.3-32-32.3zM135.4 416H69V202.2h66.5V416zm-33.2-243c-21.3 0-38.5-17.3-38.5-38.5S80.9 96 102.2 96c21.2 0 38.5 17.3 38.5 38.5 0 21.3-17.2 38.5-38.5 38.5zm282.1 243h-66.4V312c0-24.8-.5-56.7-34.5-56.7-34.6 0-39.9 27-39.9 54.9V416h-66.4V202.2h63.7v29.2h.9c8.9-16.8 30.6-34.5 62.9-34.5 67.2 0 79.7 44.3 79.7 101.9V416z\"><\/path><\/svg>\t\t\t\t\t\t\t<\/span>\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<div class=\"elementor-share-btn__text\">\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<span class=\"elementor-share-btn__title\">\n\t\t\t\t\t\t\t\t\t\tLinkedIn\t\t\t\t\t\t\t\t\t<\/span>\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t\t\t\t\t\t\t\t<div class=\"elementor-grid-item\" role=\"listitem\">\n\t\t\t\t\t\t<div class=\"elementor-share-btn elementor-share-btn_facebook\" role=\"button\" tabindex=\"0\" aria-label=\"Share on facebook\">\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<span class=\"elementor-share-btn__icon\">\n\t\t\t\t\t\t\t\t<svg aria-hidden=\"true\" class=\"e-font-icon-svg e-fab-facebook\" viewBox=\"0 0 512 512\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\"><path d=\"M504 256C504 119 393 8 256 8S8 119 8 256c0 123.78 90.69 226.38 209.25 245V327.69h-63V256h63v-54.64c0-62.15 37-96.48 93.67-96.48 27.14 0 55.52 4.84 55.52 4.84v61h-31.28c-30.8 0-40.41 19.12-40.41 38.73V256h68.78l-11 71.69h-57.78V501C413.31 482.38 504 379.78 504 256z\"><\/path><\/svg>\t\t\t\t\t\t\t<\/span>\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<div class=\"elementor-share-btn__text\">\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<span class=\"elementor-share-btn__title\">\n\t\t\t\t\t\t\t\t\t\tFacebook\t\t\t\t\t\t\t\t\t<\/span>\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t\t\t\t\t\t\t\t<div class=\"elementor-grid-item\" role=\"listitem\">\n\t\t\t\t\t\t<div class=\"elementor-share-btn elementor-share-btn_twitter\" role=\"button\" tabindex=\"0\" aria-label=\"Share on twitter\">\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<span class=\"elementor-share-btn__icon\">\n\t\t\t\t\t\t\t\t<svg aria-hidden=\"true\" class=\"e-font-icon-svg e-fab-twitter\" viewBox=\"0 0 512 512\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\"><path d=\"M459.37 151.716c.325 4.548.325 9.097.325 13.645 0 138.72-105.583 298.558-298.558 298.558-59.452 0-114.68-17.219-161.137-47.106 8.447.974 16.568 1.299 25.34 1.299 49.055 0 94.213-16.568 130.274-44.832-46.132-.975-84.792-31.188-98.112-72.772 6.498.974 12.995 1.624 19.818 1.624 9.421 0 18.843-1.3 27.614-3.573-48.081-9.747-84.143-51.98-84.143-102.985v-1.299c13.969 7.797 30.214 12.67 47.431 13.319-28.264-18.843-46.781-51.005-46.781-87.391 0-19.492 5.197-37.36 14.294-52.954 51.655 63.675 129.3 105.258 216.365 109.807-1.624-7.797-2.599-15.918-2.599-24.04 0-57.828 46.782-104.934 104.934-104.934 30.213 0 57.502 12.67 76.67 33.137 23.715-4.548 46.456-13.32 66.599-25.34-7.798 24.366-24.366 44.833-46.132 57.827 21.117-2.273 41.584-8.122 60.426-16.243-14.292 20.791-32.161 39.308-52.628 54.253z\"><\/path><\/svg>\t\t\t\t\t\t\t<\/span>\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<div class=\"elementor-share-btn__text\">\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<span class=\"elementor-share-btn__title\">\n\t\t\t\t\t\t\t\t\t\tTwitter\t\t\t\t\t\t\t\t\t<\/span>\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t\t\t\t\t\t\t\t<div class=\"elementor-grid-item\" role=\"listitem\">\n\t\t\t\t\t\t<div class=\"elementor-share-btn elementor-share-btn_whatsapp\" role=\"button\" tabindex=\"0\" aria-label=\"Share on whatsapp\">\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<span class=\"elementor-share-btn__icon\">\n\t\t\t\t\t\t\t\t<svg aria-hidden=\"true\" class=\"e-font-icon-svg e-fab-whatsapp\" viewBox=\"0 0 448 512\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\"><path d=\"M380.9 97.1C339 55.1 283.2 32 223.9 32c-122.4 0-222 99.6-222 222 0 39.1 10.2 77.3 29.6 111L0 480l117.7-30.9c32.4 17.7 68.9 27 106.1 27h.1c122.3 0 224.1-99.6 224.1-222 0-59.3-25.2-115-67.1-157zm-157 341.6c-33.2 0-65.7-8.9-94-25.7l-6.7-4-69.8 18.3L72 359.2l-4.4-7c-18.5-29.4-28.2-63.3-28.2-98.2 0-101.7 82.8-184.5 184.6-184.5 49.3 0 95.6 19.2 130.4 54.1 34.8 34.9 56.2 81.2 56.1 130.5 0 101.8-84.9 184.6-186.6 184.6zm101.2-138.2c-5.5-2.8-32.8-16.2-37.9-18-5.1-1.9-8.8-2.8-12.5 2.8-3.7 5.6-14.3 18-17.6 21.8-3.2 3.7-6.5 4.2-12 1.4-32.6-16.3-54-29.1-75.5-66-5.7-9.8 5.7-9.1 16.3-30.3 1.8-3.7.9-6.9-.5-9.7-1.4-2.8-12.5-30.1-17.1-41.2-4.5-10.8-9.1-9.3-12.5-9.5-3.2-.2-6.9-.2-10.6-.2-3.7 0-9.7 1.4-14.8 6.9-5.1 5.6-19.4 19-19.4 46.3 0 27.3 19.9 53.7 22.6 57.4 2.8 3.7 39.1 59.7 94.8 83.8 35.2 15.2 49 16.5 66.6 13.9 10.7-1.6 32.8-13.4 37.4-26.4 4.6-13 4.6-24.1 3.2-26.4-1.3-2.5-5-3.9-10.5-6.6z\"><\/path><\/svg>\t\t\t\t\t\t\t<\/span>\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<div class=\"elementor-share-btn__text\">\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<span class=\"elementor-share-btn__title\">\n\t\t\t\t\t\t\t\t\t\tWhatsApp\t\t\t\t\t\t\t\t\t<\/span>\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-56263e9 elementor-widget elementor-widget-text-editor\" data-id=\"56263e9\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t\t\t\t\t\t<p>Oracle Data Integator (ODI) is an integration platform, it goes beyond a traditional ETL tool, in which we extract data from different sources, transform it in the process and then load it to the target. Oracle Data Integrator has an ELT functionality, as we extract data from different databases, load them into ODI, and then perform all the transformations.<\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-57be7a0 elementor-widget elementor-widget-text-editor\" data-id=\"57be7a0\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t\t\t\t\t\t<p>In this article, we are going to perform an ODI binding with Oracle developer (localhost).<\/p><p>First, we will need a session in Oracle developer with some information we will import.<\/p><p>The most important thing is to install ODI, I attach an explanatory video:<\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-dcdf84e elementor-widget elementor-widget-text-editor\" data-id=\"dcdf84e\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t\t\t\t\t\t<p><a href=\"https:\/\/www.youtube.com\/watch?v=8qlSKE7j5yQ\" target=\"_blank\" rel=\"noopener\">https:\/\/www.youtube.com\/watch?v=8qlSKE7j5yQ<\/a><\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-254517c elementor-widget elementor-widget-text-editor\" data-id=\"254517c\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t\t\t\t\t\t<p>Once installed, we would have the following, we must click on the indicated part<\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-8caa046 elementor-widget elementor-widget-image\" data-id=\"8caa046\" data-element_type=\"widget\" data-widget_type=\"image.default\">\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<img decoding=\"async\" width=\"583\" height=\"220\" src=\"https:\/\/bestdatasolutions.es\/wp-content\/uploads\/oracle-data-integrator-studio-12c.jpg\" class=\"attachment-large size-large wp-image-6515\" alt=\"oracle-data-integrator-studio-12c\" srcset=\"https:\/\/bestdatasolutions.es\/wp-content\/uploads\/oracle-data-integrator-studio-12c.jpg 583w, https:\/\/bestdatasolutions.es\/wp-content\/uploads\/oracle-data-integrator-studio-12c-300x113.jpg 300w\" sizes=\"(max-width: 583px) 100vw, 583px\" title=\"\">\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-0ea6e74 elementor-widget elementor-widget-text-editor\" data-id=\"0ea6e74\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t\t\t\t\t\t<p>The following window opens, and we should choose to create a new Master repository for the database, keep in mind that Oracle Data Integrator will generate numerous empty tables in that user, so we will use a different account to the DB, in our example we will use our user &#8220;TEMP&#8221;.<\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-6fb8414 elementor-widget elementor-widget-image\" data-id=\"6fb8414\" data-element_type=\"widget\" data-widget_type=\"image.default\">\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<img decoding=\"async\" width=\"297\" height=\"88\" src=\"https:\/\/bestdatasolutions.es\/wp-content\/uploads\/odi-primeros-pasos.jpg\" class=\"attachment-large size-large wp-image-6517\" alt=\"ODI-first-steps\" title=\"\">\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-c848c42 elementor-widget elementor-widget-image\" data-id=\"c848c42\" data-element_type=\"widget\" data-widget_type=\"image.default\">\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<img loading=\"lazy\" decoding=\"async\" width=\"526\" height=\"382\" src=\"https:\/\/bestdatasolutions.es\/wp-content\/uploads\/odi-crear-nuevo-repositorio-maestro.jpg\" class=\"attachment-large size-large wp-image-6519\" alt=\"odi-create-new-master-repository\" srcset=\"https:\/\/bestdatasolutions.es\/wp-content\/uploads\/odi-crear-nuevo-repositorio-maestro.jpg 526w, https:\/\/bestdatasolutions.es\/wp-content\/uploads\/odi-crear-nuevo-repositorio-maestro-300x218.jpg 300w\" sizes=\"(max-width: 526px) 100vw, 526px\" title=\"\">\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-0cea2c9 elementor-widget elementor-widget-text-editor\" data-id=\"0cea2c9\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t\t\t\t\t\t<p>The user is the one that we have created in the Oracle database, we test the connection and it should be correct.<\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-c9cc1af elementor-widget elementor-widget-image\" data-id=\"c9cc1af\" data-element_type=\"widget\" data-widget_type=\"image.default\">\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<img loading=\"lazy\" decoding=\"async\" width=\"800\" height=\"632\" src=\"https:\/\/bestdatasolutions.es\/wp-content\/uploads\/odi-conexion-al-repositorio.jpg\" class=\"attachment-large size-large wp-image-6521\" alt=\"odi-conexion-al-repositorio\" srcset=\"https:\/\/bestdatasolutions.es\/wp-content\/uploads\/odi-conexion-al-repositorio.jpg 800w, https:\/\/bestdatasolutions.es\/wp-content\/uploads\/odi-conexion-al-repositorio-300x237.jpg 300w, https:\/\/bestdatasolutions.es\/wp-content\/uploads\/odi-conexion-al-repositorio-768x607.jpg 768w\" sizes=\"(max-width: 800px) 100vw, 800px\" title=\"\">\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-37caff5 elementor-widget elementor-widget-text-editor\" data-id=\"37caff5\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t\t\t\t\t\t<p>Once tested we move on and have to create a password for the default &#8220;SUPERVISOR&#8221; user.<\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-3c35314 elementor-widget elementor-widget-image\" data-id=\"3c35314\" data-element_type=\"widget\" data-widget_type=\"image.default\">\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<img loading=\"lazy\" decoding=\"async\" width=\"577\" height=\"460\" src=\"https:\/\/bestdatasolutions.es\/wp-content\/uploads\/odi-autenticacion.jpg\" class=\"attachment-large size-large wp-image-6523\" alt=\"odi-authentication\" srcset=\"https:\/\/bestdatasolutions.es\/wp-content\/uploads\/odi-autenticacion.jpg 577w, https:\/\/bestdatasolutions.es\/wp-content\/uploads\/odi-autenticacion-300x239.jpg 300w\" sizes=\"(max-width: 577px) 100vw, 577px\" title=\"\">\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-0ddbbd0 elementor-widget elementor-widget-text-editor\" data-id=\"0ddbbd0\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t\t\t\t\t\t<p><span style=\"font-family: var( --e-global-typography-text-font-family ), Sans-serif; font-size: 1rem; font-weight: var( --e-global-typography-text-font-weight );\">Once we have it, we finish (it takes a while to load).<\/span><\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-b34b388 elementor-widget elementor-widget-image\" data-id=\"b34b388\" data-element_type=\"widget\" data-widget_type=\"image.default\">\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<img loading=\"lazy\" decoding=\"async\" width=\"396\" height=\"180\" src=\"https:\/\/bestdatasolutions.es\/wp-content\/uploads\/odi-creacion-repositorio-maestro.jpg\" class=\"attachment-large size-large wp-image-6483\" alt=\"odi-master-repository-creation\" srcset=\"https:\/\/bestdatasolutions.es\/wp-content\/uploads\/odi-creacion-repositorio-maestro.jpg 396w, https:\/\/bestdatasolutions.es\/wp-content\/uploads\/odi-creacion-repositorio-maestro-300x136.jpg 300w\" sizes=\"(max-width: 396px) 100vw, 396px\" title=\"\">\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-b97ec98 elementor-widget elementor-widget-text-editor\" data-id=\"b97ec98\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t\t\t\t\t\t<p>Here is an example of some of the automatically created tables.<\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-99b4ff3 elementor-widget elementor-widget-image\" data-id=\"99b4ff3\" data-element_type=\"widget\" data-widget_type=\"image.default\">\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<img loading=\"lazy\" decoding=\"async\" width=\"354\" height=\"325\" src=\"https:\/\/bestdatasolutions.es\/wp-content\/uploads\/odi-ejemplo-tablas.jpg\" class=\"attachment-large size-large wp-image-6485\" alt=\"odi-sample-tables\" srcset=\"https:\/\/bestdatasolutions.es\/wp-content\/uploads\/odi-ejemplo-tablas.jpg 354w, https:\/\/bestdatasolutions.es\/wp-content\/uploads\/odi-ejemplo-tablas-300x275.jpg 300w\" sizes=\"(max-width: 354px) 100vw, 354px\" title=\"\">\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-07357de elementor-widget elementor-widget-text-editor\" data-id=\"07357de\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t\t\t\t\t\t<p>Once created we would have to enter the same window, but this time we would create a new connection to the ODI Repository.<\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-5ed0102 elementor-widget elementor-widget-image\" data-id=\"5ed0102\" data-element_type=\"widget\" data-widget_type=\"image.default\">\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<img loading=\"lazy\" decoding=\"async\" width=\"800\" height=\"314\" src=\"https:\/\/bestdatasolutions.es\/wp-content\/uploads\/crear-nueva-conexion-al-repositorio-de-odi.jpg\" class=\"attachment-large size-large wp-image-6487\" alt=\"create-new-connection-to-odi-repository\" srcset=\"https:\/\/bestdatasolutions.es\/wp-content\/uploads\/crear-nueva-conexion-al-repositorio-de-odi.jpg 800w, https:\/\/bestdatasolutions.es\/wp-content\/uploads\/crear-nueva-conexion-al-repositorio-de-odi-300x118.jpg 300w, https:\/\/bestdatasolutions.es\/wp-content\/uploads\/crear-nueva-conexion-al-repositorio-de-odi-768x301.jpg 768w\" sizes=\"(max-width: 800px) 100vw, 800px\" title=\"\">\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-a99f5f4 elementor-widget elementor-widget-text-editor\" data-id=\"a99f5f4\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t\t\t\t\t\t<p>We fill it in as follows, taking into account that the first User corresponds to &#8220;Supervisor&#8221; and the next one is the one created by us in Oracle.<\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-e2fbdbc elementor-widget elementor-widget-image\" data-id=\"e2fbdbc\" data-element_type=\"widget\" data-widget_type=\"image.default\">\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<img loading=\"lazy\" decoding=\"async\" width=\"555\" height=\"553\" src=\"https:\/\/bestdatasolutions.es\/wp-content\/uploads\/odi-informacion-de-conexion-al-repositorio.jpg\" class=\"attachment-large size-large wp-image-6489\" alt=\"odi-repository-connection-information\" srcset=\"https:\/\/bestdatasolutions.es\/wp-content\/uploads\/odi-informacion-de-conexion-al-repositorio.jpg 555w, https:\/\/bestdatasolutions.es\/wp-content\/uploads\/odi-informacion-de-conexion-al-repositorio-300x300.jpg 300w, https:\/\/bestdatasolutions.es\/wp-content\/uploads\/odi-informacion-de-conexion-al-repositorio-150x150.jpg 150w\" sizes=\"(max-width: 555px) 100vw, 555px\" title=\"\">\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-24ddb52 elementor-widget elementor-widget-text-editor\" data-id=\"24ddb52\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t\t\t\t\t\t<p>We test the connection and if it is correct we continue and connect to the currently created Master Repository.<\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-78b18f3 elementor-widget elementor-widget-image\" data-id=\"78b18f3\" data-element_type=\"widget\" data-widget_type=\"image.default\">\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<img loading=\"lazy\" decoding=\"async\" width=\"565\" height=\"124\" src=\"https:\/\/bestdatasolutions.es\/wp-content\/uploads\/odi-prueba-de-conexion.jpg\" class=\"attachment-large size-large wp-image-6491\" alt=\"odi-connection-test\" srcset=\"https:\/\/bestdatasolutions.es\/wp-content\/uploads\/odi-prueba-de-conexion.jpg 565w, https:\/\/bestdatasolutions.es\/wp-content\/uploads\/odi-prueba-de-conexion-300x66.jpg 300w\" sizes=\"(max-width: 565px) 100vw, 565px\" title=\"\">\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-1ddac5d elementor-widget elementor-widget-text-editor\" data-id=\"1ddac5d\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t\t\t\t\t\t<p>Choose the connection in the drop-down menu:<\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-e1089f9 elementor-widget elementor-widget-image\" data-id=\"e1089f9\" data-element_type=\"widget\" data-widget_type=\"image.default\">\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<img loading=\"lazy\" decoding=\"async\" width=\"699\" height=\"256\" src=\"https:\/\/bestdatasolutions.es\/wp-content\/uploads\/conectar-nueva-conexion-odi.jpg\" class=\"attachment-large size-large wp-image-6501\" alt=\"connect-new-odi-connection\" srcset=\"https:\/\/bestdatasolutions.es\/wp-content\/uploads\/conectar-nueva-conexion-odi.jpg 699w, https:\/\/bestdatasolutions.es\/wp-content\/uploads\/conectar-nueva-conexion-odi-300x110.jpg 300w\" sizes=\"(max-width: 699px) 100vw, 699px\" title=\"\">\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-5cf2a1a elementor-widget elementor-widget-text-editor\" data-id=\"5cf2a1a\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t\t\t\t\t\t<p>We have 4 tabs, in this user the designer and the Operator tabs will be disabled:<\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-e632616 elementor-widget elementor-widget-image\" data-id=\"e632616\" data-element_type=\"widget\" data-widget_type=\"image.default\">\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<img loading=\"lazy\" decoding=\"async\" width=\"594\" height=\"153\" src=\"https:\/\/bestdatasolutions.es\/wp-content\/uploads\/odi-pestana-operador-deshabilitada.jpg\" class=\"attachment-large size-large wp-image-6495\" alt=\"odi-operator-tab-disabled\" srcset=\"https:\/\/bestdatasolutions.es\/wp-content\/uploads\/odi-pestana-operador-deshabilitada.jpg 594w, https:\/\/bestdatasolutions.es\/wp-content\/uploads\/odi-pestana-operador-deshabilitada-300x77.jpg 300w\" sizes=\"(max-width: 594px) 100vw, 594px\" title=\"\">\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-11c8827 elementor-widget elementor-widget-text-editor\" data-id=\"11c8827\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t\t\t\t\t\t<p>Investigating these tabs a little further:<\/p><p><b>Topology<\/b>: this tab will be used to describe the physical and logical connections of the information system, the different data servers linked to these technologies, and the schemas, contexts, language, agents, and repositories.<\/p><p><b>2. Operator:<\/b> this section is a management and monitoring tool, it can manage the interface executions in sessions as well as in production scenarios.<\/p><p><b>Security:<\/b> It is the tool to manage security information in ODI, you can create users, and profiles, to provide certain rights to different users or orchestrators.<\/p><p><b>4. Designer:<\/b> here we will verify the integrity of the data, as well as reverse engineering (imports) and transformations.<\/p><p>We will go into some of them later.<\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-facf890 elementor-widget elementor-widget-text-editor\" data-id=\"facf890\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t\t\t\t\t\t<p>Let&#8217;s get started:<\/p><p>1. In the topology tab, let&#8217;s connect the different sources (in this case Oracle)<\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-9a63572 elementor-widget elementor-widget-image\" data-id=\"9a63572\" data-element_type=\"widget\" data-widget_type=\"image.default\">\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<img loading=\"lazy\" decoding=\"async\" width=\"547\" height=\"439\" src=\"https:\/\/bestdatasolutions.es\/wp-content\/uploads\/odi-nuevo-repositorio-de-trabajo.jpg\" class=\"attachment-large size-large wp-image-6497\" alt=\"odi-new-work-repository\" srcset=\"https:\/\/bestdatasolutions.es\/wp-content\/uploads\/odi-nuevo-repositorio-de-trabajo.jpg 547w, https:\/\/bestdatasolutions.es\/wp-content\/uploads\/odi-nuevo-repositorio-de-trabajo-300x241.jpg 300w\" sizes=\"(max-width: 547px) 100vw, 547px\" title=\"\">\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-d1d2347 elementor-widget elementor-widget-text-editor\" data-id=\"d1d2347\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t\t\t\t\t\t<p>We would have to create a new working repository by right-clicking on the working repositories.<\/p><p>2. Fill in the following steps:<\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-5acf628 elementor-widget elementor-widget-image\" data-id=\"5acf628\" data-element_type=\"widget\" data-widget_type=\"image.default\">\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<img loading=\"lazy\" decoding=\"async\" width=\"800\" height=\"477\" src=\"https:\/\/bestdatasolutions.es\/wp-content\/uploads\/propiedades-de-conexion-al-repositorio-odi.jpg\" class=\"attachment-large size-large wp-image-6499\" alt=\"odi-repository-connection-properties\" srcset=\"https:\/\/bestdatasolutions.es\/wp-content\/uploads\/propiedades-de-conexion-al-repositorio-odi.jpg 800w, https:\/\/bestdatasolutions.es\/wp-content\/uploads\/propiedades-de-conexion-al-repositorio-odi-300x179.jpg 300w, https:\/\/bestdatasolutions.es\/wp-content\/uploads\/propiedades-de-conexion-al-repositorio-odi-768x458.jpg 768w\" sizes=\"(max-width: 800px) 100vw, 800px\" title=\"\">\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-9cd20ff elementor-widget elementor-widget-text-editor\" data-id=\"9cd20ff\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t\t\t\t\t\t<p>3. Once it is created, we must disconnect and reconnect with the new connection.<\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-52ee01b elementor-widget elementor-widget-image\" data-id=\"52ee01b\" data-element_type=\"widget\" data-widget_type=\"image.default\">\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<img loading=\"lazy\" decoding=\"async\" width=\"699\" height=\"256\" src=\"https:\/\/bestdatasolutions.es\/wp-content\/uploads\/conectar-nueva-conexion-odi.jpg\" class=\"attachment-large size-large wp-image-6501\" alt=\"connect-new-odi-connection\" srcset=\"https:\/\/bestdatasolutions.es\/wp-content\/uploads\/conectar-nueva-conexion-odi.jpg 699w, https:\/\/bestdatasolutions.es\/wp-content\/uploads\/conectar-nueva-conexion-odi-300x110.jpg 300w\" sizes=\"(max-width: 699px) 100vw, 699px\" title=\"\">\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-7ea270c elementor-widget elementor-widget-text-editor\" data-id=\"7ea270c\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t\t\t\t\t\t<p>4. Once we are inside, we see that we already have the tabs that previously were disabled as enabled. The fastest way to create the environments would be the following, the first thing to do is to go to the &#8220;Designer&#8221; tab and go to the models section and create a new one with topology objects<\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-9e48166 elementor-widget elementor-widget-image\" data-id=\"9e48166\" data-element_type=\"widget\" data-widget_type=\"image.default\">\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<img loading=\"lazy\" decoding=\"async\" width=\"724\" height=\"439\" src=\"https:\/\/bestdatasolutions.es\/wp-content\/uploads\/nuevo-modelo-y-objetos-de-tipologia-odi.jpg\" class=\"attachment-large size-large wp-image-6503\" alt=\"new-odi-typology-model-and-objects\" srcset=\"https:\/\/bestdatasolutions.es\/wp-content\/uploads\/nuevo-modelo-y-objetos-de-tipologia-odi.jpg 724w, https:\/\/bestdatasolutions.es\/wp-content\/uploads\/nuevo-modelo-y-objetos-de-tipologia-odi-300x182.jpg 300w\" sizes=\"(max-width: 724px) 100vw, 724px\" title=\"\">\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-6dd9435 elementor-widget elementor-widget-text-editor\" data-id=\"6dd9435\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t\t\t\t\t\t<p>5. Once inside, we will have to fill in 3 fairly simple tabs (this is where we will connect it to our real database, called tutorial, where we have our working tables:<\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-a7a961e elementor-widget elementor-widget-image\" data-id=\"a7a961e\" data-element_type=\"widget\" data-widget_type=\"image.default\">\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<img loading=\"lazy\" decoding=\"async\" width=\"661\" height=\"571\" src=\"https:\/\/bestdatasolutions.es\/wp-content\/uploads\/modelo-y-objetos-de-tipologia-odi-paso-1.jpg\" class=\"attachment-large size-large wp-image-6505\" alt=\"model-and-type-objects-step-1\" srcset=\"https:\/\/bestdatasolutions.es\/wp-content\/uploads\/modelo-y-objetos-de-tipologia-odi-paso-1.jpg 661w, https:\/\/bestdatasolutions.es\/wp-content\/uploads\/modelo-y-objetos-de-tipologia-odi-paso-1-300x259.jpg 300w\" sizes=\"(max-width: 661px) 100vw, 661px\" title=\"\">\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-722ee66 elementor-widget elementor-widget-text-editor\" data-id=\"722ee66\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t\t\t\t\t\t<p>This step has generated the physical and logical schematics in a single step, without having to create them individually in numerous steps, we can see what has been created in the topology tab, both in the physical and logical architecture sections.<\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-0319550 elementor-widget elementor-widget-image\" data-id=\"0319550\" data-element_type=\"widget\" data-widget_type=\"image.default\">\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<img loading=\"lazy\" decoding=\"async\" width=\"565\" height=\"165\" src=\"https:\/\/bestdatasolutions.es\/wp-content\/uploads\/modelo-y-objetos-de-tipologia-odi-paso-2.jpg\" class=\"attachment-large size-large wp-image-6507\" alt=\"model-and-type-objects-step-2\" srcset=\"https:\/\/bestdatasolutions.es\/wp-content\/uploads\/modelo-y-objetos-de-tipologia-odi-paso-2.jpg 565w, https:\/\/bestdatasolutions.es\/wp-content\/uploads\/modelo-y-objetos-de-tipologia-odi-paso-2-300x88.jpg 300w\" sizes=\"(max-width: 565px) 100vw, 565px\" title=\"\">\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-2bf7684 elementor-widget elementor-widget-text-editor\" data-id=\"2bf7684\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t\t\t\t\t\t<p>Once we have it we should save and select selective reverse engineering:<\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-43e413a elementor-widget elementor-widget-image\" data-id=\"43e413a\" data-element_type=\"widget\" data-widget_type=\"image.default\">\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<img loading=\"lazy\" decoding=\"async\" width=\"800\" height=\"204\" src=\"https:\/\/bestdatasolutions.es\/wp-content\/uploads\/odi-ingenieria-inversa-selectiva.jpg\" class=\"attachment-large size-large wp-image-6509\" alt=\"odi-selective-reverse-engineering\" srcset=\"https:\/\/bestdatasolutions.es\/wp-content\/uploads\/odi-ingenieria-inversa-selectiva.jpg 800w, https:\/\/bestdatasolutions.es\/wp-content\/uploads\/odi-ingenieria-inversa-selectiva-300x77.jpg 300w, https:\/\/bestdatasolutions.es\/wp-content\/uploads\/odi-ingenieria-inversa-selectiva-768x196.jpg 768w\" sizes=\"(max-width: 800px) 100vw, 800px\" title=\"\">\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-fdba341 elementor-widget elementor-widget-text-editor\" data-id=\"fdba341\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t\t\t\t\t\t<p>Now we will select those tables that we want to import to Oracle Data Integrator, in our case all of them, once we have selected them we would proceed to click on reverse engineering.<\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-29834c7 elementor-widget elementor-widget-image\" data-id=\"29834c7\" data-element_type=\"widget\" data-widget_type=\"image.default\">\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<img loading=\"lazy\" decoding=\"async\" width=\"800\" height=\"237\" src=\"https:\/\/bestdatasolutions.es\/wp-content\/uploads\/odi-ingenieria-inversa-selectiva-seleccion-tablas.jpg\" class=\"attachment-large size-large wp-image-6511\" alt=\"odi-selective-reverse-engineering-table-selection\" srcset=\"https:\/\/bestdatasolutions.es\/wp-content\/uploads\/odi-ingenieria-inversa-selectiva-seleccion-tablas.jpg 800w, https:\/\/bestdatasolutions.es\/wp-content\/uploads\/odi-ingenieria-inversa-selectiva-seleccion-tablas-300x89.jpg 300w, https:\/\/bestdatasolutions.es\/wp-content\/uploads\/odi-ingenieria-inversa-selectiva-seleccion-tablas-768x228.jpg 768w\" sizes=\"(max-width: 800px) 100vw, 800px\" title=\"\">\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-43efd5a elementor-widget elementor-widget-text-editor\" data-id=\"43efd5a\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t\t\t\t\t\t<p><span style=\"font-family: var( --e-global-typography-text-font-family ), Sans-serif; font-size: 1rem; font-weight: var( --e-global-typography-text-font-weight );\">We would already have it ready to generate a project and be able to start working with the model:<\/span><\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-169559e elementor-widget elementor-widget-image\" data-id=\"169559e\" data-element_type=\"widget\" data-widget_type=\"image.default\">\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<img loading=\"lazy\" decoding=\"async\" width=\"298\" height=\"265\" src=\"https:\/\/bestdatasolutions.es\/wp-content\/uploads\/odi-modelo-finalizado.jpg\" class=\"attachment-large size-large wp-image-6513\" alt=\"odi-model-completed\" title=\"\">\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-93f35b9 elementor-widget elementor-widget-text-editor\" data-id=\"93f35b9\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t\t\t\t\t\t<p>Nowadays it is very important not only to have data but also to have integrated and congruent data from different sources. Oracle Data Integrator is a powerful tool that enables integration for operational and analytical environments, providing real-time integration, transformation, synchronization, quality, and management of data, to ensure that information is timely, accurate, and consistent across the heterogeneous systems from which it is fed. <\/p><p>In this article, we have only seen how to raise connections to an Oracle database, but there is a multitude of sources that can feed ODI correctly.<\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-614b2ec9 elementor-widget-divider--view-line elementor-widget elementor-widget-divider\" data-id=\"614b2ec9\" data-element_type=\"widget\" data-widget_type=\"divider.default\">\n\t\t\t\t\t\t\t<div class=\"elementor-divider\">\n\t\t\t<span class=\"elementor-divider-separator\">\n\t\t\t\t\t\t<\/span>\n\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-c77df54 elementor-align-center elementor-widget elementor-widget-button\" data-id=\"c77df54\" data-element_type=\"widget\" data-widget_type=\"button.default\">\n\t\t\t\t\t\t\t\t\t\t<a class=\"elementor-button elementor-button-link elementor-size-sm\" href=\"https:\/\/bestdatasolutions.es\/en\/blog\/\">\n\t\t\t\t\t\t<span class=\"elementor-button-content-wrapper\">\n\t\t\t\t\t\t\t\t\t<span class=\"elementor-button-text\">&lt;&lt; BACK TO BLOG<\/span>\n\t\t\t\t\t<\/span>\n\t\t\t\t\t<\/a>\n\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<\/div>\n\t\t","protected":false},"excerpt":{"rendered":"<p>Oracle Data Integrator (ODI) is an integration platform, it goes beyond a traditional ETL tool, in which we extract data from different sources, transform it in the proces,s and then load it to the target. Oracle Data Integrator has an ELT functionality, as we extract data from different databases, load them into ODI, and then perform all the transformations.<\/p>\n","protected":false},"author":13,"featured_media":6477,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[49],"tags":[74],"class_list":["post-6473","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-blog","tag-general"],"_links":{"self":[{"href":"https:\/\/bestdatasolutions.es\/en\/wp-json\/wp\/v2\/posts\/6473","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/bestdatasolutions.es\/en\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/bestdatasolutions.es\/en\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/bestdatasolutions.es\/en\/wp-json\/wp\/v2\/users\/13"}],"replies":[{"embeddable":true,"href":"https:\/\/bestdatasolutions.es\/en\/wp-json\/wp\/v2\/comments?post=6473"}],"version-history":[{"count":0,"href":"https:\/\/bestdatasolutions.es\/en\/wp-json\/wp\/v2\/posts\/6473\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/bestdatasolutions.es\/en\/wp-json\/wp\/v2\/media\/6477"}],"wp:attachment":[{"href":"https:\/\/bestdatasolutions.es\/en\/wp-json\/wp\/v2\/media?parent=6473"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/bestdatasolutions.es\/en\/wp-json\/wp\/v2\/categories?post=6473"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/bestdatasolutions.es\/en\/wp-json\/wp\/v2\/tags?post=6473"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}