Creating and connecting "Work Repository" for ODI

This is in continuation to my earlier BLOG. We have created a Master Repository for ODI and ODI also needs a Work Repository which is a data structure that contains the data models, projects.

The following are the steps to create a Work Repository

1. Connect to the Master Repository that we created earlier.








2. Open the Repositories View by clicking on Windows -> Show View -> Repositories










3. Right Click on Work Repositories and Click Insert Work Repository













4. In the connection window, complete the following parameters:

Name: Type the name for your work repository connection.Eg:ODIWorkRepository
Technology: Choose the technology of the server to host your work repository. I
have selected Oracle since my database is Oracle
User: User id of the owner of the tables you are going to create and host the work
repository.
Password: The above user's password.


















5. In the JDBC TAB provode the following details :

JDBC Driver: The driver required for the connection to the DBMS to host the work repository.

URL JDBC: The complete path of the data server to host the work
repository.









6. Click on Test. You must not click O.K without testing the connection

7. Now Click on OK to validate the parameters for connecting with the server to host our work repository. A window appears, asking you to give a unique name and user id code number to the repository.

8. In the window Work Repository, complete the following parameters:
ID: Give a unique number to your repository, from 1 to 998 included
Name: Give a unique name to your work repository eg: ODIWORKREPOSITORY
Type: Choose "Designer" in the list.

9. Validate by clicking on OK. The creation of the work repository begins and just
follow the different steps on the console

10. When the work repository has been created, the Work Repository window closes.

Connecting to Work Repository

The Work repository may be accessed through the modules Designer and Operator

1. In the Start Menu, select Programs > Oracle Data Integrator > Designer, or launch
the Designer script (bin/designer.bat or bin/designer.sh)
2. Click on the button New (first button to the right of the field Login name).
3. Complete the following values for Oracle Data Integrator Connection:

Login name: A generic alias Eg: ODIRepository)
User: SUPERVISOR (in capitals)
Password: SUNOPSIS (in capitals)

In the Database Connection(Master Repository)section, provide the following information:

User: User for the Master Repository
Password: This user's password.
List of drivers: The driver required to connect to the DBMS hosting the master
repository we have created now.
URL: The complete path for the data server hosting the master repository.

In the Work Repository section provide the following information:


Work repository name: The name of the work repository that we created. We can select the repository by clicking on the icon to the right side

4. Click on Test to check that the connection is working.
5. Click OK, OK. The module Designer opens

Creating and connecting ODI Modular Repositories

This is in continuation to my earlier BLOG "Installing ODI". In here I am summarizing details about ODI Modular Repositories and illustrating the steps needed for creating the ODI Repositories. These repositories must be created in order to use ODI engine.

The modular Repository for ODI is made up of a Master Repository and of one or several WorkRepositories. These repositories can be installed on any database engine that supports ANSIISO 89 syntax.

I have created these repositories on Oracle 11g Database

Creating Master Repository

1. Create a database user for Master Repository

For Example:
SQL>create user snpm identified by snpm
default tablespace system temporary tablespace temp;
SQL> grant connect, resource to snpm;

2. Click on repcreate.bat file under bin directory of ODI install root eg: C:\ODI\oracledi\bin and provide the following values and Test connect to make sure that the connection is successful, Select Technology as Oracle





3. It invokes Master Repository creation wizard window


















4. Click on the ellipsis button for Driver and select Oracle JDBG Driver from the dropdown list of names under Name













5. Update other parameters in the window like URL. The URL syntax can be got by clicking the ellipsis button for URL. After you get the sysntax update the values appropriately, provide values for user, password which are the values that you gave while creating the user for Master Repository. Change the ID default value, Select Technology as Oracle.(I have done this since my database is Oracle). Click Test Connection button for successfull connection and Click O.K

6. This brings up an Oracle Data Integrator Information window indicating successfull creation of the Master Repository. Click OK

Connect to the Master Repository

1. Launch Topology Manager from the Start Menu



2. Click on New button and provide values for Login Name which may be any name, User: SUPERVISOR (use capitals), Password: SUNOPSIS (use capitals)

