ODI Experts

The blog for Oracle Data Integrator

August 25, 2010
by Kshitiz Devendra
15 Comments

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

Tags: hardecoded password , ODI , ODI connection , ODI Experts , odisqlunload , Oracle Data Integrator , Sunopsis

Calling OdiSqlUnload using ODI Procedure with no hardcoded password

Hello all, OdiSqlUnload is a great utility for unloading but then we need to hardcoded and provide the parameters of the username and password which can change in the Other Environment in ( Testing , UAT or Prod ) . … Continue reading →

July 31, 2010
by Kshitiz Devendra
5 Comments

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

Tags: ODI , ODI Experts , odisqlunload , Sunopsis

Generate Column_name Header for OdiSqlUnload

Last week we have shown you the code for generating the Header and populate the same in OdiSqlUnload file , but the codes seems to be limited to the Database and then separate query needs to be created for each … Continue reading →

Recent Posts Multi –Table Insert KM RKM FILE (Jython) Generate All Scenario for a Particular Project using ODI SDK Interface with Union, Minus Operator using ODI SDK Export and Importing Scenarios based on Project (or)Folder – ODI SDK	Recent Comments Ram on Creating Temporary Interface using ODI SDK Kshitiz Devendra on 11g Oracle Data Integrator – Part 4/11g – Upgrading from 10g Kshitiz Devendra on Changed Data Capture ( CDC ) Kshitiz Devendra on MINUS IN ODI Ram on 11g Oracle Data Integrator – Part 4/11g – Upgrading from 10g
Categories Administration Architecture Common Errors Drivers How to Java Codes Jobs Knowledge Modules Logic ODI ODI Bug Others Reports SDK SQL Technology Tips and Tricks	Tags Export file variable ODI Import Informix Interface INTERFACES Jython KM Knowledge Modules MINUS ODI ODI 11g ODI Adminstration ODI Agent ODI connection ODI Context ODI Data Server ODI Experts ODI Logical Schema ODI Physical Schema ODI PL/SQL ODI Procedure ODI repository ODI Scenario ODI sequence odisqlunload ODI variable ODI Web Services Operator Oracle Data Integrator Oracle Data Integrator 11g parallel PL/SQ Functions PL/SQL Parameters PL/SQL Procedures repositories repository scenario SDK Sql Sunopsis sysdate sysdate source UNION variable from file
Recent Jobs ODI Developer ODI Developer Oracle Data Modeler / ETL Developer with ODI / EDQ Exp	Blogroll askankit BI-Quotient john-goodwin