Ask Our Consultant Anything- Are you afraid of ODI?

EPM/BI certified Consultant, Oracle ACE and TeraCorp Consulting CEO at TeraCorp Consulting

Published:Jul 25, 2017

Today at 9am PST (12pm EST) IT Central Station will be hosting consultant and ODI expert Ricardo Giampaoli for an Ask Our Consultant Anything session.

Ricardo has more than 20 years engaging in EIS, BI, EPM projects in Brazil, working for the last 5 years in global projects for a fortune 100 client.

His achievements include:

• First and only Oracle ACE in Business Intelligence track in Brazil.
• Design and implementation of management models & systems, deep expertise of key components to the EPM function in the Financial Services industry.
• Business architecture design, end-to-end integrated processes, implementation, business solution testing and enhancement of key technologies.
• Driver-based financial models linking corporate objectives and strategies to actionable insights.
• Models for financial institution in Hyperion Planning for net interest margin, risk adjusted returns, spreads from transfer rates, and allocated costs and capital.

Responsible for overall architecture and strategy for the deployment of Oracle Hyperion technologies.

Ricardo’s specialties: Hyperion Planning and Essbase (versions from system 9 to 11.1.2.4), BIEE 10g and 11g, ODI 10g,11g and 12c and OWB 10g and 11g.

Ask Ricardo a question in the comments, and join us later for the ACA session.

Explore related topics

Data Integration Data Virtualization

Search for a product comparison in Data Integration

3 Comments

Last commented on Jul 26, 2017

Ricardo Giampaoli

EPM/BI certified Consultant, Oracle ACE and TeraCorp Consulting CEO at TeraCorp Consulting

Consultant

Top 20

Jul 26, 2017

Hi Moses how are you? I usually try to avoid XML as much as I can since XML is always a problem... The only case I end up using XML is when need to extracting metadata from huge essbase outlines (more than 500k members). Even so is a problematic operation since you need to worry about the Sync step, that uses a lot of memory of the agent, you need to worry about not overlap the loads and some time (to not say most of the time) you need some time of tweak in the KM to help you. If is possible try to get txt files instead of XML or anything like that.

Ricardo Giampaoli

EPM/BI certified Consultant, Oracle ACE and TeraCorp Consulting CEO at TeraCorp Consulting

Consultant

Top 20

Jul 26, 2017

Feel free to ask about anything related with ODI as architecture, possible uses, ideas.... and also tell stories of success or failure using the tool! We can even discuss why it failure and if there're anything different that could change the situation!!

it_user145365

Works

Vendor

Jul 25, 2017

Hi Ricardo,

It would of great help if you can give some tips on loading complex XML into Oracle Table and vice versa

Thanks,
Moses V

Find out what your peers are saying about Microsoft, Informatica, Talend and others in Data Integration. Updated: June 2025.

DOWNLOAD NOW

860,632 professionals have used our research since 2012.

Related Questions

Ariel Lindenfeld

Director of Product Management at PeerSpot

Dec 19, 2024

Why is Data Integration important for companies?

See 1 answer

Rivka Alexander

Content Specialist at PeerSpot

Dec 19, 2024

Data Integration is vital for companies as it streamlines and unifies disparate data sources. Look for: Centralized data management Improved data quality Enhanced decision-making Reduced operational costs Increased collaboration The importance of Data Integration lies in its ability to consolidate data from various sources into a single, coherent view. This centralization reduces data silos, allowing stakeholders to access and analyze data efficiently. With improved data quality, companies can make precise, informed decisions. Consistent data leads to accurate reporting, providing businesses a competitive edge by identifying trends, predicting outcomes, and developing proactive strategies.Effective Data Integration also enables better resource management and cost reduction. By eliminating redundant systems and processes, companies can streamline operations and reduce expenses. The ability to collaborate across departments is another crucial aspect. Integrated data facilitates seamless communication between teams, boosting efficiency and innovation. In a rapidly changing business environment, the importance of Data Integration cannot be overstated, as it drives agility, adaptability, and sustained growth.

Read full answer

Ornit P

Team Leader at Elbit Systems Ltd

Feb 4, 2025

What are the best on-prem ETL tools?

2 out of 7 answers

Sarath Boppudi

Data Strategist, Cloud Solutions Architect at BiTQ

Aug 22, 2023

Hi Ornit, My preffered would be Informatica, SSIS, Wherescape. Informatica because it's a mature product that has been outfor a while with minimal development effort required. SSIS for SQL Server based solutions. Wherescape for ETL automation. Wherescape enables SQL users to write etl code in SQL using templates built into the product

Read full answer

Dan Peacock

Enterprise Data Architect at a manufacturing company with 201-500 employees

Aug 22, 2023

Good morning, Ornit. We are using the enterprise edition of Hitachi Vantara's Pentaho Data Integration (PDI) (it also has a community edition that is free to use but lacks some of the automation features that the enterprise edition has) for over a decade now and it will do just about anything we throw at it. We use if not only for ETL but also to generate reports that are burst out to the business. I've used Informatica in the past and the thing that impressed me about Pentaho was it was much easier to build transformations. That may have improved since then (this was back in the early 2000s) but having to link each and every field between each step was super tedious. PDI does it by name with the option to change the mapping manually if needed.

Related Categories