How to define a PostgreSQL in ODI – then reverse engineer in the Designer to access the data
Defining a PostgreSQLserver in ODI
ODI has some automatic features which will generate the Group By Statement for you when you use any of the aggregation functions, this is a short demo of how to use it
How to use Aggregation Functions in ODI
What is the Common Format Designer (CDF), and what can we do with it? Short demo of the features, generating schemas and generating interfaces automatically.
ODI’s Common Format Designer
Short demo on the Metadata Navigator of ODI
ODI’s Metadata Navigator
OdiZip is a useful tool and this short screencam illustrates its use
OdiZip How to use
Sybase ASE to IQ knowledge module
Sybase ASE to IQ KM demo
How to use custom Java classes in your ODI procedures
Using custom Java code in ODI
Using Excel in ODI, including getting round the problem with the limitation of fixed named ranges
Using Excel in ODI
How to define and use Flexfields to extend ODI’s metadata
Using FlexFields in ODI
Defining XML file in Topology and reverse engineering
XML 1 Defining
What does the XML structure look like in ODI?
XML 2 The Rendered Data Structure
When the definition doesn’t work, how do you find out what has gone wrong?
XML 3 Topology
How to use ODI to populate a simple XML structure
XML 4 Populating Simple XML
Populating a more complex XML structuire – requiring the use of multiple interfaces. Writes to a file with a dynamic name – in this case the session_id.xml
XML 5 Populating Complex XML
How to configure external database storage for the JDBC Driver for XML- useful when dealing with large XML files
XML 6 External Database Storage
How to set up the file name for the XML file so that it accommodates the use of multiple different file names
XML 7 Reading a Dynamically named XML file
If you want to master scripting in ODI get the following books.
Java BeanShell
Scripting in Java: Languages, Frameworks, and Patterns
Jython
The Definitive Guide to Jython: Python for the Java Platform.
