ODI 12c - Getting up and running fast

Posted by David Allan on Oracle Blogs See other posts from Oracle Blogs or by David Allan
Published on Tue, 22 Oct 2013 17:26:00 +0000 Indexed on 2013/10/22 21:59 UTC
Read the original article Hit count: 422

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!

© Oracle Blogs or respective owner

Related posts about /ODI Technical Feature Overviews