Entries from Data Integration and Management tagged with 'Oracle Data Integrator'
Parallel Processing in ODI
This post describes how ODI can be leveraged to execute processes in parallel, and beyond the parallelisation how these can then be synchronized.
The Benefits of ODI Knowledge Modules: a Template Approach for Better Data Integration
An analysis of the benefits of using a template based approach for data integration, and how this approach is made possible by ODI Knowledge Modules.
Did You Know that ODI Automatically Summarizes Data Errors?
ODI automatically generates a table to summarize all errors identified on a server. We review here the structure of this table, and how to locate it on the server.
Connecting to Oracle Business Intelligence EE using Oracle Data Integrator
Looking for Data Integration at OpenWorld 2009? Click here! The posts in this series assume that you have some level of familiarity with ODI. The concepts of Topology, Data Server, Physical and Logical Architecture are used here assuming that...
Creating a New Knowledge Module for Sample Data Sets Generation
This post will look into when and how to create a knowledge module. Then it will walk through some of the choices that can be made when designing a Knowledge Module. A complete KM is provided to support the explanations.
ODI User Functions: A Case Study
Using one of the ODI User Functions that were described in a previous post, we review how to design and use User Functions in ODI.
How to Define Multi Record Format Files in ODI
The posts in this series assume that you have some level of familiarity with ODI. The concepts of Datastore, Model and Logical Schema are used here assuming that you understand them in the context of ODI. If you need more...
Generating Sample Data with ODI: A Case Study For Knowledge Modules and User Functions
Using ODI to generate random sample data sets out of thin air, using a combination of Knowledge Module and User Functions.
Designing and Loading Your Own Staging Tables
The posts in this series assume that you have some level of familiarity with ODI. The concepts of Interface, Model and Knowledge Module are used here assuming that you understand them in the context of ODI. If you need more...
Using an ODI Procedure to Loop Through a Command
The posts in this series assume that you have some level of familiarity with ODI. The concepts of Procedure, Command and Logical Architecture are used here assuming that you understand them in the context of ODI. If you need more...
How to Customize ODI-EE through Knowledge Modules
In this article entitled "Developing a Knowledge Module in Oracle Data Integrator", Uli Bethke outlines what Knowledge Modules (KMs) are and how to customize and build an Integration Knowledge Module. Uli writes: The power of KMs lies in their reusability...
Best Practices building Data Services with ODI-EE
If you've been reading some of the earlier posts on best practices for loading Essbase using ODI. you can definitely respect how thorough John Goodwin is in his analysis and explanations. In the same spirit, John has taken a comprehensive...
Rittman Mead BI Forum 2009: ODI Recap
Thanks to the folks at Rittman Mead for a stellar event at the BI Forum. If you'd like to see any of the presentations, feedback, and blog posts from the forum, you can take a look at Mark's recap post...
Using ODI Variables in Topology: Pushing Contexts to the Extreme
The posts in this series assume that you have some level of familiarity with ODI. The concepts of Context, Topology, Logical Architecture, Physical Architecture and Variables are used here assuming that you understand them in the context of ODI. If...
Connecting Visibility to Value: Data Integration and Business Intelligence
Recently I just posted an article on BeyeNETWORK, entitled Connecting Visibility to Value: Data Integration and Business Intelligence. The article summarizes five important factors that are critical for Business Intelligence platforms: - Optimized data movement - Data quality - Real-time...
Executing the Same Code in All Environments: ODI Contexts.
The posts in this series assume that you have some level of familiarity with ODI. The concepts of Context, Topology, Logical Architecture and Physical Architecture are used here assuming that you understand these concepts in the context of ODI. If...
Using Variables in ODI: Creating a Loop in a Package
The posts in this series assume that you have some level of familiarity with ODI. The concepts of Model, Project, Interface and Package are used here assuming that you understand these concepts in the context of ODI. If you need...
Using Parameters in ODI: The Dynamic File Name Example
The posts in this series assume that you have some level of familiarity with ODI. The concepts of Model, Project, Interface and Package are used here assuming that you understand these concepts in the context of ODI. If you need...
Using Variables in ODI: The Timestamp Example
The posts in this series assume that you have some level of familiarity with ODI. The concepts of Model, Project, Interface and Package are used here assuming that you understand these concepts in the context of ODI. If you need...
Cost Savings are the New Black for Data Warehousing
According to Margy Ross - from the Kimball Group - the biggest obstacle today in implementing data warehouses is improper IT and business alignment. The following except is from an interview by Mark Rittman: [Margy Ross] : “The biggest challenge...
Search All Blogs
Google Search
Feed Subscription
If you use an RSS reader, you can subscribe to a feed of all future entries tagged 'Oracle Data Integrator'.
