Skip to main content

Posts Tagged ‘odi’

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

Why Implement Incorta Analytics for Oracle Fusion Cloud ERP Reporting?

Oracle Cloud ERP offers several built-in tools for reporting. While native reporting tools like Oracle Transactional Business Intelligence (OTBI) and Oracle BI Publisher are well-suited for specific types of operational reporting, they do have limitations when it comes to performing complex and enterprise-wide reporting. It is therefore crucial to complement the Oracle Cloud ERP application […]

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

Load More