MM012 – Oracle Data Integrator autoinstallation with Vagrant

Our journey into quick & ready labs continue, last time we set up Oracle 19c with Vagrant. This time we want to prototype quickly a Datamart using ODI as data integration tool.

Oracle Data Integrator ( ODI ) is a powerfull data integration and tranformation Extract – Load – Transform ( ELT ) tool. With his knowledge modules architecture, ODI is the best friend of data architects and data engeneers.

Because we already had our DB 19c virtual machine ready, this time we just prepared a new Centos virtual machine with an ODI installation.

As usually, we just need:

• a personal computer
• Virtualbox ( https://www.virtualbox.org/ )
• Vagrant ( https://www.vagrantup.com/ )

the components need to be installed in this order.

Setup:

1. Create a Oracle DB 19 virtual machine ( if you dont have one, we suggest you to read our previous article )
2. Clone our git repo: git clone https://github.com/GrazianoFracasso/vagrant-oracle19c
3. From Oracle OTN website download:
   1. The java JDK ( jdk-8u171-linux-x64 )
   2. ODI files from Oracle eDelivery ( V886451-01_1of2
      .zip , V886451-01_2of2.zip )
4. Check the environment file parameters ( odi.env.list and db.env.list )
5. Copy the downloaded files into the git clone directory and run: vagrant up
   1. In the first run, the script is going to install everyting is needed with you. We suggest to have a good and stable internet connection before launching it.
6. Ok! Let’s play with ODI!
7. As usually you can shutdown your VM with vagrant halt and you can start up it again with vagrant up.
8. For detailed installation procedures or notes, please refer to the git readme

Default Connection Details:

• Database connection string: 192.168.50.4:1521/ORCLPDB1
• RCU Prefix: LAB
• Database sys password: oracle
• Database schema password: oracle
• ODI Host Name: 192.168.50.6
• Supervisor Password: SUPERVISOR
• Work Repository name: WORKREP
• Work Repository password: oracle

Clean, fast and easy! In the next articles let’s deep dive into Oracle Data Integrator features! Please follow us on linkedin and stay tuned!

Enjoy!