Skip to main content

Posts Tagged ‘oracle data integrator’

An Oracle Cloud Infrastructure (OCI) Data Lake Solution for Oracle Cloud ERP by Perficient

Oracle Cloud ERP offers several built-in reporting capabilities to address the needs for operational reporting. Implementing more elaborate reporting use cases though requires that we extract data out of Oracle Cloud ERP. This is in part because the real-time Fusion APIs are more tailored for transactional interfaces and therefore not adequate to scale to a […]

Integrate Your Data using Oracle Data Integration Platform Cloud

Oracle Data Integration Platform Cloud (DIPC) DIPC is a unified, powerful, data-driven data integration platform on cloud which can accept data in any format from any source system either on premise or on cloud and process that data as per organization needs. With DIPC, you get all the capabilities of most popular E-LT (Extract – Load […]

Running Oracle BI Apps or OBIEE On Premises? Cloud or No Cloud?

I spend much of my time figuring out what things organizations are doing well when it comes to their enterprise analytics, what makes them better, and how to get there. After a few communications consulting for a new customer, I came to realize that they are likely categorized in one of three groups, most if […]

Oracle Data Integrator Cloud Service

Oracle is aggressively re-engineering all of their popular suite of products over to cloud. Among several cloud offerings that Oracle announced at Oracle OpenWorld 2016 is Oracle Data Integration. Many of you may already be familiar with Oracle Data Integrator. Now, the same product is re-engineered to work in the cloud with several additional capabilities to fully leverage […]

Loading a Slowly Changing Dimension Table with ODI

As I have been writing my blog posts about ODI, my director recently reached out to me asking why I don’t put a blog posting on how to load a slowly changing dimension table.  I thought that was a great idea as when I first started to use the tool this was a major requirement […]

Oracle Data Integrator (ODI) Work Repository Internal ID

Hopefully you all had a chance to read my previous post, “Types of Oracle Data Integrator (ODI) Repositories.”  As this will give you a high level understand of the ODI master repository.  I wanted to put together this short post, because due to my recent experience with ODI I was very surprised with how very […]

Types of Oracle Data Integrator (ODI) Repositories

As I have been putting together my ODI blog posts I wanted to put together another post discussing the different types of ODI repositories, “Master and Work.”  But the repository I want to touch upon the most in the “Work” repository and the different options the ODI work repository has to offer.   Now before I get into […]

Scheduling Oracle ODI Load Plans easy as 1, 2, 3

This will probably be one of my shortest posts on ODI, but I figured if I am covering  pretty much all the basics of ODI, it would be good to show you how to use ODI’s scheduler and also show you how to schedule your ODI load plans. As title of the post states “Oracle […]

Creating Oracle Data Integrator (ODI) Scenario and Load Plan

Hopefully everyone has been enjoying my many post on Oracle Data Integrator (ODI), again its starting to become one of my favorite ETL or E-LT software solutions.  With that being said, I wanted to continue my discussions with ODI and create a post showing you all how to create a ODI scenario and load plan. […]

How to create an Oracle Data Integrator (ODI) Package

So I’m hoping you all read my previous post on “Creating an Oracle Data Integrator (ODI) Interface” and hopefully it was simple to follow.  Today, I want to show you how to take your interface and bundle it into a ODI package with other ODI components in which will all you to run more than […]

Creating an Oracle Data Integrator (ODI) Interface

Hopefully you all had a chance to check out my recent blog posting “Getting to know Oracle’s Oracle Data Integrator (ODI).”  If you haven’t checked it out yet, I urge you to check it out.  Well to continue on the topic of Oracle Data Integrator (ODI), I wanted to put together a few posts on […]

Oracle Data Integrator (ODI) – Logical or “soft” deletes

Logical deletes are a common practice when loading dimensions in a data warehouse. If a dimensional record is deleted in the source database, it may need to continue to exist in your data warehouse. In my recent project, this was one of the requirements set during the design phase. Since ODI was being used as […]