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
/ODI Technical Feature Overviews
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