Posts Tagged ‘odi’

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

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

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

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

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

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

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

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

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

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

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

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