KPI Partners Blog

Data Sharing in Snowflake

Posted by KPI Partners News Team on Tue, Nov 10, 2020 @ 03:22 AM

by Ramana Kumar Gunti

Data Sharing in Snowflake

In this article, we will talk about Snowflake data sharing which enables account-to-account sharing of data through Snowflake database tables, secure views, and secure UDFs. So let's get started.

Snowflake data sharing is a powerful yet simple feature to share the data from one account and to use the shared data from another account. The data producer can provide access to his live data within minutes without copying or moving the data to any number of data consumers. The data consumer can query the shared data from data producer without any performance bottle necks thanks to snowflakes multi-cluster shared data architecture.

Read More

Tags: Oracle Data Integrator (ODI), Blog, Snowflake, Ramana Kumar Gunti

Oracle Data Integrator with Snowflake

Posted by KPI Partners News Team on Thu, Sep 24, 2020 @ 07:21 PM

by Abdul Mathin Shaik

Oracle Data Integrator with Snowflake

In this article, we will talk about how to load the data into the Snowflake data warehouse using Oracle Data Integrator ODI. So let's get started.

Lately, one of our Snowflake customers was looking to use Oracle Data Integrator to load data into Snowflake from oracle DW. I have been working with Oracle applications such as ODI for years now, so I wanted to explore how to configure ODI to work with Snowflake. 

Read More

Tags: Oracle Data Integrator (ODI), Blog, Snowflake, ODI with Snowflake, Abdul Mathin Shaik

How to Setup Dependencies between Load Plans in Oracle Data Integrator

Posted by KPI Partners News Team on Mon, Jun 11, 2018 @ 11:53 AM

by Chaithanya Kumar Taduvai

ODI developers usually deal with load plans and mismanaged dependencies between multiple-load plans are typically a cause of data corruption in the system. An ideal Informatica warehouse implementation has multiple execution processes dependent on other execution processes which run automatically without any manual intervention. Here is how we can overcome this issue using the load plan dependency feature of ODI.

Read More

Tags: ODI, Oracle Data Integrator (ODI), Blog, ODI Load Plans

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

Top 3 Takeaways On BI & EPM From Oracle OpenWorld 2014

Posted by KPI Partners News Team on Fri, Oct 03, 2014 @ 06:45 AM

by Sid Goel

This week I have been in attendance at Oracle Open World where my focus has been on the Business Intelligence (BI) and Enterprise Performance Management (EPM) track.   The presentations have revolved around 2 primary themes: Cloud and Oracle Data Integrator (ODI).

Read More

Tags: Sid Goel, Cloud Services, Business Intelligence, Oracle BI Applications, Oracle Data Integrator (ODI), Blog

9 Steps To Upgrade A Oracle Data Integrator Repository (11g to 12c)

Posted by KPI Partners News Team on Tue, May 13, 2014 @ 11:20 AM

by Raviteja Santosh

Upgrading A Oracle Data Integrator (ODI) Repository from ODI 11g to ODI 12c

Migrating Oracle Data Integrator (ODI) from version 11g to 12c is not straight forward as exporting and importing it into a new repository.   An administrator needs to upgrade the 11g version of the repository to the 12c version so the new features can be incorporated into into the code.

Read More

Tags: ODI, Raviteja Santosh, Cloud Services, Tutorial, Data Integration, Examining OBIA 11g, Oracle Data Integrator (ODI)

How To Merge My Old BI Environment With My New Oracle BI Apps Environment

Posted by KPI Partners News Team on Fri, Apr 18, 2014 @ 12:56 PM

by Ravi Hoskote

How can I create and maintain a single environment for existing BI content and new Oracle BI Apps content?

The popularity of the Oracle BI Applications (OBIA) is growing, thanks to the millions of customers who have experienced and appreciated the value it can deliver.  But a common question still remains unanswered - "What do I do with my existing business intelligence content?"   Most wish to avoid having separate environments for Oracle BI Applications and their other, non-OBIA, Oracle Business Intelligence Enterprise Edition (OBIEE) and third-party BI content.

Read More

Tags: OBIEE, Migrations, Ravi Hoskote, Packaged ERP Analytics, Oracle, Business Intelligence, Oracle BI, Oracle BI Applications, Oracle Data Integrator (ODI), Blog

The Oracle Data Integrator 12C Standalone Collocated Agent

Posted by KPI Partners News Team on Thu, Apr 10, 2014 @ 10:42 PM

by Raviteja Santosh

The Standalone Collocated Agent comes as additional feature with Oracle Data Integrator (ODI)  12C, which is the blend of both standalone and Java Platform Enterprise Edition (Java EE) agents in ODI 12C.  This can be configured only with an ODI 12C Enterprise Edition Installation.

Read More

Tags: ODI, Raviteja Santosh, Oracle, Tutorial, Data Integration, Oracle Data Integrator (ODI), Blog

Getting Familiar With Oracle's BIACM & FSM

Posted by KPI Partners News Team on Wed, Apr 02, 2014 @ 08:44 AM

by Ashwin Pujari

Oracle Business Intelligence Applications 11g : Getting familiar With Oracle's Business Intelligence Applications Configuration Manager (BIACM) & Functional Set-Up Manager (FSM)

Once the BIAPPS installation is completed, the newly introduced web-based JAVA applications, BI Configuration Manager (BIACM) and Functional Set-up Manager (FSM), are available for administrators to complete the set-up related tasks. As it is a new product, the first thing that most do is, run through the oracle documentation, discuss with experts and fellow colleagues, take part in Oracle webinars etc.  After that, we still land up with a long list of new terminologies and jargon.

Read More

Tags: Data Warehousing, ODI, Ashwin Pujari, BIACM, FSM, Oracle, Tutorial, ETL, Data Integration, Oracle BI Applications, Examining OBIA 11g, Oracle Data Integrator (ODI), Blog

Top 12 BI Articles of 2013

Posted by KPI Partners News Team on Tue, Dec 17, 2013 @ 05:10 AM

The results are in... here are KPI's Top 12 Business Intelligence Articles of 2013*

JANUARY

The Primary Differences Between OBIEE 10g & 11g Security Models

Read More

Tags: OBIEE, Mobile BI, Awards, White Paper, Security, Shiva Molabanti, Ashok Das, Ashwin Pujari, Oracle BI Mobile App Designer, Rushendra Prasad, Imtiyaz Basha, EBook, Business Intelligence, Sridhar Kasthuri, Interactive Reporting, infographic, Jeremiah Johnson, HR Analytics, Oracle BI, Oracle BI Applications, Book, Jaime Seagraves, Oracle Data Integrator (ODI), Hyperion, Blog