Badges
75 Points
8 Years
User Activity
Over 6 years ago
Answered a question: Oracle ICS vs ODI
Is your business a disconnected business
Aren't the legacy systems being synchronized?
Is your cloud systems not being synchronized with on premisses-legacy systems?
Does your business already have transactional systems such as ERP, CRM in the cloud? And you need to push…
Over 6 years ago
I totally agree with the points you mentioned.
Over 6 years ago
In response to "reviewer746463
Item#1 - For all main objects in ODI, such as PKG, Interface/Mappings, Procedures, variable, KM there is a "version" tab/ kind of property of the object. Once you navigate in there, you will be able to see the following: "Created By"…
Over 7 years ago
You can find more about the ODI history on the link : http://www.oracle.com/us/corporate/press/016802_EN
Over 7 years ago
Commented on If it doesn't connect out-of-the-box to a specific technology, we can add a new technology into it
Hi Rodrigo
That is good to know those limitations on integrating ODI with EPM applications .
In terms of the main RDBMS in the market I think ODI is quite good in providing the native drivers, when they don't we can find it and place on the ODI drivers folder and works but…
Over 7 years ago
Commented on I have used it to improve run-times of many corporations' overall integration run-times.
Hi Brian, it is a nice review
About the room for improvement I saw you mentioned the error handling, in that aspect we handle that in packages when exceptions happens during the data flow / load for example, someone changes a column name in one of the table sources then…
Over 7 years ago
I would like to add another comment about how hard it is to find documents and manuals on SAP BI products if you don't have a support account, or even a simple document or if you need to do an evaluation, a proof of concept of the product you need to pay, whereas if you…
Over 7 years ago
Commented on ODI makes data transfer easy. Improved reconciliation and external authentication would be helpful.
ODI Infrastructure wise I think it comes down to the infrastructure and network team understanding what are required to run the tool smoothly , also having a proactive and helpful DBA who really understands the nature of a database for DW, essentially the difference and…
Over 7 years ago
But one of the beauties of ODI is exactly that flexibility in integrating several different platforms/technology, for example, say you have a data source on SQL server database and your target database is Oracle and you want to apply a sql server function, in your interface…
Almost 8 years ago
Contributed a review of Oracle OBIEE: End-users can cross the data from dimensional models with external Excel spreadsheets.
Almost 8 years ago
Which platform/ Technology are you using as a target ?
Almost 8 years ago
That is true!! the integration with other Oracle products is great and enable several business functionalities, some of the examples I have seen and worked on are the integration of OBIEE and BPEL(SOA) with ODI, for example, when you have OBIEE in your environment one of…
Almost 8 years ago
Contributed a review of Oracle Data Integrator (ODI): All our systems can be widely integrated by ODI, such as transactional systems, our data warehouses, and B2B integration.
Projects
Over 8 years ago
Large ETL/ Data Integration Project for one ofLarge ETL/ Data Integration Project for one of the largest Airline Companies in Brazil, project(Loyalty Program Air points) IBM, Data Integration (from Sales Force to Oracle DW)
Experience
Other Skills
Oracle Database/ Data Modeling (Relational, Dimensional and Object oriented)Reviews
Almost 8 years ago
Oracle OBIEE
Almost 8 years ago
Oracle Data Integrator (ODI)
Answers
Comments
Over 6 years ago
Data Integration
Over 6 years ago
Data Integration
Over 7 years ago
Data Integration
Over 7 years ago
Data Integration
Over 7 years ago
Data Integration
Over 7 years ago
BI (Business Intelligence) Tools
Over 7 years ago
Data Integration
Over 7 years ago
Data Integration
Almost 8 years ago
Data Integration
About me
Big Data / Business Intelligence / Data Warehousing Solution Architecture and development.
Data Warehouse best Practices, DW optimization and performance enhancement (Slowly Changing Dimensions, Change-data-capture, Materialized views, partitioning techniques, Oracle database administration), Dimensional, relational and Object-Oriented data modeling.
Data Base performance tuning.
ETL process: Oracle Data Integrator(ODI 10g, 11g, 12c), Informatica Power Center, Microsoft SSIS
Data visualization: Oracle Business Intelligence Enterprise Edition(OBIEE 10g, 11g, 12c) and Microsoft Power BI
Interesting Projects and Accomplishments
Over 8 years ago
