ODI 12c Getting Started Virtual Machine Installation Guide
Contents
1. fe Other In this example the following values are used e Folder Path C ODIshared e Folder Name ODIshared e Auto mount checked Figure 14 Using ODIshared as the local folder and share name amp Add Share Folder Path di CAODIshared Folder Name ODIshared L Read only Auto mount 4 The Vitural Box share has been configured A directory is required to be created in the ODI Getting Started Appliance VM Note Logon instructions to the Appliance VM are available further in this document e Start the ODI Getting Started VM e Inthe VM open a terminal window e su to super user root password oracle e Create the directory for example mkdir ODIshared 122 Page ORACLE Getting Started VM Installation Oracle Data Integrator oracle ODIGettingstarted File Edit View Search Terminal Help oracle ODIGettingStarted cd oracle ODIGettingStarted mkdir ODIshared Note Examine the permissions of the directory and modify accordingly As this is a tutorial sharing to all users and groups may be approprite chmod 777 ODIshared 5 To access the shared directory from the Getting Started Appliance a unix mount must be performed from a terminal shell as root mount follows the syntax mount t fstype something somewhare The mount for the ODI Getting Started Appliance and the example in this document would be mount t vboxsf ODIshared ODIshared The shared folder is2. open the ODI 12c Getting Started Guide on the desktop and follow the self paced instructions 2 Start ODI Studio using the desktop launcher a OD 12c Studia Note The startup script for ODI may alternatively be found in u01 Middleware Oracle Home_1213 odi studio odi sh The ODI 12c Getting Started Appliance and tutorial is now ready to be used 14 Page ORACLE Getting Started VM Installation Oracle Data Integrator Appliance Credentials Appliance Linux OS Linux Default user oracle password oracle Su user root password oracle Oracle Product Access Information Oracle RDBMS SID ORCL Port 1521 system user password oracle sys user password oracle ODI repository user prod odi repo password oracle ODI sample data user odi demo password oracle Oracle Data Integrator ODI username SUPERVISOR ODI password SUPERVISOR 15 Page ORACLE Getting Started VM Installation Oracle Data Integrator Learn More You can learn more about creating your own integration projects with Oracle Data Integrator in the guides listed in Table 2 Table 2 Oracle Data Integrator Documentation Document Oracle Fusion Middleware Installation Guide for Oracle Data Integrator Oracle Fusion Middleware Upgrade Guide for Oracle Data Integrator Oracle Fusion Middleware Developer s Guide for Oracle Data Integrator Oracle Fusion Middleware Connectivity and Knowledge Modules Guide for Orac
3. NOT BE TRANSFERRED OR DISTRIBUTED TO OTHER INDIVIDUALS EVEN IF THOSE INDIVIDUALS ARE EMPLOYED BY THE SAME ENTITY IF YOU DID NOT OBTAIN THIS IMAGE FROM AN ORACLE WEBSITE OR FROM AN AUTHORIZED ORACLE EMPLOYEE OR CONTRACTOR YOU MAY NOT USE IT VISIT WWW ORACLE COM OTN TO DOWNLOAD A COPY YOU MAY USE IF YOU RECEIVED THIS VIRTUAL MACHINE IMAGE DIRECTLY FROM ORACLE THEN BY CONTINUING TO INSTALL THE VIRTUAL MACHINE IMAGE YOU AGREE TO THE LICENSE The import is complete and the appliance virtual machine is now available in the VirtualBox Manager The appliance may be started by clicking Start or customized further for your environment Figure 10 Available VirtualBox Appliances O Oracle VM VirtualBox Manager _ File Machine Help New Settings Start Discard ODI Big Data from Dev v2 W Powered Off BigDataLite2 2 0DI Demo PRE ODI 12c Final Release w Powered Off 64 BigDatalite2 2 0DI Demo 120GA i w Powered Off 64 ODI 12c Getting Started Solution Master Dev w Powered Off bah ye ODT 12c Getting Started m Powered Off ODI 12c Getting Started Solution Master Dev Backup W Powered Off PP ek ORACLE Getting Started VM Installation Oracle Data Integrator Customize VirtualBox Appliance Settings Depending on the host operating system limitations network configuration or file sharing requirements VirtualBox appliance settings may be modified For further information about
4. Regulation and agency specific supplemental regulations As such the use duplication disclosure modification and adaptation shall be subject to the restrictions and license terms set forth in the applicable Government contract and to the extent applicable by the terms of the Government contract the additional rights set forth in FAR 52 227 19 Commercial Computer Software License December 2007 Oracle America Inc 500 Oracle Parkway Redwood City CA 94065 This software or hardware is developed for general use in a variety of information management applications It is not developed or intended for use in any inherently dangerous applications including applications that may create a risk of personal injury If you use this software or hardware in dangerous applications then you shall be responsible to take all appropriate fail safe backup redundancy and other measures to ensure its safe use Oracle Corporation and its affiliates disclaim any liability for any damages caused by use of this software or hardware in dangerous applications Oracle and Java are registered trademarks of Oracle and or its affiliates Other names may be trademarks of their respective owners Intel and Intel Xeon are trademarks or registered trademarks of Intel Corporation All SPARC trademarks are used under license and are trademarks or registered trademarks of SPARC International Inc AMD Opteron the AMD logo and the AMD Opteron logo are trademarks or regis
5. choosing Oracle Data Integrator 16 Page ORACLE Getting Started VM Installation Oracle Data Integrator ORACLE ODi12c Getting Started VM Installation Guide December 2014 Oracle Corporation World Headquarters 500 Oracle Parkway Redwood Shores CA 94065 U S A Worldwide Inquiries Phone 1 650 506 7000 Fax 1 650 506 7200 oracle com 17 Page CS Oracle is committed to developing practices and products that help protect the environment Copyright O 2015 Oracle and or its affiliates All rights reserved This document is provided for information purposes only and the contents hereof are subject to change without notice This document is not warranted to be error free nor subject to any other warranties or conditions whether expressed orally or implied in law including implied warranties and conditions of merchantability or fitness for a particular purpose We specifically disclaim any liability with respect to this document and no contractual obligations are formed either directly or indirectly by this document This document may not be reproduced or transmitted in any form or by any means electronic or mechanical for any purpose without our prior written permission Oracle and Java are registered trademarks of Oracle and or its affiliates Other names may be trademarks of their respective owners Intel and Intel Xeon are trademarks or registered trademarks of Intel Corporation All SPARC trademarks are used unde
6. Oracle Fusion Middleware Getting Started with Oracle Data Integrator 12c Virtual Machine Installation Guide December 2014 ORACLE Oracle Fusion Middleware Getting Started with Oracle Data Integrator 12c Copyright 2010 2015 Oracle and or its affiliates All rights reserved Author ODI Product Management This software and related documentation are provided under a license agreement containing restrictions on use and disclosure and are protected by intellectual property laws Except as expressly permitted in your license agreement or allowed by law you may not use copy reproduce translate broadcast modify license transmit distribute exhibit perform publish or display any part in any form or by any means Reverse engineering disassembly or decompilation of this software unless required by law for interoperability is prohibited The information contained herein is subject to change without notice and is not warranted to be error free If you find any errors please report them to us in writing If this is software or related documentation that is delivered to the U S Government or anyone licensing it on behalf of the U S Government the following notice is applicable U S GOVERNMENT RIGHTS Programs software databases and related documentation and technical data delivered to U S Government customers are commercial computer software or commercial technical data pursuant to the applicable Federal Acquisition
7. VirtualBox please review the VirtualBox documentation https www virtualbox org wiki Documentation To continue to customize settings for the appliance highlight the ODI 12c Getting Started appliance and click on the Settings icon in the menu bar as shown on Figure 10 Memory optional The recommended amount of memory for the VirtualBox is 4GB Typically host machines may have 8GB of total memory where 4GB may be ideal Note In situations of where less memory is available on the physical host the memory for the ODI Getting Started appliance may be reduced to 2GB with some additional shared memoty settings in the unix appliance itself The following command will create a shared memory space to enable an Oracle database to start in low memory situations mount t tmpfs shmfs o size 2g dev shm To change the appliance memory setting click on System on the left panel Figure 11 VirtualBox Appliance settings E 48 ODI 12c Getting Started Settings General System E system E Display Motherboard Processor Acceleration Le Storage Base Memory Q 4096 MB P Audio T eae E ea Boot Order 7 B Floppy 7 CD DVD ROM 1 Serial Ports 7 Hard Disk USB P Network E Shared Folders Chipset PIIX3 x Extended Features V Enable IO APIC Enable EFI special OSes only Hardware dock in UTC time Enable absolute pointing device Select a settings category from the list on th
8. are running Windows Mac Linux or Solaris operating systems Secondly it extends the capabilities of your existing computer so that it can run multiple operating systems inside multiple virtual machines at the same time So for example you can run Windows and Linux on your Mac run Windows Server 2008 on your Linux server run Linux on your Windows PC and so on all alongside your existing applications You can install and run as many virtual machines as you like the only practical limits are disk space and memory Installation and Configuration Download VirtualBox Software and User Manual Go to the following URL to download the appropriate VirtualBox binary and documentation https www virtualbox org wiki Downloads Figure 1 Oracle VirtualBox Download search Login Preferences Download VirtualBox Here you will find links to VirtualBox binaries and its source code About VirtualBox binaries Screenshots By downloading you agree to the terms and conditions of the respective license Downloads VirtualBox platform packages The binaries are released under the terms of the GPL version 2 Documentation gt VirtualBox 4 2 18 for Windows hosts x86 amd64 VirtualBox 4 2 18 for OS X hosts gt x86 amd64 End user docs VirtualBox 4 2 18 for Linux hosts gt VirtualBox 4 2 18 for Solaris hosts x86 amd64 Technical docs VirtualBox 4 2 18 Oracle VM VirtualBox Extension Pack All supported platforms Support
9. e left hand side and move the mouse over a settings item to get more information x J coa te Shared Folders optional Shared Folders may be used to move files between the host operating system and the VirtualBox Appliance An example may be moving future ODI projects into the appliance The project could potentially be another ODI tutorial which is delivered as a seperately downloadable ODI Smart Import a ee ORACLE Getting Started VM Installation Oracle Data Integrator Use of shared folders begins with defining a locally available directory on your computer host and one on the VirtualBox appliance along with a share name Note A best practice is to use the same string for the share name and folder names for example ODIshared To configure a shared folder 1 Click on Shared Folders shortcut on the left panel 2 Click on the Add Folder icon on the right Figure 12 Configuring Shared Folders 8 ODI 12c Getting Started Settings 2 Shared Folders Folders List Name Path Auto Mount Access Fr Machine Folders Shared Folders Adds a new shared folder definition 3 The Add Share dialog appears select Other for the Folder Path and the following options REAd ORACLE Getting Started VM Installation Oracle Data Integrator Figure 13 Shared Folder Options amp Add Share Folder Path lt notselected gt not selected gt Folder Name
10. for USB 2 0 devices VirtualBox RDP and PXE boot for Intel cards See this chapter from the User Manual for an introduction to this Extension Pack Community The Extension Pack binaries are released under the VirtualBox Personal Use and Evaluation License PUEL Please install the extension pack with the same version as your installed version of VirtualBox Contribute If you are using VirtualBox 4 1 28 please download the extension pack here If you are using VirtualBox 4 0 20 please download the extension pack here VirtualBox 4 2 18 Software Developer Kit SDK All platforms See the changelog for what has changed You might want to compare the e gt SHA256 checksums or the e gt MDS5 checksums to verify the integrity of downloaded packages The SHA256 checksums should be favored as the MDS algorithm must be treated as insecure Note After upgrading VirtualBox it is recommended to upgrade the guest additions as well LEE ORACLE Getting Started VM Installation Oracle Data Integrator To install the VirtualBox software simply click on the link for the appropriate platform i e Windows hosts and you will be guided to install the software Extract the VirtualBox VM After downloading the archive files extract the first archive file for example using 7 Zip The remaining archive files will automatically unzip The extracted file ODI 12c Getting Started ova will be used to create the virtual machine thr
11. le Data Integrator Oracle Fusion Middleware Knowledge Module Developer s Guide for Oracle Data Integrator Description Provides Oracle Data Integrator installation information including pre installation requirements and troubleshooting Provides 12c upgrade information for Oracle Data Integrator Provides guidelines for developers interested in using Oracle Data Integrator for integration projecis Describes Oracle Data Integrator Knowledge Modules and technologies and how to use them in integration projecis Describes how to develop your own Knowledge Modules for Oracle Data Integrator You can find all Oracle Data Integrator documentation on the Oracle Data Integrator documentation page on the Oracle Technology Network at http www oracle com technetwork middleware data integrator documentation index html The Oracle Data Integrator home page on the Oracle Technology Network also provides the following resources to learn more about other features of Oracle Data Integrator e View the Oracle by Example Series for ODI The Oracle by Example OBE series provides step by step instructions on how to perform a variety of tasks using Oracle Data Integrator Suite To learn more about the new features that have been introduced in Oracle Data Integrator 12c see What s New in Oracle Data Integrator in the Oracle Fusion Middleware Developer s Guide for Oracle Data Integrator and the Release Notes Thank you for
12. nn 15 ADDHARC SUN OS sineira te nT a ene 15 Oracle ProductAccess Information ins E En E AE 15 L AVION Chi LUS reis as aa tire a Rc a AE EEE E arated ae ine a oc 16 Getting Started VM Installation Oracle Data Integrator Document Scope The following document provides instruction to install the Oracle Data Integrator ODI 12c Getting Started Virtual Machine VM The VM is intended to be used with the ODI 12c Getting Started Guide For more information about the Getting Started Guide please visit http www oracle com technetwork middleware data integrator overview index html Introduction Oracle Data Integrator Oracle Data Integrator ODI Enterprise Edition 12c delivers unique next generation Extract Load and Transform E LT technology that improves performance reduces data integration costs even across heterogeneous systems Unlike conventional ETL tools Oracle Data Integrator EE offers the productivity of a declarative design approach as well as the benefits of an active integration platform for seamless batch and real time integration In addition hot pluggable Knowledge Modules provide modularity flexibility and extensibility ODI addresses multiple enterprise data integration needs including Data Warehousing and Business Intelligence Service Oriented Architecture Master Data Management MDM Migration and Consolidations Modernization Initiatives The demonstration highlights how ODI can be
13. now available between the host operating system and the ODI Getting Started vitural box appliance Starting the ODI Getting Started Appliance To start the appliance from within the Oracle VirtualBox client e Double click on the ODI 12c Getting Started entry in the list within the Manager window or e Select its entry in the list in the Manager window and press the Start button at the top Once started the appliance will boot into Oracle Linux and the desktop will be displayed eae ORACLE Getting Started VM Installation Oracle Data Integrator Beginning the Getting Started Tutorial The Getting Started appliance desktop holds five key objects to begin Table 1 ODI Getting Started 12c Desktop Objects Object ODI 12c Getting Started Guide pdf ODI 12c Studio Oracle s Home Information about this machine Purpose This document provides the introduction and exercises to drive the tutorial Open this first Check the ODI OTN Overview page for updates to the document in the future and additional tutorial information http www oracle com technetwork middleware data integrator overview index html Double click this launcher to start ODI Studio Provide some time for the studio to load multiple clicks may result in more than one Studio load and further time A shortcut to the default user s directory A text file listing basic attributes of the machine 1 To begin with the ODI Getting Started Tutorial
14. ough a VirtualBox appliance import Following is an example on using 7 Zip to extract the VM only need to extract the 1 file 1 From windows explorer select the first file of the archive and right click to select the extraction tool such as 7 Zip Figure 2 Extracting the VirtualBox Archive ODI 12c Getting Started z 001 4 11 2014 12 01 PM 001 File 2 097 152 KB ODI 12c Getting Starte Open 2 097 152 KB _ ODI 12c Getting Starte 7 Zip Open archive _ ODI12c Getting Starte a Edit with Notepad Extract files N ODI 12c Getting Starte idiot Hine Extract to ODI 12c Getting Started Test archive Scan for threats Scan with Malwarebytes Anti Malware Restore previous versions Add to archive send to Compress and email Cut Add to ODI 12c Getting Started z 001 z Copy Compress to ODI 12c Getting Started z 001 z and email Add to ODI 12c Getting Started z 001 zip Create shortcut Compress to ODI 12c Getting Started z 001 zip and email Delete Rename Properties TT UE a mu 2 Select a target directory for the VirtualBox appliance Figure 3 Extraction location Extract m Sm C VMImage ODI 12c Getting Started Path mode Overante mode Show Password The extracted VirtualBox appliance import will be created in the designated directory 6 Page ORACLE Getting Started VM Installation Oracle Data Integrator Figure 4 ODI 12c Vir
15. r license and are trademarks or registered trademarks of SPARC International Inc AMD Opteron the AMD logo and the AMD Opteron logo are trademarks or registered trademarks of Advanced Micro Devices UNIX is a registered trademark of The Open Group 0612 Hardware and Software Engineered to Work Together ORACLE
16. tered trademarks of Advanced Micro Devices UNIX is a registered trademark of The Open Group This software or hardware and documentation may provide access to or information on content products and services from third parties Oracle Corporation and its affiliates are not responsible for and expressly disclaim all warranties of any kind with respect to third party content products and services Oracle Corporation and its affiliates will not be responsible for any loss costs or damages incurred due to your access to or use of third party content products or services Table of Contents DOCUMENT SCO DE isso do si aa ada cad a add Deda dita 4 IM FOAUETIONES ARR e E a Sd a St dE A Ta 4 Oracle Data Ale BAR sited ts san SS a gp leases 4 Oracle Data Integrator Getting Started Virtual Machine ss 4 Technical D DIO IMG Estagio a Un DS Dn ga aeons 5 Oracle VirtualBox INtrOdUCHON iai SG aa 5 Installation ana Configuratio asd SSIS SS DA O MN Rte 5 Download VirtualBox Software and User Manual 5 Extract ne VirtualBox VIVI saias nad Me a a E a nba 6 import the Applhance into VirtualBox ste ie das dd O ao ia re ete en 7 Customize VirtualBox Appliance Settiness san a a tn Mu 10 Memor Optional Es ARE RSS Re E M nt in 10 Shared Folders OPONA aire attestent ane inc ee sa 10 Starting the ODI Getting Started ApplhantE sisisi nn entente 13 Beginning the Getting Started Tutorial iss sn RE S S ini eine tue 14 Appliance credentials sr sien RS NN SN ere
17. ting Started oval 6 Confirm the Appliance VM settings and click on Import Figure 8 Appliance VM settings a Import Virtual Appliance Appliance settings These are the virtual machines contained in the appliance and the suggested settings of the imported VirtualBox machines You can change many of the properties shown by double Clicking on the items and disable others using the check boxes below Description Configuration ODI 12c Getting Started Oracle Data Integrator Product URL http www oracle com technetwork mi Vendor Oracle Vendor URL http waw oracle com Description THIS VIRTUAL MACHINE APPLIANCE HA Reinitialize the MAC address of all network cards 8 Page ORACLE Getting Started VM Installation Oracle Data Integrator 7 Click on Agree in the Software License Agreement window to start the import process The license terms are available at http www oracle com technetwork licenses odi vm license 2035237 html Figure 9 Software License Agreement screen ns 9 Software License Agreement The virtual system ODI 12c Getting Started requires that you agree to the terms and conditions of the software license agreement shown below Click Agree to continue or dick Disagree to cancel the import WARNING THIS VIRTUAL MACHINE IMAGE CONTAINS T ORACLE PROPRIETARY SOFTWARE THAT IS LICENSED TO THE INDIVIDUAL THAT ORIGINALLY cida IT FROM ORACLE IT MAY
18. tualBox Import name Name Date modified s ODI 12c Getting Started ova 4 11 2014 11 17 AM Import the Appliance into VirtualBox 1 Start Oracle VM VirtualBox Manager 2 Click on File and then Import Appliance Figure 5 VirtualBox Import E ng Oracle VM VirtualBox Manager 7 Machine Help Virtual Media Manager Ctrl D A Import Appliance Ctrl I f Export Appliance Ctrl E amp Preferences Ctrl G y Em Ctrl Q The Appliance Import Wizard window appears 3 Click Open Appliance Type Size Open Virtualizatio 8 371 789 KE 4 Specify the OVA file location and click Open to choose the VirtualBox file Figure 6 VirtualBox Import Selection F ng Please choose a virtual appliance file to import ET z Ei Recent Places E Name di Dropbox ng ODI 12c Getting Started ova EE Desktop Libraries B Documents a Music Es Pictures BE Videos JB JTESTUT j Computer System C cow Data D B OneTouch 4 E lex Filename ODI12c Getting Started ova 7 Page ORACLE Getting Started VM Installation Oracle Data Integrator 5 Confirm the file selection and click Next Figure 7 Appliance VM confirmation Import Virtual Appliance Appliance to import VirtualBox currently supports importing appliances saved in the Open Virtualization Format OVF To continue select the file to import below D WMs Source OTN GS VM ODI 12c Get
19. used to populate a Data Warehouse schema Several facts and dimensions are loaded to demonstrate key ETL capabilities complex transformations slowly changing dimensions incremental updates constraints checking etc ease of use and productivity Oracle Data Integrator Getting Started Virtual Machine The virtual machine entitled ODI 12c Getting Started is a stand alone environment for running Oracle Data Integration products The purpose is to provide a complete environment for learning and demonstrating key Oracle Data Integration technologies The virtual machine includes the following products e Oracle Database 11g Enterprise Edition 11 2 0 4 e JVM 1 7 0_15 e Oracle Data Integrator 12 1 3 0 0 e Oracle GoldenGate 12 1 2 0 0 4 Page ORACLE Getting Started VM Installation Oracle Data Integrator Technical Deployment The ODI virtual machine is delivered as an Oracle VirtualBox appliance and requires both the ODI 12c Getting Started archive and an installation of the Oracle VirtualBox product Further reference to the terms VM Virtual Machine and appliance in this document are synonymous Following are instructions to continue with the installation and configuration Oracle VirtualBox Introduction https www virtualbox org manual ch01 html VirtualBox is a cross platform virtualization application What does that mean For one thing it installs on your existing Intel or AMD based computers whether they
Download Pdf Manuals
Related Search