This post describes a simple method to remove a single or more special character using Jython script My source flat file had this special character ( ” ) To remove such special character from ODI without running Unix script or … Continue reading
Monthly Archives: September 2009
September 25, 2009
by kdevendr
0 comments
Categories: Knowledge Modules , Logic , ODI , Tips and Tricks
Faster and Easiest way to design Interfaces
Define your Model Folder and Models . Right Click on the Target Models and select ‘Interface In‘ Select your Generation Folder and Optimization Context accordingly and Select the Data Store Name for which the interfaces needs to be generated else … Continue reading
September 23, 2009
by kdevendr
16 Comments
Categories: Architecture , Logic , ODI , Tips and Tricks
Tags: Informix , ODI
AUTOMIZE ODI REPOSITORY EXPORTS
This Post defines the simple process on how to setup automatic daily backup of ODI Master and Work Repository. This process is especially important where there is no backup or improper schedule backup is carried out by DBAs. Steps Export … Continue reading
Informix Connection
To download the Latest driver for Informix, please visit here http://www14.software.ibm.com/webapp/download/search.jsp?go=y&rs=ifxjdbc There is also a driver present for Informix in ODI Driver Name – IBM Informix JDBC Driver JDBC Driver – com.informix.jdbc.IfxDriver JDBC URL -jdbc:informix-sqli://165.202.560. 369:1576:informixserver=infxdw;database=ftp URL Parameters: <host>: server … Continue reading
September 23, 2009
by kdevendr
6 Comments
Categories: ODI , Technology
Tags: ODI connection , ODI SQL Server , Sql Server 2000 , Sql Server 2005
SQL Server connection
Connecting Oracle Data Integrator and MS SQL Server 1. Refer to this Download link for Microsoft SQL Server 2005 JDBC Driver 1.2 http://www.microsoft.com/downloads/details.aspx?FamilyId=C47053EB-3B64-4794-950D-81E1EC91C1BA&displaylang=en and for Microsoft SQL Server JDBC Driver 2.0 here http://www.microsoft.com/downloads/details.aspx?familyid=99B21B65-E98F-4A61-B811-19912601FDC9&displaylang=en JDBC Driver 1.2 Extract the downloaded .exe … Continue reading
September 23, 2009
by Cezar Santos
2 Comments
Categories: Architecture , ODI
Tags: ODI , ODI Experts , ODI repository , Oracle Data Integrator , repository , Sunopsis
Repository Architecture – Two or more Masters – Part 3
Hi Friends, I got some emails and comments asking for publish about how to work with more then one Master Repository and, you will see, it isn’t so complicated. I will use, as base, the post Repository Architecture – Just one … Continue reading
September 21, 2009
by kdevendr
3 Comments
Categories: Knowledge Modules , ODI , Reports , Tips and Tricks
Report of list of KMs in each Interface
This query lists all the KMs used in each Interfaces under a particular Folder or Project with Interface Name , Interface Type ie. Permanent_Interface (Blue) or Temporary_Interface (Yellow) ,LKM , IKM , CKM and Source Set Number since there can … Continue reading
Connecting openLDAP
In Hyperion EPM 11 , authentication information is stored in openLDAP . To get more information for the Hostname , port name , log into your Hyperion Shared Service console and under ‘ Administration ‘ click on ‘ Configure User … Continue reading
September 20, 2009
by Cezar Santos
9 Comments
Categories: Architecture , Logic , ODI , Tips and Tricks
Tags: ODI , ODI Experts , ODI Web Services , Oracle Data Integrator , Sunopsis
How to call a Web Service that start an ODI Scenario and waits its complete execution
Hi friends, I just created this technique because I was in a POC (Prove of Concept) and needed to call a WS (Web Service) but the WS must wait the scenario execution until the end and, too, receives a return … Continue reading
Processing multiple Interface through single Package
Logic to process Multiple Interface using a odistartscen using a single package Continue reading