KPI Partners Blog

A Detailed Explanation of ODI Knowledge Modules (JKM & SKM)

Posted by KPI Partners News Team on Thu, Dec 05, 2013 @ 07:35 AM

by Ashok Das

Another article in Ashok's series where he examines Oracle Data Integrator (ODI) Knowledge Modules (KM).  For an basic introductory overview, check out 'What is an ODI Knowledge Module (KM)?'

Read More

Tags: Data Warehousing, Ashok Das, Tutorial, Oracle BI Applications, Examining OBIA 11g, Oracle Data Integrator (ODI), Blog

A Detailed Explanation of ODI Knowledge Modules LKM & IKM

Posted by KPI Partners News Team on Sat, Sep 14, 2013 @ 12:52 PM

by Ashok Das

Another article in Ashok's series where he examines Oracle Data Integrator (ODI) Knowledge Modules (KM).  For an basic introductory overview, check out 'What is an ODI Knowledge Module (KM)?'

Read More

Tags: OBIEE, Ashok Das, Oracle, Business Intelligence, Tutorial, Oracle BI, Oracle BI Applications, Examining OBIA 11g, Oracle Data Integrator (ODI), Blog

Preserve Historical Data in Oracle BI Snapshot Tables

Posted by KPI Partners News Team on Tue, Aug 27, 2013 @ 12:16 PM

by Prabu Varatharaju

What is Snapshot data?

Snapshot data is a copy of business data preserved at some point-in-time. In some cases we may not be able to recover older snapshot data from the current data sets because we need to preserve snapshots at regular (scheduled) intervals for historical analysis.

Read More

Tags: Data Warehousing, Financial Analytics, Oracle E-Business Suite, Prabu Varatharaju, Informatica, Business Intelligence, Tutorial, Oracle BI, Oracle BI Applications, Examining OBIA 11g, Oracle Data Integrator (ODI), Blog

Choosing the Correct ETL Tool For Oracle BI

Posted by KPI Partners News Team on Tue, Aug 20, 2013 @ 12:02 PM

by Sridhar Kasthuri

A key component to any Business Intelligence (BI) Architecture is the Extract, Translate and Load (ETL) process. The ETL process is typically scheduled on a daily basis and is capable of data movement from legacy systems into a data warehouse. It is also used to facilitate the work of the database administrators who connect different branches of databases as well as integrate or change the existing databases.

Read More

Tags: Data Warehousing, Oracle, Informatica, Business Intelligence, Sridhar Kasthuri, Oracle BI, Oracle BI Applications, Examining OBIA 11g, Oracle Data Integrator (ODI), Blog

What is an ODI Knowledge Module (KM)?

Posted by KPI Partners News Team on Mon, Aug 19, 2013 @ 11:15 AM

by Ashok Das

Knowledge Modules (KM), components of Oracle Data Integrator’s Open Connector Technology, are generic, highly specific and reusable code templates which defines the overall data integration process. Each Knowledge Module contains the knowledge required by ODI to perform a specific set of actions or tasks against a specific technology or set of technologies, such as connecting to this technology, extracting data from it, transforming the data, checking it, integrating it, etc.

Read More

Tags: Ashok Das, Oracle BI Applications, Examining OBIA 11g, Oracle Data Integrator (ODI), Blog

Oracle Data Integrator Component Architecture

Posted by KPI Partners News Team on Thu, Jul 18, 2013 @ 02:26 PM

by Shiva Molabanti

The Oracle Data Integrator platform integrates into the broader Fusion Middleware platform and becomes a key component of this stack. Oracle Data Integrator provides it's run-time components as Java EE applications, enhanced to fully leverage the capabilities of the Oracle WebLogic Application Server. Oracle Data Integrator components include the FMW exclusive features for Enterprise-Scale Deployments, high availability, scalability, and hardened security. 

Read More

Tags: Shiva Molabanti, Oracle, Tutorial, Oracle BI, Oracle BI Applications, Oracle Data Integrator (ODI), Blog

Performance Tuning Oracle Data Integrator (ODI)

Posted by KPI Partners News Team on Fri, Jun 28, 2013 @ 10:40 PM

by Sharath Venkataranga

The most common question faced by any ETL developer or a Data Warehouse project implementer is always related to performance. Whatever the tool may be, and however fast the job may be running, the end user will always desire something which is a little faster and quicker.

Read More

Tags: Data Warehousing, Training, Sharath Venkataranga, Business Intelligence, Tutorial, Oracle BI Applications, Examining OBIA 11g, Oracle Data Integrator (ODI), Blog

Watch: Unpacking The New Oracle BI Apps (Now With ODI!)

Posted by KPI Partners News Team on Tue, Jun 25, 2013 @ 01:34 PM

The new release of the Oracle BI Applications (11.1.1.7.1) now leverages Oracle Data Integrator (ODI). This huge development means that ODI can alternatively be utilized as the primary data integration tool over Informatica. ODI and its Extract-Load-Transform functionality could provide customers a setup that delivers increased performance and reduced data integration costs.

Read More

Tags: Student Information Analytics, Webinar, JD Edwards, OBIEE, Vikas Agrawal, DAC, Oracle, Informatica, Business Intelligence, Video, Jeremiah Johnson, Events, Oracle BI, Oracle BI Applications, Exalytics, Examining OBIA 11g, Oracle Data Integrator (ODI), Hari Cherukupally, GoldenGate, Indirect Spend Planning, Blog

Executing An ODI Load Plan

Posted by KPI Partners News Team on Mon, Jun 17, 2013 @ 12:41 PM

by Varun Reddy

Oracle Data Integrator (ODI): Executing A Load Plan

Load Plan 

A Load Plan is an executable object in Oracle Data Integrator that can contain a hierarchy of steps that can be executed conditionally, in parallel or in series. Procedures, interfaces, packages, variables, and can be added to Load Plans for executions in the form of scenarios in a Load Plan.

Read More

Tags: Data Warehousing, Varun Reddy, Oracle, Tutorial, Oracle BI, Oracle BI Applications, Examining OBIA 11g, Oracle Data Integrator (ODI), Blog

Overview of Oracle BI Apps 11.1.1.7.1 [Examining OBIA 11g: The Series]

Posted by KPI Partners News Team on Tue, Jun 11, 2013 @ 12:39 PM

by Jeremiah Johnson

As part of KPI's web series on Examining Oracle BI Applications 11g, this short video provides a brief overview of the new release of the Oracle BI Applications.  Areas of examination for this session include:

Read More

Tags: Student Information Analytics, OBIEE, Financial Analytics, Peoplesoft Campus Solutions, Ramesh Ponganti, Project Analytics, Rushendra Prasad, Jeremy Simmons, Srinivasan T, Sharath V, Vlad Valeyev, Prabu Varathaju, Informatica, Video, Myles Gilsenan, Jeremiah Johnson, HR Analytics, Oracle BI Applications, Procurement & Spend Analytics, Examining OBIA 11g, John Whitaker, Oracle Data Integrator (ODI), Fixed Asset Analytics, Indirect Spend Planning, Oracle GoldenGate, Supply Chain and Order Management, Blog