Over 258,359 professionals have used IT Central Station research.
Compare the best Datacenter Virtualization vendors based on product reviews, ratings, and comparisons.
All reviews and ratings are from real users, validated by our triple authentication process.
The total ranking of a product, represented by the bar length, is based on a weighted aggregate score.
The score is calculated as follows: The product with the highest count in each area gets the highest available score.
(20 points for Reviews; 16 points for Views, Comparisons, and Followers.)
Every other product gets assigned points based on its total in proportion to the #1 product in
that area. For example, if a product has 80% of the number of reviews compared to the product
with the most reviews then the product's score for reviews would be 20% (weighting factor) *
80% = 16. For Average Rating, the maximum score is 32 points awarded linearly based on our
rating scale of 1-10. If a product has fewer than ten reviews, the point contribution
for Average Rating is reduced (one-third reduction in points for products with 5-9 reviews;
two-thirds reduction for products with fewer than five reviews). Reviews that are more than 24 months old,
as well as those written by resellers, are completely excluded from the ranking algorithm.
The biggest feature for ODI is the fact that it uses the power of the source or target database to actually perform the ETL processing. So a typical data integration tool might have its own ETL engine, and that would be an additional server, additional costs, something else you have to maintain. ODI actually has the ability to create and generate code that runs... more»
One thing that is included, and it's going to improve, is the integration with a configuration management tool. Right now, they integrate with Subversion. And we know in the future, there's going to be more tools implemented there for configuration management and some new features there. So right now, it's kind of one of those features that, it's been released,... more»
The Knowledge Module (KM) is my favorite feature of ODI. This is where I learned how to use variables to make jobs dynamic. I took that knowledge and created a KM that would go into iTunes and pull the sales of eBooks. Making something that... more»
I have used ODI to improve run-times of many corporations' overall integration run-times. Corporations on a daily basis run integration jobs which normally take five hours or more. I have seen these jobs become hourly jobs because of the time... more»
Error handling can always be improved with ODI. A lot of the errors are generic, but I will say that with a little experience, you can decipher the errors to help you fix them. In fact, I find myself not using the debugger that came out with... more»
I think that the product as an overall solution is good. I would only point out some minor bugs or glitches in the development interface (ODI studio), but I do not think that any of them are worthy to be reported here.
It's the best tool for data integration. It can do anything you want, but the only downside is that you need to know what you are doing. You can take 10 times longer to do the same thing if you don't know how to use the tool. You have to know... more»
For the EPM environment, the ODI is the key to transforming a good project into a great project. With ODI, we can make all the EPM tools work together as one and we can create a puzzle that will increase the performance and capability of all... more»
Right now, we have two very different GUIs - 11g and 12c. 11g is faster to develop than 12c as it takes more steps to do exactly the same as 11g, but you have a lot of things that you need to do yourself. 12c implemented some things for which... more»
Software development, right from start, was custom and tailor-made. The most changing parts of these software products are the interfaces to the internal and external worlds; interfaces to other third-party software products, databases, file... more»
I worked on an application integration project with MS BizTalk 2002 with the Pennsylvania Department of Corrections at Camp Hill , Pennsylvania, USA, using File and FTP adapters. I worked with Cargus Systems at Lancaster, Pennsylvania, on... more»
Consultant at a tech consulting company with 1,001-5,000 employees
Jan 28 2018
What do you think of Oracle Data Integrator (ODI)?
The new release of Oracle Data Integrator (ODI 12c) is now available. Let´s find out what the new features of ODI12c are that this version includes.
First, is there anything fancy in the installation process?
Just one note here: to be able to use ODI Studio, the enterprise
installation needs to be selected (instead of the Standalone option)
while launching the ODI installation program.
For the configuration part, creating a new login to ODI repository
you are requested to specify a new wallet password. ODI12c provides you
with a possibility to store your credentials in a wallet that is
protected by a password. How much it helps to protect and manage your
credentials with a single password!
Goodbye Interfaces, Welcome Mappings
First of all, we do not...
The user interface for the data integrator tool is probably the most valuable piece. I'm a relatively newcomer to the ODI. We opted to use ODI instead of Informatica. Relatively, I do not have a lot experience with a lot of VARs, but I've... more»
We use ODI to extract and transform data to load into our data warehouse from our source system, which is Oracle EBS. We have found that it's very efficient; very fast. We can easily customize and review even out-of-the-box analytics that... more»
Perhaps more learning resources related to ODI would be helpful. I'm not sure if that's what restricted the buy-in. Even though the product has been out for 4-5 years, there are still a lot of people who aren't using it or have opted to stay... more»
There are several very important features that we use daily. * All our systems can be widely integrated by ODI, such as transactional systems, our data warehouses, and B2B integration. * ODI is really powerful for BI projects with traditional star-schema loads. For example, we integrated Salesforce to an Oracle data warehouse with it.ODI is a platform agnostic,... more»
There is always room for improvement, even when something is really good, but I think ODI is one of the best ETL tools in the market. However, I've always waited the web service feature to be improved in next versions, so at last the 12C version the webservice has been improved, some of the limitations of the 11g version were solved. Also it would be really good... more»
The most important aspect of the product is the ability to work with almost any data source or target. I can readily develop processes that use relational, file, XML, JMS messaging, web and big data sources or targets. I can control the style... more»
It allows a single skill set to handle virtually all of the data transport and transformation needs of a company. It moves the ETL processing to where the data resides and saves network traffic and the need for dedicated transformation... more»
There needs to better support of external version control software, currently only SVN is present, but I hear the GIT is planned in future patch. From a DevOps point of view it would be useful to add better separation between ‘code’ and... more»
ODI has the ability to connect to virtually any technology out there. If it does not connect out-of-the-box, we can very easily add a new technology into it. This flexibility gives a tremendous developmental advantage to its users, which can... more»
We use ODI to integrate all Oracle EPM suite used in our financial area. ODI is the core engine used to move data across different applications every day. It’s by far the most important architectural element in our BI/EPM environment since... more»
In my opinion, ODI should connect to ALL Oracle products out-of-the-box, but currently that’s not the case for all of them. Hyperion Financial Management (HFM) is one of the Oracle products for which Oracle decided to remove its ODI support... more»
I don't know if this is because of us or because of the tool, but sometimes I had a problem with the agent getting held up. I would come in and my jobs would be failing. Now I have implemented a script to bounce the agent nightly and this... more»
The ODI topology and designer are the most valuable features. The topology gives me total freedom in switching between technologies / ETL agents. The mapping designer gives me a good graphical overview of ETL mappings.
Overall performance needs improvement. Especially when running ODI clients on Windows desktops. ODI seems to generate a lot of network traffic. ODI Studio can be very slow. Objects (mappings, packages, tables, etc.) can take minutes to open... more»
Flexibility, ease of customization, extensive features, ease of deployment, and the ability to access to all kinds of different source system technologies. No need for extra hardware for transformation step. Easy to learn & develop. Now,... more»
It helped me to reduce a slowly changing dimensions type 2 with the same output, from 22,000 seconds to 168 seconds. Loaded 10.000+ files to a table from 1000+ different sources under 20 minutes with approximate 300GB of data per day.
The main problem with ODI is that you have to create each step of the transformation as a new interface. A big data flow can have more than 100 interfaces, which can make it difficult to trace the data. However, in v12, this approach changed... more»
The most value feature of this product are the Knowledge Modules. Oracle Data Integrator comes with a comprehensive library of Knowledge Modules that helps automate the data flow, reduce the learning curve, and shorten the implementation time.
I would like to see in the next version/release the ability to scale a package workflow or data flow process during the execution at run time. Once a workflow is developed, a snapshot of the code is taken and a scenario is created. It is the... more»
What do you think of Oracle Data Integrator (ODI)?
It is an ETL tool, which does the extract, transform, and load.
• Room for Improvement
At this point we are seeing what we need, so I don't know if there is anything, any big improvements that are needed. This is basically just transforming and loading the data. It's doing its job. I rate it a seven out of 10 because there is room for growth because ODI is still new, in comparison to Informatica, which is a mature product.
• Use of Solution
We have been using it now for two years.
• Stability Issues
So far it has provided what we need, it's working fine.
• Scalability Issues
It's scalable. Right now, we have a pilot project that we started with ODI, which went fine. We will be ramping that up for the other integrations and hopefully that will...
The most valuable feature is that it's bundled with all the other Oracle products. We use the ODI with BI Apps. It does all the ELT along with our data warehouse for BI purposes. That’s good. It comes as a bundled package. If we want to use... more»
I would like to see them make some more improvements on the troubleshooting side, to help with the troubleshooting because right now, the errors are not very clear. I think they are already working on it; it's in the latest release, but yet... more»
Oracle Data Integrator (ODI) Specialist at a tech services company with 501-1,000 employees
What do you think of Oracle Data Integrator (ODI)?
It is a clever integration tool to extract data from every possible source, and it can transform the source data to a format the targets can handle. It is suitable for data warehouses and data migrations.
• Improvements to My Organization
We replaced many manual actions and tasks with mappings in Oracle Data Integrator, and created schedules, and then used SOA Suite services to automatically transfer large data amounts between different systems.
• Room for Improvement
The integration between the Oracle Repository and versioning tools like TortoiseSVN.
• Use of Solution
We’ve used 11G for four years, and 12.1.3 for two years.
• Deployment Issues
One of the benefits of it is the usage of the principle ‘write once, execute anywhere’. You set up the...
v12 has good features, but it needs to be certified with Hyperion EPM. Also, the Knowledge Module needs to be improved because it is the backbone of ODI. When we change the Knowledge Module, Oracle will not support the change in production.
I like the Briefing Book feature as it enables measures to be filtered and viewed easily based on different criteria. Managers may create their own books to manage their own areas of responsibility, and setting the books up is easy, and all... more»
Management review meetings are shorter, as all managers are able to review performance data on the same scorecard database prior to their meetings. They come to the meeting prepared with solutions to problems.
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... more»
Over 8 years experience as project manager
Over 10 years experience with database analysis and data mining
Over 8 years of PL/SQL, HTML, and Java Scripting
Over 6 years experience with Oracle, DRM, Oracle Data Integrator and other ETL tools
Over 3 years experience with using ESSBASE... more>>
EPM/BI certified Consultant, Oracle ACE and TeraCorp Consulting CEO
Ricardo has been leading and developing EIS/EPM/BI/DSS applications for over 20 years including 10+ years of Hyperion-specific experience (the last 9 years in global projects to a fortune 100 client).
His core expertise is on design, development, and optimization of Business Intelligence... more>>
• Honored as Oracle ACE Director on Business Intelligence expertise.
• Awarded as Oracle Excellence Awards, Technologist of the Year 2011 : Enterprise Architect. (formerly known as - Oracle Magazine's Editors' Choice of Awards : Enterprise Architect of the Year 2011)
• Presented at Oracle Open... more>>
Big Data / Business Intelligence / Datawarehousing
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),... more>>
Jérôme is a DW/BI consultant at Rittman Mead and an ODI enthusiast. Analyst, architect and developer, he built expertise with Oracle Data Integrator, Oracle Warehouse Builder and Oracle Business Intelligence Enterprise Edition. He also delivers Oracle Data Integrator trainings for Rittman... more>>
I love data. I love to categorise it, manipulate it, study it, and share it. Data Warehousing is how I satisfy this love and Business Intelligence is how I show it to others. Any type of data - music, words, pictures, numbers, ...
Specialties: Data modeling, data architecture, ETL, Cognos... more>>
IT professional graduated in computer engineering with extensive experience in the Business Intelligence (BI) area. Deep knowledge in Oracle technology and ETL processes working with Oracle Data Integrator (ODI), Enterprise Performance Management (EPM) and BI tools as a lead consultant and... more>>
As Technical Advisor, Michael spends his time developing the training program at Gluent and sharing the good word about Gluent products with the world. His expertise in data integration technologies enable him to provide a unique perspective to customers. In his spare time, Michael, an Oracle ACE... more>>
I am a highly qualified Data Analyst and BI Specialist with almost 20 years of experience in IT and a thorough understanding of contemporary business models.
My major areas of interest are Enterprise Data Warehouse and Business Intelligence solutions.
I am also a big fan of Scrum. I have... more>>
Vast experience in IT, having been involved in the sales & marketing of IT hardware and eventually moving more into the distribution of software, from Microsoft Office solutions, to SPSS statistical software, and finally to analytics.
As a consultant, I enjoyed working with governments of... more>>
Not sure which Datacenter Virtualization solution is right for you?Download our free Datacenter Virtualization Report and find out what your peers are saying about Oracle, Microsoft, OpenText, and more!