Tuesday Oct 22, 2013

ODI 12c - Getting up and running fast

Here's a quick A-B-C to show you how to quickly get up and running with ODI 12c, from getting the software to creating a repository via wizard or the command line, then installing an agent for running load plans and the like.

A. Get the software from OTN and install studio. Check out this viewlet here for quickly doing this.

B. Create a repository using the RCU, check out this viewlet here which uses the FMW Repository Creation Utility. 

You can also silently create (and drop) a repository using the command line, this is really easy.

  • .\rcu -silent -createRepository -connectString yourhost:1521:orcl.st-users.us.oracle.com -dbUser sys -dbRole sysdba -useSamePasswordForAllSchemaUsers true -schemaPrefix X -component ODI -component IAU  -component IAU_APPEND  -component IAU_VIEWER -component OPSS < passwords.txt

where the passwords file contains info such as;

  • sysdba_passwd
  • newschema_passwd
  • odi_user_passwd
  • D
  • workreposname
  • workrepos_passwd

 You can find details about the silent use of RCU here in the FMW documentation.

C. Quickly create an agent for executing load plans and the like -  there is a great OBE for this, check it out here. If you are on your laptop and just wanting as minimal an agent as possible then this link is a must.

With these three steps you are ready to get to the fun stuff! Check out more OBEs here - keep on the lookout for more!

Thursday Oct 17, 2013

ODI 12c - Installing ODI Studio

Today the 12c release of the Oracle Data Integrator was made GA on OTN. Once you have downloaded and are running the installer, if you want to install the ODI Studio, ensure you select 'Enterprise Installation' as this is where the ODI Studio for 12.1.2 can be installed from. If you choose 'Standalone Installation' you will be hunting for the ODI studio software. So ensure you pick Enterprise Installation to get the ODI design studio.

Once that's done you are ready to go!

Monday Dec 20, 2010

Running ODI 11gR1 Standalone Agent as a Windows Service

[Read More]
About

Learn the latest trends, use cases, product updates, and customer success examples for Oracle's data integration products-- including Oracle Data Integrator, Oracle GoldenGate and Oracle Enterprise Data Quality

Search

Archives
« April 2014
SunMonTueWedThuFriSat
  
2
3
5
6
7
8
9
10
12
13
14
17
18
19
20
21
22
23
24
25
26
27
28
29
30
   
       
Today