ODIExperts.com

The blog for Oracle Data Integrator ( ODI )

July 30, 2010
by kdevendr
1 Comment

Categories: Architecture , How to , Logic , ODI , Tips and Tricks

Tags: ODI , Practice

Best practice of ODI

Some of the best practice,we feel in day to day usage of ODI have been presented below. 1. Provide the Developer SNPS_LOGIN_WORK.XML and SNPS_LOGIN_SECURITY.XML, rather than providing the ODI_MASTER password. This way administrator can stop developer to play with repository … Continue reading →

July 22, 2010
by Cezar Santos
9 Comments

Categories: Administration , Architecture , ODI , Tips and Tricks

Tags: ODI , ODI 11g , ODI Experts , ODI Studio , Oracle Data Integrator , Oracle Data Integrator 11g , Sunopsis

11g Oracle Data Integrator – Part 1/11g – First Screen

Hi Guys! It’s really a pleasure write this post… because Oracle Data Integrator 11g just arrives!!!!!!! Well, I’m not sure if you know but I’m an ODI enthusiastic (Did you notice it? 😀 ) and, because of that, I will tell … Continue reading →

April 12, 2010
by Cezar Santos
21 Comments

Categories: Architecture , How to , Logic , ODI , Tips and Tricks

Tags: file variable ODI , ODI , ODI Experts , ODI variable , Oracle Data Integrator , PL/SQL Procedures , Procedure Step , read files , read unknown file namw , variable from file

Getting one or several unknown files from a directory

Hi Friends… Today I would like to share with you a way that I have been using for several years, to get unknown files from a directory in Oracle Data Integrator. For instance, if you have files in a directory … Continue reading →

April 9, 2010
by Cezar Santos
33 Comments

Categories: Administration , Architecture , How to , ODI , Tips and Tricks

Tags: Java BeanShell , Java Variable , ODI , ODI Adminstration , ODI connection , ODI Experts , ODI Physical Schema , Oracle Data Integrator , parallel , Parallel Execution , Parallel Interface

Interface Parallel Execution – A new solution

Hi Friends, Two days ago Devendra talk to me about parallel executions in ODI and we are discussing the solution from Oracle Metalink that works but, at true, I never was stopped to analyse. In face of that, I decided … Continue reading →

March 28, 2010
by kdevendr
3 Comments

Categories: Administration , Architecture , How to , ODI , Technology , Tips and Tricks

Tags: EWR , Execution Mode , Export , Import , Master Repository , ODI Solution , Scenarion

Export DWR to EWR [ Common Master Rep ]

