{"id":15971,"date":"2021-03-24T22:31:30","date_gmt":"2021-03-24T21:31:30","guid":{"rendered":"https:\/\/www.dbi-services.com\/blog\/oracle-data-integrator-cloud\/"},"modified":"2023-07-19T16:26:16","modified_gmt":"2023-07-19T14:26:16","slug":"oracle-data-integrator-cloud","status":"publish","type":"post","link":"https:\/\/www.dbi-services.com\/blog\/oracle-data-integrator-cloud\/","title":{"rendered":"Oracle Data Integrator Cloud"},"content":{"rendered":"<p>Data and applications integration is always a technical challenge for most of the companies. All data integration tool ensures that information is timely, accurate, and consistent across complex systems.<\/p>\n<p>Oracle Data Integrator (ODI) is different than traditional data integration tools in the sense it integrates data in a different orders.<\/p>\n<p>ODI is known as en E-LT because it <strong>E<\/strong>xtracts data from the source system and <strong>L<\/strong>oads and <strong>T<\/strong>ransforms data into the target system while traditional tools transform the data in an intermediate layer (Staging) between the Source (where the data is <strong>E<\/strong>xtract) and the Target (where the data is <strong>L<\/strong>oaded).<\/p>\n<p>Oracle Data Integrator Cloud removes the complexity in creating real-time operation reporting schema enabling a novice user to perform the creation, initial load, and real time synchronization in just a few clicks. Usually, these types of data integration required assistance from ELT developers and Database administrators.<\/p>\n<p>The goal of this blog is to show you how install ODI in the Cloud.<\/p>\n<p>Sign up for a free credit promotion or purchase an Oracle Cloud subscription and your sign-in credentials.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-48506 size-full\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2021\/03\/Capture.png\" alt=\"\" width=\"1584\" height=\"247\" \/><\/p>\n<p>There are two types of ODI components:<\/p>\n<ul>\n<li>Oracle Data Integrator Studio used by Administrators, Developers and Operators for administering the infrastructure (security and topology), reverse-engineering the metadata, developing projects, scheduling, operating and monitoring executions.<\/li>\n<li>Oracle Data Integrator Console used (in read only) to access the repositories, peform topology configuration and production operations.<\/li>\n<\/ul>\n<p><strong>The first step is to create an Oracle Database Cloud Service Instance (Database As A Service)<br \/>\n<\/strong><\/p>\n<p>In the top right menu, go to service user console:<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-48668 size-full\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2021\/03\/Capture27.png\" alt=\"\" width=\"543\" height=\"392\" \/><\/p>\n<p>Click on Service User Console<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-48669 size-full\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2021\/03\/Capture28.png\" alt=\"\" width=\"1582\" height=\"664\" \/><\/p>\n<p>Click On Oracle Database Cloud Service<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-48670\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2021\/03\/Capture29.png\" alt=\"\" width=\"1441\" height=\"678\" \/><\/p>\n<p>Click on Go to Console<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-48671\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2021\/03\/Capture30.png\" alt=\"\" width=\"1601\" height=\"703\" \/><\/p>\n<p>Click on Create Instance<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-48672\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2021\/03\/Capture32.png\" alt=\"\" width=\"1594\" height=\"887\" \/><\/p>\n<p>Choose Instance Name and Database Version and Click Next<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-48673 size-full\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2021\/03\/Capture34.png\" alt=\"\" width=\"1556\" height=\"961\" \/><\/p>\n<p>Choose Database Name, Administration Password (leave all others default value) and Click Next<\/p>\n<p>Create an SSH key, public and private key<\/p>\n<pre class=\"brush: shell; gutter: true; first-line: 1\">ssh-keygen -t rsa -N \"\" -b \"2048\" -C \"key comment\" -f \/drives\/c\/Users\/lfe\/Documents\/dbi\/technique\/blog\/ODI_cloud\/id_rsa\n\nWARNING:\n\nYou should not store anything in MobaXterm HOME directoy (\/home\/mobaxterm): with your current settings, this folder is not \"persistent\", so it will be cleared at each MobaXterm restart.\n\nIf you want to set a \"persistent\" HOME directory which will not be cleared at each MobaXterm startup, go to MobaXterm settings window and choose a folder in which to store MobaXterm home files.\n\nGenerating public\/private rsa key pair.\nYour identification has been saved in \/drives\/c\/Users\/lfe\/Documents\/dbi\/technique\/blog\/ODI_cloud\/id_rsa.\nYour public key has been saved in \/drives\/c\/Users\/lfe\/Documents\/dbi\/technique\/blog\/ODI_cloud\/id_rsa.pub.\nThe key fingerprint is:\nSHA256:S0Z6qE+BSdANABj3RDOdvEq1hxF5ts3jA4MbG8lGGv4 key comment\nThe key's randomart image is:\n+---[RSA 2048]----+\n|+o++*=.+ |\n|.. +ooX o |\n| .o* X.+ |\n| .+o@+= + |\n| .o++*S+ . |\n| ..E= .o |\n| . . . . |\n| o |\n| . |\n+----[SHA256]-----+<\/pre>\n<p>Two keys are created :<\/p>\n<ul>\n<li>public key : id_rsa.pub<\/li>\n<li>private key : id_rsa<\/li>\n<\/ul>\n<p>Click on &#8220;SSHPublic Key Files&#8221; and Upload the Public key files just created.<\/p>\n<p>Click Next<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-48674\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2021\/03\/Capture35.png\" alt=\"\" width=\"1570\" height=\"929\" \/><\/p>\n<p>Click on Create<\/p>\n<p>The Instance Creation fails:<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-48675 size-full\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2021\/03\/Capture37.png\" alt=\"\" width=\"779\" height=\"166\" \/><\/p>\n<p>Let&#8217;s go back to the previous screen to replace Oracle Database 19c by Oracle Database 12c Release 2<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-48676 size-full\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2021\/03\/Capture38.png\" alt=\"\" width=\"515\" height=\"100\" \/><\/p>\n<p>Now the instance can be created:<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-48677\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2021\/03\/Capture39.png\" alt=\"\" width=\"1635\" height=\"861\" \/><\/p>\n<p>The instance is being created&#8230;<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-48678 size-full\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2021\/03\/Capture40.png\" alt=\"\" width=\"1574\" height=\"914\" \/><\/p>\n<p>Wait some minutes till the instance is created (Status Ready)<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-48683\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2021\/03\/Capture44.png\" alt=\"\" width=\"1593\" height=\"874\" \/>Let&#8217;s try to connect with a SSH client (MobaXterm in our case) to the database machine<\/p>\n<p>Get the Public IP address and let&#8217;s add the private key created previously into Mobaxterm<\/p>\n<p><strong><img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-48679 size-full\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2021\/03\/Capture41.png\" alt=\"\" width=\"1025\" height=\"693\" \/><\/strong><\/p>\n<p>Click OK<\/p>\n<p><strong><img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-48680 size-full\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2021\/03\/Capture43.png\" alt=\"\" width=\"751\" height=\"354\" \/><\/strong><\/p>\n<p>Now we can connect to the database :<\/p>\n<pre class=\"brush: sql; gutter: true; first-line: 1\">[opc@ODI ~]$ sudo su - oracle\n[oracle@ODI ~]$ sudo su - oracle\nLast login: Fri Mar 26 10:58:13 UTC 2021\n[oracle@ODI ~]$\n[oracle@ODI ~]$ ps -ef | grep pmon\noracle   16565     1  0 10:53 ?        00:00:00 ora_pmon_ODI\noracle   23105 23056  0 10:58 pts\/0    00:00:00 grep --color=auto pmon\n[oracle@ODI ~]$ sqlplus \/ as sysdba\n\nSQL*Plus: Release 12.2.1.0.0 - Production on Fri Mar 26 10:59:00 2021\nVersion 12.2.1.0.0\n\nCopyright (c) 1982, 2020, Oracle.  All rights reserved.\n\n\nConnected to:\nOracle Database 12c EE High Perf Release 12.2.1.0.0 - Production\nVersion 12.2.1.0.0\n\nSQL&gt; show pdbs\n\n    CON_ID CON_NAME                       OPEN MODE  RESTRICTED\n---------- ------------------------------ ---------- ----------\n         2 PDB$SEED                       READ ONLY  NO\n         3 ODI                    \t\t  READ WRITE NO\nSQL&gt; alter session set container=ODI;\n\nSession altered.<\/pre>\n<p><strong>The second step is to provisioning an Oracle Java Cloud Instance<\/strong><\/p>\n<p>The goal is to configure the Oracle Java Cloud Instance on which we want to install and run Oracle Data Integrator Cloud.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-48661 size-full\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2021\/03\/Capture21.png\" alt=\"\" width=\"1203\" height=\"210\" \/><\/p>\n<p>Click On Java Services<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-48662 size-full\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2021\/03\/Capture22.png\" alt=\"\" width=\"1641\" height=\"685\" \/><\/p>\n<p>Click on Create Instance<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-48693 size-full\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2021\/03\/Capture49-1.png\" alt=\"\" width=\"1238\" height=\"744\" \/><\/p>\n<p>Enter the service details:<\/p>\n<ul>\n<li><span class=\"bold\">Service Level<\/span> \u2014 From the dropdown, select Oracle Java Cloud Service for Fusion Middleware<kbd class=\"userinput\"><\/kbd> &#8211; Oracle Data Integrator<\/li>\n<li><span class=\"bold\">Software Release<\/span> \u2014 Select Oracle Weblogic Server 12c (12.2.1.2)<\/li>\n<\/ul>\n<p>Click Next<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-48688 size-full\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2021\/03\/Capture47.png\" alt=\"\" width=\"1277\" height=\"854\" \/><\/p>\n<p>Choose the Compute Shape (VM.Standard &#8211; 2.0 OCPU, 30 GB of Ram).<\/p>\n<p>Choose the public key created previously<\/p>\n<p>Choose the Instance ODI created previously<\/p>\n<p>Enter SYS credentials<\/p>\n<p>For our case do no configure backup. Of course in a production environment, you have always to set Backup Destination.<\/p>\n<p>Click Next<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-48691 size-full\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2021\/03\/Capture50.png\" alt=\"\" width=\"1184\" height=\"860\" \/>Click on Create<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-48690 size-full\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2021\/03\/Capture51.png\" alt=\"\" width=\"1572\" height=\"771\" \/><\/p>\n<p>Wait a moment for the Instance creation&#8230;<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-48695 size-full\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2021\/03\/Capture54.png\" alt=\"\" width=\"1590\" height=\"967\" \/><\/p>\n<p>The Oracle Java Cloud Service Instance (JAAS) is now created and associated with the Oracle Database Cloud Service Instance (DBAAS).<\/p>\n<p>Configure the SSH connection from MobaXterm with the same private key created previously for the database instance machine<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-48694 size-full\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2021\/03\/Capture53.png\" alt=\"\" width=\"831\" height=\"442\" \/><\/p>\n<p><strong>The next step is to install Oracle Data Integrator<\/strong><\/p>\n<p>The good news with the Cloud is that Oracle WebLogic Server is already installed in your Java Cloud Service instance, there is no need to install the Fusion Middleware Infrastructure. It is already there!!!<\/p>\n<p>To interact with the graphical interface into the Java Cloud Server Instance, we have to configure VCN viewer.<\/p>\n<p>Turn Off the lock screen and start the VNC Server<\/p>\n<pre class=\"brush: shell; gutter: true; first-line: 1\">[oracle@oditest-wls-1 upperstack]$ gconftool-2 -s -t bool \/apps\/gnome-screensaver\/lock_enabled false\n[oracle@oditest-wls-1 upperstack]$ vncserver -nolisten local -geometry 1680x1050\n\nYou will require a password to access your desktops.\n\nPassword:\nVerify:\nWould you like to enter a view-only password (y\/n)? y\nPassword:\nVerify:\nxauth:  file \/u01\/app\/oracle\/tools\/home\/oracle\/.Xauthority does not exist\n\nNew 'oditest-wls-1:1 (oracle)' desktop is oditest-wls-1:1\n\nCreating default startup script \/u01\/app\/oracle\/tools\/home\/oracle\/.vnc\/xstartup\nCreating default config \/u01\/app\/oracle\/tools\/home\/oracle\/.vnc\/config\nStarting applications specified in \/u01\/app\/oracle\/tools\/home\/oracle\/.vnc\/xstartup\nLog file is \/u01\/app\/oracle\/tools\/home\/oracle\/.vnc\/oditest-wls-1:1.log<\/pre>\n<p>Open a <span class=\"bold\">new local terminal<\/span> to create an SSH tunnel on the VNC server port on the Administration Server VM<\/p>\n<pre class=\"brush: shell; gutter: true; first-line: 1\">ssh -i C:\/Users\/lfe\/Documents\/dbi\/technique\/blog\/ODI_cloud\/id_rsa -L 5901:127.0.0.1:5901 opc@140.238.211.108 -N<\/pre>\n<p>To have the graphical access for the Oracle Java Cloud Server instance,use the VNC Viewer on the local machine to connect to localhost:5901. You will be prompted for the password you entered in the previous step.<\/p>\n<p>Start VNC Viewer locally<\/p>\n<pre class=\"brush: shell; gutter: true; first-line: 1\"><\/pre>\n<pre class=\"pre codeblock hljs\"><\/pre>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-48696 size-full\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2021\/03\/Capture55.png\" alt=\"\" width=\"515\" height=\"316\" \/><\/p>\n<p>From vncviewer, navigate to the \/u01\/zips\/upperstack directory and install ODI<\/p>\n<pre class=\"brush: shell; gutter: true; first-line: 1\">[oracle@oditest-wls-1 upperstack]$ cd \/u01\/zips\/upperstack\/\n[oracle@oditest-wls-1 upperstack]$ ls -ltr\ntotal 4323160\n-r-xr-xr-x. 1 oracle oracle 2027199017 Aug 22  2017 fmw_12.2.1.3.0_odi_generic.jar\n-r-xr-xr-x. 1 oracle oracle  186404495 Aug 22  2017 fmw_12.2.1.3.0_odi_generic2.jar\n-rwxr-xr-x. 1 oracle oracle 2213306744 Dec 17  2019 ODI.zip\n[oracle@oditest-wls-1 upperstack]$ unzip ODI.zip\nArchive: ODI.zip\ninflating: fmw_12.2.1.3.0_odi_generic.jar\ninflating: fmw_12.2.1.3.0_odi_generic2.jar\n[oracle@oditest-wls-1 upperstack]$ java -jar fmw_12.2.1.3.0_odi_generic.jar \nLauncher log file is \/tmp\/OraInstall2021-03-19_09-14-31PM\/launcher2021-03-19_09-14-31PM.log.\nExtracting the installer . . . . . . . . . Done\nChecking if CPU speed is above 300 MHz.   Actual 1995.309 MHz    Passed\nChecking monitor: must be configured to display at least 256 colors.   Actual 16777216    Passed\nChecking swap space: must be greater than 512 MB.   Actual 8191 MB    Passed\nChecking if this platform requires a 64-bit JVM.   Actual 64    Passed (64-bit not required)\nChecking temp space: must be greater than 300 MB.   Actual 26195 MB    Passed\nPreparing to launch the Oracle Universal Installer from \/tmp\/OraInstall2021-03-19_09-14-31PM<\/pre>\n<p>The installation starts<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-48697 size-full\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2021\/03\/Capture56.png\" alt=\"\" width=\"567\" height=\"368\" \/><\/p>\n<p>Click OK<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-48721 size-full\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2021\/03\/Capture57.png\" alt=\"\" width=\"744\" height=\"580\" \/><\/p>\n<p>Click Next<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-48722 size-full\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2021\/03\/Capture58.png\" alt=\"\" width=\"742\" height=\"581\" \/><\/p>\n<p>Skip Auto Updates and click Next<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-48724 size-full\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2021\/03\/Capture60.png\" alt=\"\" width=\"745\" height=\"582\" \/><\/p>\n<p>Choose Enterprise Edition and Click Next<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-48725 size-full\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2021\/03\/Capture61.png\" alt=\"\" width=\"745\" height=\"579\" \/><\/p>\n<p>Click Next<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-48726 size-full\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2021\/03\/Capture62.png\" alt=\"\" width=\"750\" height=\"580\" \/><\/p>\n<p>Click Install<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-48728 size-full\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2021\/03\/Capture65.png\" alt=\"\" width=\"740\" height=\"583\" \/><\/p>\n<p>Now, let&#8217;s create the Oracle Data Integrator Repository<\/p>\n<pre class=\"brush: shell; gutter: true; first-line: 1\">[oracle@oditest-wls-1 bin]$ cd \/u01\/app\/oracle\/middleware\/oracle_common\/bin\/\n[oracle@oditest-wls-1 bin]$ .\/rcu<\/pre>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-48729 size-full\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2021\/03\/Capture66.png\" alt=\"\" width=\"742\" height=\"557\" \/><\/p>\n<p>Click Next<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-48730 size-full\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2021\/03\/Capture67.png\" alt=\"\" width=\"741\" height=\"561\" \/><\/p>\n<p>Click Next<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-48732 size-full\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2021\/03\/Capture70.png\" alt=\"\" width=\"748\" height=\"553\" \/><\/p>\n<p>Choose your PDB database and SYS credentials (DBaaS) created previously and click Next<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-48733 size-full\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2021\/03\/Capture69.png\" alt=\"\" width=\"749\" height=\"563\" \/><\/p>\n<p>Click Ok<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-48774 size-full\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2021\/03\/Image1.png\" alt=\"\" width=\"739\" height=\"548\" \/><\/p>\n<p>Check Oracle Data Integrator, leave by default all option checked and click Next<\/p>\n<p>Enter password for main and auxiliary schemas and click Next<\/p>\n<p>Click Create Tablespaces and Schemas DEV1_*<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-48748 size-full\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2021\/03\/Capture79.png\" alt=\"\" width=\"744\" height=\"564\" \/><\/p>\n<p>Click Close<\/p>\n<p>Update the Java Cloud Instance Domain<\/p>\n<pre class=\"brush: shell; gutter: true; first-line: 1\">est-wls-1 bin]$ cd \/u01\/app\/oracle\/tools\/home\/oracle\/Oracle\/Middleware\/Oracle_Home\/oracle_common\/common\/\n[oracle@oditest-wls-1 bin]$ .\/config.sh<\/pre>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-48778 size-full\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2021\/03\/Capture92.png\" alt=\"\" width=\"746\" height=\"555\" \/><\/p>\n<p>Click Next<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-48779 size-full\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2021\/03\/Capture93.png\" alt=\"\" width=\"742\" height=\"552\" \/><\/p>\n<p>Select Oracle Data Integrator Components and click Next<\/p>\n<p>Leave all default value checked and click Next for all screens<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-48780 size-full\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2021\/03\/Capture147.png\" alt=\"\" width=\"740\" height=\"559\" \/><\/p>\n<p>Click Next<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-48781 size-full\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2021\/03\/Capture148.png\" alt=\"\" width=\"745\" height=\"562\" \/><\/p>\n<p>Click Finish<\/p>\n<p>The last task is to start ODI Studio and create ODI Agents<\/p>\n<pre class=\"brush: shell; gutter: true; first-line: 1\">[oracle@oditest-wls-1 studio]$ cd \/u01\/app\/oracle\/tools\/home\/oracle\/Oracle\/Middleware\/Oracle_Home\/odi\/studio\/\n[oracle@oditest-wls-1 studio]$ .\/odi.sh\n. . .<\/pre>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-48784 size-full\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/Capture149-1.png\" alt=\"\" width=\"1100\" height=\"731\" \/><\/p>\n<p>Create your connection, connect to the Work Repository<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-48785 size-full\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2021\/03\/Capture150.png\" alt=\"\" width=\"631\" height=\"244\" \/><\/p>\n<p>Click OK<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-48787 size-full\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/Capture151-1.png\" alt=\"\" width=\"1410\" height=\"877\" \/><\/p>\n<p>Go to Topology\/Physical Architecture\/Agent (right click)\/New Agent and create the Physical Agent<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-48789 size-full\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/Capture152.png\" alt=\"\" width=\"366\" height=\"357\" \/><\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-48790 size-full\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/Capture153.png\" alt=\"\" width=\"1241\" height=\"390\" \/><\/p>\n<p>Go to Topology\/Logical Architecture\/Agent (right click)\/New Agent and create the Logical Agent<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-48792 size-full\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/Capture154.png\" alt=\"\" width=\"429\" height=\"266\" \/><\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-48793 size-full\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/Capture155.png\" alt=\"\" width=\"721\" height=\"332\" \/><\/p>\n<p>Now you are ready to create your first mapping from source database to target database.<\/p>\n<p><strong>Conclusion:<\/strong><\/p>\n<p>To install Oracle Data Integrator into Oracle Cloud Infrastructure, we need to :<\/p>\n<ul>\n<li>To access to OCI Generation 1 &#8211; OCI Classic (Menu Profile\/Service User Console), the OCI generation 2 is reachable from the top left menu<\/li>\n<li>Create a database instance (DBaaS) provisioning a machine with Oracle Database already installed used to store the ODI repository.<\/li>\n<li>Create a Java instance (JaaS) provisioning a machine with Oracle Fusion Middleware Infrastructure already installed,<\/li>\n<li>Install ODI into the JaaS machine.<\/li>\n<\/ul>\n","protected":false},"excerpt":{"rendered":"<p>Data and applications integration is always a technical challenge for most of the companies. All data integration tool ensures that information is timely, accurate, and consistent across complex systems. Oracle Data Integrator (ODI) is different than traditional data integration tools in the sense it integrates data in a different orders. ODI is known as en [&hellip;]<\/p>\n","protected":false},"author":27,"featured_media":15978,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"footnotes":""},"categories":[197,955,229,525,59],"tags":[],"type_dbi":[],"class_list":["post-15971","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-application-integration-middleware","category-cloud","category-database-administration-monitoring","category-enterprise-content-management","category-oracle"],"acf":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO Premium plugin v27.2 (Yoast SEO v27.2) - https:\/\/yoast.com\/product\/yoast-seo-premium-wordpress\/ -->\n<title>Oracle Data Integrator Cloud - dbi Blog<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.dbi-services.com\/blog\/oracle-data-integrator-cloud\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Oracle Data Integrator Cloud\" \/>\n<meta property=\"og:description\" content=\"Data and applications integration is always a technical challenge for most of the companies. All data integration tool ensures that information is timely, accurate, and consistent across complex systems. Oracle Data Integrator (ODI) is different than traditional data integration tools in the sense it integrates data in a different orders. ODI is known as en [&hellip;]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.dbi-services.com\/blog\/oracle-data-integrator-cloud\/\" \/>\n<meta property=\"og:site_name\" content=\"dbi Blog\" \/>\n<meta property=\"article:published_time\" content=\"2021-03-24T21:31:30+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2023-07-19T14:26:16+00:00\" \/>\n<meta property=\"og:image\" content=\"http:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/Capture149.png\" \/>\n\t<meta property=\"og:image:width\" content=\"1100\" \/>\n\t<meta property=\"og:image:height\" content=\"731\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\n<meta name=\"author\" content=\"Oracle Team\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Oracle Team\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"14 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/oracle-data-integrator-cloud\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/oracle-data-integrator-cloud\/\"},\"author\":{\"name\":\"Oracle Team\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/66ab87129f2d357f09971bc7936a77ee\"},\"headline\":\"Oracle Data Integrator Cloud\",\"datePublished\":\"2021-03-24T21:31:30+00:00\",\"dateModified\":\"2023-07-19T14:26:16+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/oracle-data-integrator-cloud\/\"},\"wordCount\":993,\"commentCount\":0,\"image\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/oracle-data-integrator-cloud\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/Capture149.png\",\"articleSection\":[\"Application integration &amp; Middleware\",\"Cloud\",\"Database Administration &amp; Monitoring\",\"Enterprise content management\",\"Oracle\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/www.dbi-services.com\/blog\/oracle-data-integrator-cloud\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/oracle-data-integrator-cloud\/\",\"url\":\"https:\/\/www.dbi-services.com\/blog\/oracle-data-integrator-cloud\/\",\"name\":\"Oracle Data Integrator Cloud - dbi Blog\",\"isPartOf\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/oracle-data-integrator-cloud\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/oracle-data-integrator-cloud\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/Capture149.png\",\"datePublished\":\"2021-03-24T21:31:30+00:00\",\"dateModified\":\"2023-07-19T14:26:16+00:00\",\"author\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/66ab87129f2d357f09971bc7936a77ee\"},\"breadcrumb\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/oracle-data-integrator-cloud\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.dbi-services.com\/blog\/oracle-data-integrator-cloud\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/oracle-data-integrator-cloud\/#primaryimage\",\"url\":\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/Capture149.png\",\"contentUrl\":\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/Capture149.png\",\"width\":1100,\"height\":731},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/oracle-data-integrator-cloud\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Accueil\",\"item\":\"https:\/\/www.dbi-services.com\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Oracle Data Integrator Cloud\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/#website\",\"url\":\"https:\/\/www.dbi-services.com\/blog\/\",\"name\":\"dbi Blog\",\"description\":\"\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/www.dbi-services.com\/blog\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/66ab87129f2d357f09971bc7936a77ee\",\"name\":\"Oracle Team\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/secure.gravatar.com\/avatar\/f711f7cd2c9b09bf2627133755b569fb5be0694810cfd33033bdd095fedba86d?s=96&d=mm&r=g\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/f711f7cd2c9b09bf2627133755b569fb5be0694810cfd33033bdd095fedba86d?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/f711f7cd2c9b09bf2627133755b569fb5be0694810cfd33033bdd095fedba86d?s=96&d=mm&r=g\",\"caption\":\"Oracle Team\"},\"url\":\"https:\/\/www.dbi-services.com\/blog\/author\/oracle-team\/\"}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"Oracle Data Integrator Cloud - dbi Blog","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:\/\/www.dbi-services.com\/blog\/oracle-data-integrator-cloud\/","og_locale":"en_US","og_type":"article","og_title":"Oracle Data Integrator Cloud","og_description":"Data and applications integration is always a technical challenge for most of the companies. All data integration tool ensures that information is timely, accurate, and consistent across complex systems. Oracle Data Integrator (ODI) is different than traditional data integration tools in the sense it integrates data in a different orders. ODI is known as en [&hellip;]","og_url":"https:\/\/www.dbi-services.com\/blog\/oracle-data-integrator-cloud\/","og_site_name":"dbi Blog","article_published_time":"2021-03-24T21:31:30+00:00","article_modified_time":"2023-07-19T14:26:16+00:00","og_image":[{"width":1100,"height":731,"url":"http:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/Capture149.png","type":"image\/png"}],"author":"Oracle Team","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Oracle Team","Est. reading time":"14 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.dbi-services.com\/blog\/oracle-data-integrator-cloud\/#article","isPartOf":{"@id":"https:\/\/www.dbi-services.com\/blog\/oracle-data-integrator-cloud\/"},"author":{"name":"Oracle Team","@id":"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/66ab87129f2d357f09971bc7936a77ee"},"headline":"Oracle Data Integrator Cloud","datePublished":"2021-03-24T21:31:30+00:00","dateModified":"2023-07-19T14:26:16+00:00","mainEntityOfPage":{"@id":"https:\/\/www.dbi-services.com\/blog\/oracle-data-integrator-cloud\/"},"wordCount":993,"commentCount":0,"image":{"@id":"https:\/\/www.dbi-services.com\/blog\/oracle-data-integrator-cloud\/#primaryimage"},"thumbnailUrl":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/Capture149.png","articleSection":["Application integration &amp; Middleware","Cloud","Database Administration &amp; Monitoring","Enterprise content management","Oracle"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.dbi-services.com\/blog\/oracle-data-integrator-cloud\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.dbi-services.com\/blog\/oracle-data-integrator-cloud\/","url":"https:\/\/www.dbi-services.com\/blog\/oracle-data-integrator-cloud\/","name":"Oracle Data Integrator Cloud - dbi Blog","isPartOf":{"@id":"https:\/\/www.dbi-services.com\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.dbi-services.com\/blog\/oracle-data-integrator-cloud\/#primaryimage"},"image":{"@id":"https:\/\/www.dbi-services.com\/blog\/oracle-data-integrator-cloud\/#primaryimage"},"thumbnailUrl":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/Capture149.png","datePublished":"2021-03-24T21:31:30+00:00","dateModified":"2023-07-19T14:26:16+00:00","author":{"@id":"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/66ab87129f2d357f09971bc7936a77ee"},"breadcrumb":{"@id":"https:\/\/www.dbi-services.com\/blog\/oracle-data-integrator-cloud\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.dbi-services.com\/blog\/oracle-data-integrator-cloud\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.dbi-services.com\/blog\/oracle-data-integrator-cloud\/#primaryimage","url":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/Capture149.png","contentUrl":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/Capture149.png","width":1100,"height":731},{"@type":"BreadcrumbList","@id":"https:\/\/www.dbi-services.com\/blog\/oracle-data-integrator-cloud\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Accueil","item":"https:\/\/www.dbi-services.com\/blog\/"},{"@type":"ListItem","position":2,"name":"Oracle Data Integrator Cloud"}]},{"@type":"WebSite","@id":"https:\/\/www.dbi-services.com\/blog\/#website","url":"https:\/\/www.dbi-services.com\/blog\/","name":"dbi Blog","description":"","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.dbi-services.com\/blog\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Person","@id":"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/66ab87129f2d357f09971bc7936a77ee","name":"Oracle Team","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/secure.gravatar.com\/avatar\/f711f7cd2c9b09bf2627133755b569fb5be0694810cfd33033bdd095fedba86d?s=96&d=mm&r=g","url":"https:\/\/secure.gravatar.com\/avatar\/f711f7cd2c9b09bf2627133755b569fb5be0694810cfd33033bdd095fedba86d?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/f711f7cd2c9b09bf2627133755b569fb5be0694810cfd33033bdd095fedba86d?s=96&d=mm&r=g","caption":"Oracle Team"},"url":"https:\/\/www.dbi-services.com\/blog\/author\/oracle-team\/"}]}},"_links":{"self":[{"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/posts\/15971","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/users\/27"}],"replies":[{"embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/comments?post=15971"}],"version-history":[{"count":1,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/posts\/15971\/revisions"}],"predecessor-version":[{"id":26855,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/posts\/15971\/revisions\/26855"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/media\/15978"}],"wp:attachment":[{"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/media?parent=15971"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/categories?post=15971"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/tags?post=15971"},{"taxonomy":"type","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/type_dbi?post=15971"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}