Drivers Location In Odi 12c Tutorials

Posted on  by 
  1. Configuring JDBC driver and creating connection. In this document, I will try to explain how to install JDBC drivers in BusinessObjects and how to create a connection. Step 1: Download the jdbc drivers of the database you are trying to connect which could be Oracle, Teradata, MS SQL,and etc.
  2. ODI 12 C Installation Steps: Hello ODI Lovers!! Its time to install ODI 12 C version. Since Oracle announced Oracle Data Integrator 12c, I was really struggling to get some free time to evaluate the newest version. I would say its another milestone for Oracle.
  3. ODI 12c Tutorial ODI 12c Tutorial. ODI 12c Tutorials 2 Repository Creation using RCU Utility Creating Master and Work Repository in ODI 12c using RCU Utility. Location: United States.
  4. How to Understand and Diagnose ODI Connectivity Issues. How to Understand and Diagnose ODI Connectivity Issues. That the different systems must execute. For ODI 11.1.1.x the drivers for the standalone agents will be under the /drivers directory under the agent installation folder. ODI also ships with DataDirect JDBC drivers.

Getting Started

12c (12.2.1.2.0)

E77161-01

Hi ODI 11g experts. Hi ODI 11g experts I need to add a JDBC driver to my installation (I host my repositories on DB2 UDB). Could someone tell me where to add new JDBC driver.jar files (under ODI 10 it was under oracledi/drivers/., does not seem to be the case any more).

September 2016

This document provides instructions on how to install the Oracle Data Integrator (ODI) 12c Getting Started Virtual Machine (VM). The VM is intended to be used with this guide. For more information about the Getting Started Guide, please visit: http://www.oracle.com/technetwork/middleware/data-integrator/overview/index.html

1 Oracle Data Integrator Getting Started

This document contains information on installing and configuring a Virtual Machine for use with Oracle Data Integrator. It includes the following sections:

1.1 Introduction

Oracle Data Integrator (ODI) Enterprise Edition 12c delivers unique next-generation, Extract Load and Transform (E-LT) technology that improves performance, and 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 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, and others), ease-of-use and productivity.

1.1.1 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. It is used to provide a complete environment for learning and demonstrating key Oracle Data Integration technologies.

The virtual machine includes the following products:

  • Oracle Database 11g Enterprise Edition (11.2.0.4)

  • JVM 1.7.0_15

  • Oracle Data Integrator (12.2.1.0.0)

  • Oracle GoldenGate (12.1.2.0.0)

1.1.2 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. In this document, the terms VM (Virtual Machine) and appliance are synonymous.

1.1.2.1 Oracle VirtualBox Introduction

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 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. 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.

For more information, see https://www.virtualbox.org/manual/ch01.html

1.2 Installation and Configuration

This section details the steps necessary to install and configure VirtualBox.

1.2.1 Download VirtualBox Software and User Manual

Go to the following URL to download the appropriate VirtualBox binary and documentation:

Figure 1 Oracle VirtualBox Download


Description of 'Figure 1 Oracle VirtualBox Download'

To install the VirtualBox software, click the link for the appropriate platform (such as Windows hosts), and you will be guided to install the software.

1.2.2 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 through a VirtualBox appliance import.