3. In the Database Connection (Master Repository) section provide values for the Master Repository username, Password, select your driver name from the Drivers List (I have selected Oracle JDBC Driver). Click on the hand icon to the right side of Driver Name to update this automatically, similarly Click on the hand icon to the right side of Url to update this automatically but you have to provide the values for these parameters.

4. Click Test to validate successfull connection

In the next Posting I will illustrate the steps for creating and connecting "Working Repository" for ODI

ODI Installation on Windows Vista

Off late ODI is expected to be predominantly used for Data transformation needs more specifically to OBI needs. I just wanted to summarize the Oracle recommended system requirements and Prerequistes for installation of ODI and illustrate the steps for installation of ODI

System Requirements

Recommended System Requirements for Data Integrator Client:

512 MB RAM
300 MB Disk space
Operating system with graphical capabilities (such as Microsoft Windows, Linux, HP-UX, or Solaris)
Java Virtual Machine 1.5
Java Development Kit (SDK) 1.5
TCP/IP network

Recommended System Requirements for Data Integrator Agent:

512 MB RAM
200 MB free disk space on your hard drive
Others as for above for Data Integrator Client component

Recommended System Requirements for MetaData Navigator:

512 MB RAM
100 MB free disk space on your hard drive
J2EE 1.4 compliant application server, such as OC4J 10.1.3 and above
Others as for above for Data Integrator Client component

Recommended System disk space for Oracle Data Integrator Repository:

Master --> 30 MB

Working --> 40 MB. It varies depending on the size and volume of models and projects

Recommended System Requirements for Metadata Navigator:

Oracle Data Integrator also requires JDBC / JMS drivers

Oracle Data Integrator uses the JDBC (Java DataBase
Connectivity) standard for databases, JNDI (Java Naming and Directory Interface) and JMS (Java
Message Service) for MOM (Message Oriented Middleware).
Oracle Data Integrator does not include any third-party driver licenses.
Oracle Data Integrator requires the drivers for your different technologies to be installed in the /drivers sub-directory if they are not already referenced in the Java classpath.

Follow these steps to add a new driver for Oracle Data Integrator

1. Copy the driver packages (.zip or .jar files) to the /drivers sub-directory under the Oracle Data Integrator installation folder. Oracle Data Integrator will automatically detect the driver the next time it starts and will add these packages to the classpath. This must be done on each machine executing an Oracle Data Integrator component.
2. If the driver is used to connect a repository and you wish to use Metadata Navigator to connect to this repository, then copy the driver's packages in the /WEB-INF/lib subdirectory of the Metadata Navigator installation folder, then restart the application server.

Download Software

The latest software version ODI 10.1.3.5.0 can be downloaded from http://edelivery.oracle.com

Select Oracle Business Intelligence (10.1.3) Media Pack for Microsoft Windows (32-bit) under Oracle Business Intelligence Product Pack and download Oracle Data Integrator, Oracle Data Profiling, and Oracle Data Quality for Data Integrator 10g (10.1.3.5.0) for Windows Platforms (CD) with Part Number V14803-01

Extract the zipped file to a Folder eg: C:\ODI10.1.3.5.0_SW

Installation Steps

Click on Setup windows batch file located in eg: C:\ODISW\setup\Windows
It invokes the ODI setup through Oracle Universal Installer Window

Select the option button for Oracle Data Integrator 10.1.3.5.0 and click Next
I have selected this as I just wanted to install this component. The default option is setting up all the components of ODI i.e Oracle Data Integrator, Oracle Data Profiling, Oracle Data Quality

Oracle Data Profiling is a component that is used for monitoring and analysing the data quality.

Oracle Data Quality is a component used for Data cleansing

Leave the default option for installation type as Complete which needs 281 MB space.click Next. In case you select all components then the setup needs 1.18 GB of disk space

In this screen you have specify the Oracle Home path. Leave the default values and Click Next. If you need to change you may do that


Select Install
Click Exit after successful installation

Please follow another posting for ODI Modular Repository. It illustrates steps for creating and connecting ODI Modular Repositories