KPI Partners Blog

Code Migration In Cloud World

Posted by KPI Partners News Team on Tue, Feb 10, 2015 @ 09:56 AM

by Ksheetij Dongre

Migrating Code from Development to Production in the Cloud

The cost of cloud migration is not cheap but the promise is that the company will acheive a significant return on investment over the long haul.  The objective of this article is to help us understand how to setup Development and Production environments in the cloud, specifically regarding these components of a data warehouse (DW):

Read More

Tags: Data Warehousing, Cloud Services, SQL Server, Database, Ksheetij Dongre, Oracle, Informatica, Cloud Master Data Management, ETL, Blog

An Informatica Expert's Understanding of Oracle Data Integrator (ODI)

Posted by KPI Partners News Team on Tue, Nov 25, 2014 @ 10:42 AM

by Prashanth Gajjala

I started working with Oracle Data Integrator (ODI) a year ago while participating in a Oracle Business Intelligence Applications 11.1.1.7 implementation.   I have been working with Informatica as the extract-transform-load (ETL) tool of choice for a long time, which included Oracle Business Intelligence Applications and custom warehouse projects.

Read More

Tags: Data Warehousing, ODI, Prashanth Gajjala, ELT, Oracle, Informatica, ETL, Data Integration, Oracle Data Integrator (ODI), Blog

Ongoing Challenge: Data Integration In "The Cloud"

Posted by KPI Partners News Team on Wed, Nov 19, 2014 @ 10:49 AM

by Potnuru Hatakesh

Adoption of "The Cloud" is growing significantly as more a enterprises start to see and experiencing the value in agility, scalability, and cost savings.

Read More

Tags: Data Warehousing, Cloud Services, Potnuru Hatakesh, Informatica, Cloud Master Data Management, ETL, Data Integration, Cloud Application Integration, Blog

Understanding The Informatica MD5 Function

Posted by KPI Partners News Team on Fri, Apr 25, 2014 @ 03:52 PM

by S. K. Purushotham

This article will help you understand the importance of the MD5 function in Informatica. It will also help you answer questions like:

Read More

Tags: Data Warehousing, Informatica, Tutorial, ETL, SK Purushotham, Data Integration, Blog

Accessing Informatica Web Services from 3rd Party Apps

Posted by KPI Partners News Team on Mon, Mar 24, 2014 @ 12:25 PM

by Sagar MV

Have you ever needed to access Informatica services from a third party application such as Salesforce.com or another Cloud/Non-Cloud application but were unable to do so?  By configuring web services in the Informatica Power Center, it is possible to access Informatica services from a third party application.

Read More

Tags: Sagar MV, Web Services, Oracle, Informatica, Tutorial, Data Integration, 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

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

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

Under The Hood Of The New Oracle BI Apps

Posted by JEREMIAH JOHNSON on Tue, May 14, 2013 @ 08:18 AM

What's New And What's Improved In The New Version Of Oracle BI Applications...

Oracle just released a new version of Oracle BI Applications (11.1.1.7.1 also known as 11g PS1) and as the top partner for Oracle BI Applications (we can prove it - we've won the awards), we thought we'd take a look under the hood to highlight the enhancements.

Read More

Tags: Student Information Analytics, Financial Analytics, Oracle E-Business Suite, Peoplesoft Campus Solutions, Project Analytics, Essbase, Real-Time Supply Chain and Inventory Analytics, Informatica, Jeremiah Johnson, HR Analytics, Oracle BI Applications, Real-Time Financial Analytics, Procurement & Spend Analytics, Examining OBIA 11g, Oracle Data Integrator (ODI), Fixed Asset Analytics, GoldenGate, Indirect Spend Planning, Supply Chain and Order Management, Blog