ODI 12c - Getting up and running fast
- by David Allan
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!
