Posts Tagged ‘odi’

7 Sessions to Add to Your Collaborate 19 Agenda #C19TX

Perficient is proud to be an OAUG Star Partner and exhibitor at Collaborate 19, which is being held April 7-11 in San Antonio, TX. Did you know that Collaborate is where the Oracle user community comes together to share and learn through 1200+ education sessions, panels and networking events? We are honored to have been […]

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 […]

Red Hat Deal IBM

From OBIEE or OBIA to OAC: The Fundamentals at #C18LV

Oracle Cloud BI solutions have been available for a few years now and have evolved significantly over the past couple years. If you have been using OBIEE or OBIA (Oracle BI Applications), you are in a pretty good position to start migrating to Oracle Analytics Cloud (OAC). The reason: OAC relies on a similar underlying […]

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 […]

Using ODI to Load an Essbase Exported File to an Oracle Table

Here, we’ll cover the ability to use ODI for one its basic features: extracting data from Essbase and using the exported file to load to a table. It turns out that ODI was not recognizing the file generated by Essbase. Let’s see what we were missing: We have a calc script exporting level 0 data from […]

ODI Best Practices to Achieve Fast-Paced ETL (Part 2) #C17LV

Integrating data from non-Oracle source systems with an Oracle prepackage solution is a common practice that requires source to Target integration. While implementing BI Apps/Oracle EHA (Enterprise Healthcare Analytics) with a new source, I used several best practices, which can be leveraged while integrating a new source in an Oracle Warehouse using ODI. As a […]

ODI Integration with Salesforce

In this blog post, I’ll explain how you can use Oracle Data Integrator (ODI) to extract data from the Salesforce cloud and thereby perform detailed Analysis / Reporting in order to make better decisions. Prerequisites Salesforce Developer Edition account to access the Salesforce data. JDBC driver to interact with Salesforce from ODI. Get this from https://www.progress.com/datadirect-connectors Download Cloud […]

Delving into Web Service through ODI

Today, enterprises are dealing with different data sources and targets, SaS to CRM, Data Warehouse, Social Media, etc.., Integration of data is at the heart of every initiative. Building a Data Warehouse should be initiated from both ETL as well as Data integration perspective. In order to fulfill this requirement, ODI comes into picture. ODI […]

How to Export and Purge ODI Log Files Using OdiPurgeLog Utility

We have to regularly purge the Oracle Data Integrator (ODI) log files to reduce the size of the ODI work repository and improve the performance of the ODI studio. Before purging we can export the ODI log files and archive them. If we ever want to analyze the log history, we can re-import the logs from […]

Oracle Transactional BI: OTBI vs OTBIE

At Collaborate 16, Pawan Kumar from Perficient presents the key characteristics that benefit adopters of Oracle Transactional Business Intelligence (OTBI) and Oracle Transactional Business Intelligence Enterprise (OTBI-E). Below are the main points I am highlighting from Pawan’s session that help differentiate between the two products and shed some light on how each product is most […]

How to Raise the Custom Exception in ODI

This post will explain the process to raise the custom exception in ODI. Process: Create a variable to store the custom error message Create a procedure to read the error message from the variable and raise the exception. Create a package to set the value in the custom error variable and execute the raise exception […]

Steps to Execute Full Load in BIAPPS 11.1.1.7.1

In BIAPPS whenever a ODI package is executed it reads  W_ETL_LOAD_DATES table to verify if a record exists with that package name. If record found package is executed in incremental mode else Full load mode. In incremental mode package will update the last_executed_date of existing record in W_ETL_LOAD_DATES table and in Full load mode package will insert […]

Load More