Here is an example using 7-Zip to extract the VM (only need to extract the first 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


    Description of 'Figure 2 Extracting the VirtualBox Archive'

  2. Select a target directory for the VirtualBox appliance:

    Figure 3 Extraction location


    Description of 'Figure 3 Extraction location'

    The extracted VirtualBox appliance import will be created in the designated directory.

1.2.2.1 Import the Appliance into VirtualBox

  1. Start Oracle VM VirtualBox Manager

  2. Click File and then Import Appliance.

    The Appliance Import Wizard window appears.

    Figure 4 VirtualBox Import


    Description of 'Figure 4 VirtualBox Import'

  3. Click Open Appliance.

  4. Specify the OVA file location and click Open to choose the VirtualBox file.

    Figure 5 VirtualBox Import Selection


    Description of 'Figure 5 VirtualBox Import Selection'

  5. Confirm the file selection and click Next.

  6. Confirm the Appliance (VM) settings and click Import.

    Figure 6 Appliance (VM) settings


    Description of 'Figure 6 Appliance (VM) settings'

  7. Click 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

    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.

1.2.3 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 VirtualBox, see the VirtualBox documentation:

To continue to customize settings for the appliance, highlight the ODI 12c Getting Started appliance and click the Settings icon in the menu bar.

1.2.3.1 Memory (Optional)

The recommended amount of memory for the VirtualBox is 4GB.

Note:

In situations 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 memory settings in the unix appliance itself. Use the following command to 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 System.

1.2.3.2 Shared Folders (Optional)

Shared Folders may be used to move files between the host operating system and the VirtualBox Appliance (for example, moving future ODI projects into the appliance). The project could potentially be another ODI tutorial, which is delivered as a separately downloadable ODI Smart Import.

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.

Best Practice:

Use the same string for the share name and folder names, for example ODIshared.

To configure a shared folder:

  1. Click the Shared Folders shortcut on the left panel.

  2. Click the Add Folder icon on the right:

    Figure 7 Configuring Shared Folders


    Description of 'Figure 7 Configuring Shared Folders'

  3. The Add Share dialog appears, select Other… for the Folder Path and the following options.

    Figure 8 Shared Folder Options


    Description of 'Figure 8 Shared Folder Options'

    In this example, the following values are used:

    • Folder Path:C:ODIshared

    • Folder Name:ODIshared

    • Auto-mount: checked

    Figure 9 Using ODIshared as the local folder and share name


    Description of 'Figure 9 Using ODIshared as the local folder and share name'

  4. The Vitural Box share has been configured. You must create a directory in the ODI Getting Started Appliance (VM).

    Note:

    Log on instructions to the Appliance (VM) are available in Table 2, 'Appliance Credentials'.

    • Start the ODI Getting Started VM.

    • In the VM, open a terminal window.

    • su to super user (root) – password oracle

    • Create the directory, for example: $ 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

      Figure 10 Creating a directory


      Description of 'Figure 10 Creating a directory'

  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 somewhere

    The mount for the ODI Getting Started Appliance and the example in this document would be:

    $ mount -t vboxsf ODIshared ODIshared

The shared folder is now available between the host operating system and the ODI Getting Started vitural box appliance.

1.3 Starting the ODI Getting Started Appliance

To start the appliance from within the Oracle VirtualBox client, do ONE of the following:

  • Double-click on the ODI 12c Getting Started entry in the list within the Manager window.

    OR

  • Select its entry in the list in the Manager window and click Start.

Once started, the appliance will boot into Oracle Linux and the desktop will be displayed.

1.3.1 Beginning the Getting Started Tutorial

The Getting Started appliance desktop includes the objects detailed in Table 1, 'ODI Getting Started 12c Desktop Objects'.

Table 1 ODI Getting Started 12c Desktop Objects

ObjectPurpose

ODI 12c Getting Started

This document provides the introduction and exercises to drive the tutorial. Open this first.

ODI 12c Studio

Double-click this launcher to start ODI Studio. The ODI Studio will load; multiple clicks may result in more than one Studio loading.

ORACLE_HOME

A shortcut to the default user's directory.

Demo

A shortcut to the demo directory located in ODI_HOME.

/home/oracle/Oracle/Middleware/Oracle_Home_1221/odi/demo

The directory structure and objects are defined in the Getting Started guide. For the purpose of running the tutorial from the Appliance, you should not need to open this directory.

Information about this machine

A text file listing basic attributes of the machine.


  1. To begin with the ODI Getting Started Tutorial, open the ODI 12c Getting Started Guide on the desktop and follow the self-paced instructions.

  2. Start ODI Studio using the desktop launcher.

    Figure 11 ODI Studio Desktop Launcher


    Description of 'Figure 11 ODI Studio Desktop Launcher'

Note:

The startup script for ODI may alternatively be found in:

/home/oracle/Oracle/Middleware/Oracle_Home_1221/odi/studio/bin/odi.sh

The ODI 12c Getting Started Appliance and tutorial is now ready to be used!

1.4 Reference

Table 2 Appliance Credentials

ApplianceCredentials

Appliance LinuxOS

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

Tags: Air Bull FSX Race Red red bull air race. You may also like. Spider-Man: Homecoming. September 7, 2018. SPEED BOAT BY: Rodel. November 4, 2018. CHUCK 1×2 REACTION “Chuck Versus the Helicopter” Episode 2 Reaction; The World’s Most Dangerous Downhill Ski Race| Streif: One Hell Of a Ride. RAF EH-101 Helicopter. FSX RAF EH-101 Helicopter. Red Bull aerobatic helicopter pilot leaves 'airshow circus.' Chuck Aaron Announces Retirement. Red Bull aerobatic helicopter pilot leaves 'airshow circus.' Red Bull Hangar-7 GmbH. The Sukhoi is a unique aerobatic aircraft. This helicopter of the Flying Bulls is a little bit out of the ordinary. Fsx red bull helicopter

ODI password: SUPERVISOR


1.5 Learn More

You can learn more about creating your own integration projects with Oracle Data Integrator in the guides listed in Table 3, 'Oracle Data Integrator Documentation'

Table 3 Oracle Data Integrator Documentation

DocumentDescription

Oracle Fusion Middleware Installation Guide for Oracle Data Integrator

Provides Oracle Data Integrator installation information including pre-installation requirements and troubleshooting.

Oracle Fusion Middleware Upgrade Guide for Oracle Data Integrator

Provides 12c upgrade information for Oracle Data Integrator.

Oracle Fusion Middleware Developer's Guide for Oracle Data Integrator

Provides guidelines for developers interested in using Oracle Data Integrator for integration projects.

Oracle Fusion Middleware Connectivity and Knowledge Modules Guide for Oracle Data Integrator

Describes Oracle Data Integrator Knowledge Modules and technologies and how to use them in integration projects.

Oracle Fusion Middleware Knowledge Module Developer's Guide for Oracle Data Integrator

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: 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 choosing Oracle Data Integrator.

2 Documentation Accessibility

For information about Oracle's commitment to accessibility, visit the Oracle Accessibility Program website at http://www.oracle.com/pls/topic/lookup?ctx=acc&id=docacc.

Access to Oracle Support

Oracle customers that have purchased support have access to electronic support through My Oracle Support. For information, visit http://www.oracle.com/pls/topic/lookup?ctx=acc&id=info or visit http://www.oracle.com/pls/topic/lookup?ctx=acc&id=trs if you are hearing impaired.

Oracle Data Integrator Getting Started, 12c (12.2.1.2.0)

E77161-01

Copyright © 2011, 2016, Oracle and/or its affiliates. All rights reserved.

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, then the following notice is applicable:

U.S. GOVERNMENT END USERS: Oracle programs, including any operating system, integrated software, any programs installed on the hardware, and/or documentation, delivered to U.S. Government end users are 'commercial computer software' pursuant to the applicable Federal Acquisition Regulation and agency-specific supplemental regulations. As such, use, duplication, disclosure, modification, and adaptation of the programs, including any operating system, integrated software, any programs installed on the hardware, and/or documentation, shall be subject to license terms and license restrictions applicable to the programs. No other rights are granted to the U.S. Government.

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 registered 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 about 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 unless otherwise set forth in an applicable agreement between you and Oracle. 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, except as set forth in an applicable agreement between you and Oracle.

8i 9i 10g 11g 12c 13c 18c 19c Misc PL/SQL SQL RAC WebLogic Linux

Home » Articles » 12c » Here

This article demonstrates how to perform a silent installation of Oracle Data Integrator (ODI) 12c (12.2.1.3.0) on Oracle Linux 6 and 7 (OL6 and OL7) using Oracle Database 12c Release 1 (12.1) for the repository created by the Repository Creation Utility (RCU).

Related articles.

Assumptions

To keep this article as brief as possible I'm going to make the following assumptions.

Steps
  • You already have a server (Virtual or Physical) with Oracle Linux 6 or 7 (OL6 or OL7) installed (described here OL6 or OL7).
  • The prerequisites for an Oracle Database 12c Release 1 (12.1) installation have been completed (described here OL6 or OL7).
  • You are somewhat familiar with the concept of silent installations (described here).
  • To keep things simple we will install both the database and ODI on a single machine. This is not a recommendation. As a result of this, some of the paths may look a little odd, as it will be a mix of OFA for the database and my typical paths for WebLogic installations.
  • All the software listed below will be placed in the '/u01/software' directory.
  • All the response files listed below are placed in the '/u01/software' directory and adjusted to suite your purposes.

I don't work with ODI, but I do have to provide basic support of some infrastructure that runs it (database and WebLogic).

Downloads

There is a lot of software to download before you can begin. I've purposely not included the latest critical updates.

  • Oracle Database 12c Release 1 (12.1.0.2) (linuxamd64_12102_database_1of2.zip and linuxamd64_12102_database_2of2.zip)
  • JDK8 Update 144 (jdk-8u144-linux-x64.tar.gz)
  • WebLogic Server (fmw_12.2.1.3.0_infrastructure_Disk1_1of1.zip)
  • Oracle Business Intelligence 12c (fmw_12.2.1.3.0_odi_Disk1_1of2.zip and fmw_12.2.1.3.0_odi_Disk1_2of2.zip)

Additional OS Packages

Install the following package for the Fusion Middleware prerequisites to be met. Many of them will already be present because of the database prerequisites.

Database Software Installation

Assuming you have completed all the OS prerequisites for a database installation, you can install the database software as follows.

Unzip the software.

Install the database software in silent mode.

When prompted, run the root scripts.

Database Creation

Start the listener.

Create the database using the Database Creation Assistant (DBCA) in silent mode.

Set minimum parameter levels and make sure the pluggable database starts when the instance starts.

Response Files

The following response files are necessary for the silent installations of ODI shown below. The values we are going to amend during the build are shown in bold.

weblogic.rsp

oraInst.loc

odi.rsp

odi_rcu_paramfile.txt

Prepare Response Files

We have used generic response files containing placeholders for build-specific parameters. Here we will replace the placeholders with the values for our build. If you want to adjust them later, remember to switch back to the original response files before running the commands again.

WebLogic Installation

Set the required environment variables.

Install JDK8.

Create the middleware location.

Unzip the WebLogic software.

Install WebLogic in silent mode.

ODI Installation

Unzip the software.

Install the ODI software in silent mode.

Odi

Repository Configuration Utility (RCU)

Use the following command to run the RCU in silent mode.

ODI Configuration

Create a file called 'create_odi_domain.py' in the '/u01/software' directory with the following contents. This is a generic file that uses placeholders which we will replace later.

Replace the placeholders with the settings we defined earlier.

The following command creates a new ODI domain.

Make sure the 'AdminServer' and 'ODI_Server1' servers can start/stop without credentials by creating 'boot.properties' files.

The installation is now complete, but the agent definition must be created in the Master Repository, which must be done using the ODI Studio GUI tool. This can be done on the server using X, or from your client PC client, connecting to the repository database. The example in the next section is done using X on the server.

ODI Agent Config

Update In Odi 12c Tables

If we started the 'ODI_server1' managed server now we would see the following type of error in the 'ODI_server1.log' file.

We have created the physical agent, but we need to create the agent in the Master Repository using the ODI Studio.

Click the 'Connect to Repository..' link.

Click the '+' button.

Enter the connection information and click the 'Test' button. If successful, click the 'OK' button.

Enter a wallet password and click the 'OK' button.

Oracle Odi 12c Tutorial Pdf

The credentials should now be set, so click the 'OK'.

Click on the 'Topology' tab. Right-click on the 'Agents' node and select the 'New Agent' menu option.

Set the agent name to 'OracleDIAgent', not 'OracleDIAgent1' that may be shown by default. Set the host (ol7-odi.localdomain) host and port (8001) values to be consistent with the physical agent definition in the domain. Click the 'Save All' icon in the top toolbar.

The agent will now be visible in the tree.

Now the agent topology matches the physical agent definition in the domain, we can start the domain components as described below.

Startup/Shutdown

The database is started and stopped in the normal way.

Make sure you have the environment set correctly.

With then environment in place we can start, check the status and stop OBIEE using the following commands.

Check out the log files here.

ODI URLs

Once the domain is running the main URLs you will need on the server are as follows.

  • WebLogic Console : http://ol7-odi.localdomain:7001/console
  • WebLogic Enterprise Manager: http://ol7-odi.localdomain:7001/em
  • ODI Console: http://ol7-odi.localdomain:8001/odiconsole

Domain Cleanup

During the process of working out the WLST build of the domain I had to recreate the domain several times. This is how I cleaned up between attempts.

Oracle Odi 12c Documentation

Now repeat the process from running the RCU onward.

Odi 12c Installation

For more information see:

Drivers Location In Odi 12c Tutorials Free

Hope this helps. Regards Tim..

Coments are closed
Pop Goes Punk 4 Album DownloadEnzymatic Activation Of Alkanes Constraints And Prospects Uk
© 2020 - d8cmb.netlify.com
Scroll to top