How and where to start ODI

How and where to start ODI:

Today you wont get that much excitement as I am not going to write anything new. The reason being I have got so many mails from people, those are new to ODI World, specifically those are coming from testing background or people from outside Data Warehouse world that they do not have much insight about ODI. How to use where to use and when to use. I feel happy that they are very open and do not hesitate to ask even silly question though they are experienced. Today I will try my best to give you some heads up to get you started. If you know any of the below step then you can jump to the next one. Dont expect you will get everything in one day just by reading. Patience and practice makes you perfect.

#1. Make sure you know what is data warehouse and different types of system. Always remember the 1st image in this link.
http://en.wikipedia.org/wiki/Data_warehouse

#2. What is ETL and what are the ETL tools available in market.

http://en.wikipedia.org/wiki/Extract,_transform,_load

#3. What are the reporting tools available in market.

http://en.wikipedia.org/wiki/List_of_reporting_software

#4. What is the different between ETL and ELT

https://www.ironsidegroup.com/2015/03/01/etl-vs-elt-whats-the-big-difference/

#5. Make sure you know any of the RDBMS. For example Oracle.

http://www.w3schools.com/sql/
http://www.tutorialspoint.com/sql/

#6.Introduction to ODI.
http://docs.oracle.com/cd/E21764_01/integrate.1111/e12643/intro.htm#ODIDG112

#7. JDK is an important part of ODI.

http://dwteam.in/how-to-setup-jdk-path-in-windows-7/

#8.Downloading and Installing ODI

http://docs.oracle.com/cd/E28280_01/install.1111/e16453/install.htm#ODING124
http://dwteam.in/odi-11-1-1-6-installation-on-windows-server-2008-64-bit/
http://dwteam.in/odi-12-c-installation-steps/

#9. What is repository in ODI and its types.

http://docs.oracle.com/cd/E21764_01/integrate.1111/e12643/admin_reps.htm#ODIDG154

#10.Creating repositories for ODI

http://www.oracle.com/webfolder/technetwork/tutorials/obe/fmw/odi/odi_11g/odi_master_work_repos/odi_master_work_repos.htm
http://dwteam.in/creating-repositories-in-odi-11-1-1-5/

#11. Load data from table to table in ODI

http://odibeginnertutorials.blogspot.in/2013/11/odi-helloworld-tutorial-odi-interface.html

#12. Visit again #6 to  recall about TOPOLOGY, DATA SERVER, PHYSICAL SCHEMA, LOGICAL SCHEMA, DESIGNER, INTERFACE, KNOWLEDGE MODULE, OPERATOR, SECURITY

#13.Load from table to flat file in ODI

http://www.oracle.com/webfolder/technetwork/tutorials/obe/fmw/odi/odi_11g/odi_project_table-to-flatfile/odi_project_table-to-flatfile.htm

#14. Load data from flat file to table in ODI

http://www.oracle.com/webfolder/technetwork/tutorials/obe/fmw/odi/odi_11g/odi_project_flatfile-to-table/odi_project_flatfile-to-table.htm

#15. Load data from flat file to flat file in ODI

http://www.oracle.com/webfolder/technetwork/tutorials/obe/fmw/odi/odi_11g/odi_project_ff-to-ff/odi_project_flatfile-to-flatfile.htm

 

Thats it. If you have completed all the steps in your system then congratulation!! 🙂 . You are ready to start with advance stuff in ODI. It wont make you a master but enough to get you started with ODI. Need instant help if you are stuck?? No Problem. Here is the OTN Forum link where you can post your questions. Last but not the least I am always here to help you out.

Cheers!!

About Bhabani 86 Articles
Bhabani has 10 plus years of experience in Data warehousing and Analytics projects that has span across multiple domains like Travel, Banking and Financial, Betting and Gaming Industries. Solution areas he focuses on designing the data warehouse and integrating it with cloud platforms like AWS or GCP. He is also a Elite level contributor at OTN forum more than 9 years. He loves to do experiment and POC on different integration tools and services. Some of his favorite skills are Redshift, Big Query, Python, Apache Airflow, Kafka, HDFS, Map Reduce ,HIVE, Habse, Sqoop, Drill, Impala.

5 Comments

  1. Hi,
    Does ODI 10.1.3.5 supports SQL server 2012?
    If so which is sjdbc/java version need to use?
    thanks for your help!
    Syamjith

  2. I have Installed ODI software and ODI studio in my lap, also I created master and work repository. I have done with ODI studio login. Can I install only ODI studio alone in another machine and access it with a same login which I have created in my lap. If possible please help me on doing this

    • You can Gopinath. ODI studio act as client to the repository. So you can keep the repository anywhere in the world if latency is not a big factor. Cheers!!

  3. Hi ,

    I am not able to see all ODI posts like earlier.
    Previously there use to be a drop down on right of screen with dates and we could drill down to the number of ODI posts .
    I am not able to see it now.
    Please help, they were really good, please don’t remove it.

Leave a Reply

Your email address will not be published.


*