Chart Key
Average Rating
Average rating based on reviews
Views
Number of total page views
Comparisons
Number of times compared to another product
Reviews
Total number of reviews on IT Central Station
Followers
Number of followers on IT Central Station
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.

Datacenter Virtualization Reviews

Read top reviews of Datacenter Virtualization solutions from the IT Central Station community:
Your trust is our top concern, so companies can't alter or remove reviews.
Consultant
Technical Advisor at Gluent Inc
Oct 31 2016

What is most valuable?

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»

What needs improvement?

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»
Consultant
Oracle Business Intelligence Consultant at a tech consulting company with 51-200 employees
Aug 24 2017

What is most valuable?

It allows us to use many languages to develop and to integrate practically all the technologies of the Oracle suite as well as those from non-Oracle vendors.

How has it helped my organization?

My organization develops solutions using all the Oracle EPM products, and ODI has helped us to integrate all the different technologies.

What needs improvement?

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.

Have A Question About Datacenter Virtualization?

Our experts can help. 279,835 professionals have used our research on 6,323 solutions.
Consultant
EPM/BI certified Consultant, Oracle ACE and TeraCorp Consulting CEO at a consultancy with 1,001-5,000 employees
Jun 04 2018

What is most valuable?

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»

How has it helped my organization?

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»

What needs improvement?

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»
Real User
Manager of Architecture/Design with 51-200 employees
Mar 28 2017

What is most valuable?

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»

How has it helped my organization?

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»

What needs improvement?

Development is simple. I wish overall implementation and debugging were made simpler.
Consultant
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...
Consultant
Big Data / Business Intelligence / Datawarehousing at a tech services company with 51-200 employees
May 09 2018

What is most valuable?

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... more»

How has it helped my organization?

All projects where I have implemented ODI solution highly benefited of high data volume integration.

What needs improvement?

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 for the web service feature to be improved in next versions, so at last the 12C... more»
Real User
Director - Special Projects at Sandals Resorts International
Dec 12 2016

What is most valuable?

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»

How has it helped my organization?

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»

What needs improvement?

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»
Consultant
Principal and Owner at Sandwich Analytics
Sep 28 2016

What is most valuable?

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»

How has it helped my organization?

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»

What needs improvement?

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»
Real User
Database Administrator at Tarrant County College
Dec 08 2016

What is most valuable?

The most valuable feature is being able to schedule the jobs, especially when they're multi-step.

How has it helped my organization?

I don't know why we have different database environments, but we do. The business wants the data to be collected in one place, so they can do reporting and so on.

What needs improvement?

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»
Real User
Architect (Datawarehouse / BI) at a financial services firm with 1,001-5,000 employees
Oct 02 2016

What is most valuable?

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.

How has it helped my organization?

The speed in which we create/generate our ETL mappings has increased by at least a factor of four as compared to Oracle Warehouse Builder.

What needs improvement?

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»
Consultant
Enterprise DWH Architect - Oracle ACE Director at Ekol Logistics Corp.
Mar 24 2017

What is most valuable?

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»

How has it helped my organization?

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.

What needs improvement?

They need to work on the multiuser development environment and include the ability to comply with different kinds of SDLCs.
User
Development Manager
Nov 22 2017

What do you think of Oracle Data Integrator (ODI)?

Valuable Features 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...
Real User
Senior System Administrators Admin at American Tower
Nov 03 2016

What is most valuable?

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»

How has it helped my organization?

The learning curve is a little less because if you are already in the ELT business, you know how it works. Overall, it's good.

What needs improvement?

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»
Real User
I/T Sr. Software Engineer at a insurance company with 1,001-5,000 employees
Jul 27 2016

What is most valuable?

ODI is integrated with Hyperion Planning, Essbase and other Oracle products. Data transfer is also easy since ODI already knows the metadata of these applications between the different databases. There is also ease of development in terms of... more»

How has it helped my organization?

We hadn’t upgraded in a long time, so all of our business users were creating their own solutions with spreadsheets, for example. We realized we were behind and purchased a whole stack of Oracle products that have simplified the way we move... more»

What needs improvement?

It would be nice to improve reconciliation. Additionally, better external authentication support through Microsoft Active Directory would be useful. Right now, it doesn’t support this very well. You have to buy Oracle’s special product instead.
Consultant
Consultant - Oracle ACE with 51-200 employees
Aug 25 2017

What is most valuable?

The EL-T approach that will first load into the target dataserver before doing the transfer is a great architecture improvement compared to standard ETL tools that use a staging area and usually process the data in Java. With ODI, almost all... more»

How has it helped my organization?

Thanks to the flexbility of the tool, we could build 3 mappings using variables and the substitution API in replacement of 300 mappings in Oracle Warehouse Builder. It's much easier to maintain!

What needs improvement?

- Development Lifecycle - native REST integration - Easier security
Real User
IT-Services Asset Management at a tech services company with 51-200 employees
Aug 08 2017

What do you think of Oracle Data Integrator (ODI)?

Improvements to My Organization It replaced Oracle Warehouse Builder. • Valuable Features After several years of developing with ODI, the most useful feature is the combination of package-scenarios and load plans (scheduling of ETL). This combination, together with a generally productive development-environment, makes ETL programming very productive. • Room for Improvement Although very logically structured (which is very good), the GUI is a very old-fashioned, fat client that should be renewed. • Stability Issues In our version, we have two serious topics: ODI agent suddenly stops without notifications. It just stops working. Often it errors when ODI writes into its "own" repository. • Scalability Issues We have not encountered any scalability issues. •...
Real User
Product Owner, Lead Entrepreneur and Chief Technology Officer(CTO) at a think tank with 1-10 employees
Jan 21 2018