This post explain the process of Exporting Scenarios from DWR to EWR . As Cezar have suggested in previous post of how it is important to have one single DWR ( Developer Work Repository) and multiple EWR [ Execution Work … Continue reading →

March 14, 2010
by kdevendr
49 Comments

Categories: Architecture , How to , ODI

Tags: Agent , agent scheduling , Load Balancing

Agent

This post describes how to create an single and multiple agent and how to start an scheduler agent and other information. Step 1 – Start the Agent.bat or Agent.sh under oracledi/bin Step 2 – Topology Manager – > Physical Architecture … Continue reading →

November 26, 2009
by kdevendr
1 Comment

Categories: Administration , Architecture , How to , Logic , ODI , Tips and Tricks

Export – Import DWR to EWR having same Master Rep

For this particular Example I am exporting Project, Models and all the other objects under it from ODI_DEV [ DWR ] environment to ODI_WORK_EWR [ EWR ] DWR – Development Work Repository EWR – Execution Work Repository Step 1 – … Continue reading →

November 23, 2009
by kdevendr
2 Comments

Categories: Administration , Architecture , Logic , ODI , Technology , Tips and Tricks

Tags: DWR , Export , Import , Master Repository , Work Repository

Export – Import DWR to DWR having same Master Repository

For this particular Example I am exporting Project, Models and all the other objects under it from ODI_DEV [ DWR ] environment to ODI_TEST [ DWR ] where DWR is Development Work Repository Step 1 – Export the Project Specify … Continue reading →

November 20, 2009
by Cezar Santos
27 Comments

Categories: Architecture , How to , Logic , ODI , Tips and Tricks

Tags: ODI , ODI Adminstration , ODI Agent , ODI connection , ODI Context , ODI Data Server , ODI Experts , ODI Logical Schema , ODI Physical Schema , ODI Procedure , ODI repository , ODI Scenario , ODI Step , ODI variable , Oracle Data Integrator , PL/SQ Functions , PL/SQL Parameters , PL/SQL Procedures , Procedure Step , repositories , repository , Sunopsis , sysdate source

Procedures (or KM) Steps – Source and Target tab’s

Hi All, There is some time that I don’t write a post, it’s because of the amount of work… too much clients, too much process… but all is perfect! I mean, work needs to exists because then it’s necessary people … Continue reading →

October 30, 2009
by Cezar Santos
7 Comments

Categories: Architecture , Common Errors , Logic , ODI , Tips and Tricks

Tags: ODI , ODI Adminstration , ODI connection , ODI Context , ODI Data Server , ODI Experts , ODI Logical Schema , ODI Physical Schema , ODI repository , ODI Scenario , ODI Web Services , Oracle Data Integrator , repositories , repository , Subscribers , Sunopsis

Subscribers – An example of how to use

Hi friends, I was helping in a thread at ODI Forum, from Oracle page (http://forums.oracle.com/forums/forum.jspa?forumID=374) and I decided to describe the situation here once several people ask me similar questions What is a Subscriber and how to use it? A … Continue reading →

Recent Posts ODI Expert and why there is no new posts… Passing Values to ODI Variables in Packages/Scenarios New Author Arriving… ODI Certification – Approved How to Change ODI Language (Idiom) Recent Comments Ignacio Vega on How to create a Temp Table in ODI Interface (Yellow Interface) R. Moreno on Generate Multiple Scenarios saroj kumar pradhan on ODI Expert and why there is no new posts… Raju Mogulapalli on Hide Unused Technologies shanker paloji on Changed Data Capture ( CDC ) Archives February 2016 April 2015 March 2015 February 2014 November 2013 September 2013 December 2011 November 2011 September 2011 August 2011 June 2011 March 2011 February 2011 January 2011 December 2010 November 2010 October 2010 September 2010 August 2010 July 2010 June 2010 April 2010 March 2010 January 2010 December 2009 November 2009 October 2009 September 2009 August 2009 Categories Administration Architecture Common Errors Drivers How to Java Codes Knowledge Modules Logic ODI ODI Bug Others Reports SDK SQL Technology Tips and Tricks Uncategorized Meta Log in Entries feed Comments feed WordPress.org

Recent Jobs ODI Expert and why there is no new posts… Passing Values to ODI Variables in Packages/Scenarios New Author Arriving… ODI Certification – Approved How to Change ODI Language (Idiom) Information about the ODI Certification Exam Finally!!!! The Oracle Data Integrator 11g Certified Implementation Exam!!!!!! Interface with Union, Minus Operator using ODI SDK Export and Importing Scenarios based on Project (or)Folder Creating Interface for Single Source and Target Creating Permanent Interface based on Model Level Automatically add Interfaces/Scenarios to new ODIPackage using ODI SDK Creating Package using SDK Handling the “ORDER BY” clause in an interface Creating Temporary Interface using ODI SDK Creating ODI Procedure using SDK ODI SDK Setup and Config in Eclipse Things to be pride of…. CDC CONSISTENT Ordered SQL Killing session in ODI 11g 11g Oracle Data Integrator – Part 8/11g – Table Partitioning supported Jython Scripts fails to recognize the module during scenario run in ODI 11g Scenarios, a lot in the first delivery makes maintenance very simple! Direct load by interface with no work tables (C$, I$) 11g Oracle Data Integrator – Part 7/11g – SUNOPSIS MEMORY ENGINE 11g Oracle Data Integrator – Part 6/11g – Union , Minus, Intersect Jython’s Beginner Guide for ODI Send SQL by Email Security Module – Main concepts and use Drivers Location in ODI 11g 11g Oracle Data Integrator – Standalone Agent but, and about the Windows Service??? 11g Oracle Data Integrator – Part 5/11g – odiConsole, the new Metada Navigator Using one of ODI’s lesser-known secrets: the Common Format Designer (CFD) – by Craig Stewart 11g Oracle Data Integrator – Part 4/11g – Upgrading from 10g 11g Oracle Data Integrator – Upgrading from 10g – Part 4/11g First year of many…. Thank you Friends! 11g Oracle Data Integrator – Part 3/11g – Graphical User Interface Datatypes – Creating what is missing for any technology IS_NUMBER (and IS_CHAR) at Oracle? A workaround… Calling OdiSqlUnload using ODI Procedure with no hardcoded password SNP_EXP_TXT – A “huge” table problem Internal ID SCD Type 2 11g Oracle Data Integrator – Part 2/11g – Creating Repositories 11g Oracle Data Integrator – Creating Repositories – Part 2/11g Regenerate ODI Objects using OdiGenerateAllScen Generate Column_name Header for OdiSqlUnload Error Records Log Get the Error Message of any Failed ODI objects inside Package SCD TYPE 3 Best practice of ODI 11g Oracle Data Integrator – Part 1/11g – First Screen Automated ODI Export Import Scenarios LKM OdiSqlUnload(File) to Oracle ( SQLLDR ) Jython OS bug in Windows 7 Writing SQL counts using Jython Getting one or several unknown files from a directory Interface Parallel Execution – A new solution Displaying SQL results in Operator Flow Control and Static Control Export DWR to EWR [ Common Master Rep ] Scenario Report Asynchronous -Parallel Execution Dropping $ Tables KM FOR UNION BASED ON IKM SQL CNTRL APPEND Installing ODI in Windows 7 Querying in ODI Changed Data Capture ( CDC ) Agent Manual entry in ODI Driver List MINUS IN ODI Variable Detail Query Interface Mapping Query Topology Connection Detail Versioning Get File Length and Header in Operator Find the Value of the Variable in Operator ? Invisible Join Shortcuts Keys Export – Import DWR to EWR having same Master Rep Categorize Scenarios Alignment of objects in Package Duplicate Multiple Objects in Package Smart Search Export – Import DWR to DWR having same Master Repository Procedures (or KM) Steps – Source and Target tab’s Subscribers – An example of how to use Why Creating a separate schema in ODI? How to show Business Messages on Operator and, too, debug variables… Topology – Data Server – Which user should be used to connect? How to use PL/SQL procedures and functions in ODI Context, Logical And Physical Schema – How does it work? Repository Architecture – Work Repository, Development or Execution? When and why uses each one. Removing Special character using Jython script Faster and Easiest way to design Interfaces AUTOMIZE ODI REPOSITORY EXPORTS Informix Connection SQL Server connection Repository Architecture – Two or more Masters – Part 3 Report of list of KMs in each Interface Connecting openLDAP How to call a Web Service that start an ODI Scenario and waits its complete execution Processing multiple Interface through single Package Multiple Files – Single Interface Generate Multiple Scenarios Sequence How to get a constant or pseudo-column from source mapping Lock Windows Layout Hide Unused Technologies Tab at the Top oracle.jdbc.V8Compatible Oracle to Flat file Scheduling using ODI Scheduler Exception – getobjectname schema How to create a Temp Table in ODI Interface (Yellow Interface) Printing report Step by step procedure to Read Excel (*.xls) Importing Knowledge Modules Creating Master and Work Repository Installation Repository Architecture – Just one Master – Part 2 How to refresh ODI variables from file – Part 2 – Getting all lines, once at time How to refresh ODI variables from file – Part 1 – Just one value Repository Architecture – Just one Master – Part 1 Welcome to ODI Experts, this is Cezar Santos.