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!!

0

About the author

Bhabani(http://dwteam.in) - Currently Bhabani is working as Sr Development Engineer at Harman International. He has good expertise on Oracle, Oracle Data Integrator, Pervasive Data Integrator, MSBI, Talend and Java. He is also contributing in ODI-OTN forum for last 5 years. He is from India. If you want to reach him then please visit contact us page. If you have any doubts or concerns on the above article, please put your question here. Dw Team will try to respond it as soon as possible. Also dont forget to provide your comments / suggestions / feedback for further improvement. Thanks for your time.

Similar Posts

2 comments

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

Hi ODI wont come with SQL Server JDBC drivers. You can download the latest JDBC drover from below link. Regarding the ODI version I dont think there will be any issues.
http://www.microsoft.com/en-in/download/details.aspx?id=11774

Leave a replay to syamjith.sl Cancel reply

required*

Are you a human? *