What is most valuable?

It can integrate with more recent databases like Cassandra, Hadoop, and other more recent Big Data databases. Going forward, that is very important.

How has it helped my organization?

The tool is declarative, and it only runs on the target staging databases, so I have full control over it and I can change the SQL that the tool generates. I do not have to maintain a separate ETL instance. I can change the SQL when something... more»

What needs improvement?

When I do a BI type of project, I like to pick the simplest declarative solution that I can find. So ODI appeals to me at a base solution level, but that sometimes puts a lot of burden on me personally to fix all of the nuances of the... more»
Consultant
Software Engineer at a tech services company with 1,001-5,000 employees
Aug 28 2016

What is most valuable?

The tool has a in-built "Knowledge Modules" using Oracle ADF, and this provides by default, all possible databases and technologies for data integration, such as file system, Oracle RDBMS, Teradata, and Microsoft SQL Server. This ensures that... more»

How has it helped my organization?

We had a customer whose core business was a logistics suite. ODI was used for their reporting purpose in some key BI reports such as "Container Load Plan (CLP) Reports", "Master Data Management Reports", "Business Partner Reports - Non... more»

What needs improvement?

Although we're satisfied with its overall performance in terms of integrity, scalability, and usability, it could be improved by including a separate UI for viewing the session runs through the operator layer of ODI. They could also reduce... more»
Real User
Senior Technical/Team Lead at a tech services company with 51-200 employees
Jul 29 2017

What do you think of BizTalk Server?

Valuable Features The feature of mapper design and orchestration with Visual Studio is valuable for us. • Improvements to My Organization This solution has enabled our IT department to connect all our systems together without the need to modify these systems. • Room for Improvement Features which could be improved include sending JavaScript Object Notation (JSON) and receiver ports (which was added later). • Use of Solution We have been using the solution for over a year. • Deployment Issues The deployment package is very easy, but if you have isolated host services like WCF or Web Services on IIS, then you will need to perform some additional manual deployment. • Stability Issues We did not encounter any issues with stability. • Scalability Issues ...
Real User
Assistant Manager at a integrator with 501-1,000 employees
May 16 2017

What do you think of Oracle Data Integrator (ODI)?

Valuable Features I have found most of the Oracle Fusion middleware and hardware to be valuable. • Improvements to My Organization We are Oracle partners. We have our clients and they need this solution. We implement it according to the clients' requirements. • Room for Improvement I think that the Oracle Fusion Middleware stack could be improved. • Use of Solution I have used it for almost ten years. • Deployment Issues I had some deployment issues. Sometimes, issues will be erased if the OS and the system do not meet the system requirements and prerequisites before deploying a specific application. • Stability Issues I did not encounter any stability issues. • Scalability Issues I did not encounter any scalability issues. • Customer Service and...

Have A Question About Datacenter Virtualization?

Our experts can help. 279,835 professionals have used our research on 6,323 solutions.

Datacenter Virtualization Articles

EPM/BI certified Consultant, Oracle ACE and TeraCorp Consulting CEO at a consultancy with 1,001-5,000 employees
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»
reviewer145365Hi Ricardo, It would of great help if you can give some tips on loading... more»
Ricardo GiampaoliHi Moses how are you? I usually try to avoid XML as much as I can since XML... more»
2,880
Lead Consultant
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>>
3,644
TOP 5POPULAR
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>>
1,325
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>>
894
Consultant - Oracle ACE
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>>
Reviewed Oracle Data Integrator (ODI): With the Knowledge Modules, we're able to create our...
2,527
Principal Consultant
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>>
1,988
TOP 10POPULAR
Business Intelligence Consultant
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>>
Reviewed Oracle Data Integrator (ODI): It allows us to create scripts and share them across...
299
Sr. Consultant - Software Development
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>>
Reviewed Oracle Data Integrator (ODI): If it doesn't connect out-of-the-box to a specific...
1,620
Enterprise DWH Architect - Oracle ACE Director
• 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>>
Reviewed Oracle Data Integrator (ODI): A tool that can talk or learn how to talk, with any...
1,656

4
TOP 10POPULAR
Technical Advisor
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>>
Reviewed Oracle Data Integrator (ODI): ODI is a flexible tool that can adapt to fit your...
1,230
Principal and Owner
"A highly talented and experienced Business Intelligence and Data Warehousing consultant with the ability to cross the divide between technical and business consulting" I have a great passion about data and its value to a business; this is reflected in my blog writings and conference... more>>
Reviewed Oracle Data Integrator (ODI): I can readily develop processes that use relational,...
249
- Involved in designing, development and implementation of Business Intelligence (BI) and analytics systems, working with technical resources to design and model the data warehouse systems. - Assisting in developing BI reports and analysis applications, providing optimal and cost-effective... more>>
Reviewed Oracle Data Integrator (ODI): The features that we have applied to our project...
257
Director & Lead Consultant
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>>
Reviewed OpenText Actuate Information Hub: The Briefing Book feature enables measures to be...

Sign Up with Email