Oracle Data Integrator for Oracle Business Intelligence - license - Named U

Mfg.Part: L100376 | CDW Part: 4271119 | UNSPSC: 43232304
Availability: In Stock
Was $690.00
$549.00 Advertised Price
Advertised Price
Lease Option ($16.59/month) Lease Price Information
Note: Leasing is available to businesses only. Leasing is not available to individuals.
Product Details
  • License
  • Named User Plus
  • UNIX
  • Win
View Full Product Details
Better Together
Oracle Data Integrator for Oracle Business Intelligence - license - Named U
Quick View
Total Price:

Product Overview

Main Features
  • License
  • Named User Plus
  • UNIX
  • Win
Oracle Data Integrator is a comprehensive data integration platform that covers all data integration requirements: from high-volume, high-performance batch loads, to event-driven, trickle-feed integration processes, to SOA-enabled data services. Oracle Data Integrator provides superior developer productivity and improved user experience with a redesigned flow-based declarative user interface and deeper integration with Oracle GoldenGate. ODI further builds on its flexible and high-performance architecture with comprehensive big data support and added parallelism when executing data integration processes. It includes interoperability with Oracle Warehouse Builder (OWB) for a quick and simple migration for OWB customers to ODI. Additionally, ODI can now be monitored from a single solution along with other Oracle technologies and applications through the integration with Oracle Enterprise Manager.

Oracle Data Integrator for Oracle Business Intelligence - license - Named U is rated 3.9 out of 5 by 31.
Rated 4 out of 5 by from I have found most of the middleware and hardware to be valuable. 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.Technical Support:I would give technical support a rating of 10/10.Previous Solutions:We have always used Oracle because we are Oracle partners.Initial Setup:The initial setup was straightforward.Implementation Team:I performed the implementation. If there was something that I was unsure about, I contacted the support team for clarifications and update patches. Overall, it depends on the situation and the time frame.ROI:I have seen a decent ROI for the Oracle and Veritas Backup Exec products.Other Solutions Considered:We looked at alternatives, but they could not provide us with the complete set of features.Other Advice:This is a good solution if they are trying to move to fusion stack.Disclaimer: My company has a business relationship with this vendor other than being a customer:We are Oracle partners
Date published: 2017-05-23
Rated 4 out of 5 by from One of the benefits of it is the usage of the principle ‘write once, execute anywhere’. Valuable Features: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 architecture in the topology within Oracle Data Integrator.Stability Issues:We've experienced no issues with performance.Scalability Issues:We haven't needed to scale it yet.Technical Support:We haven't needed to use it yet.Previous Solutions:Previously we used Oracle Warehouse builder, and custom made PL/SQL data warehouses. We’ve chosen Oracle Data integrator over other solutions because it is the successor of Oracle Warehouse builder, and Oracle Data Integrator provides a more structured working-method, and the data warehouse is easier to maintain.Initial Setup:The installation is rather straightforward, with the available documentation it must be possible to do the installation by yourself. You must have sufficient knowledge of Oracle Data Integrator to make the correct decisions during the creation of the architectural setup.Implementation Team:We used an in-house team but hired interim experts, and created a team with combined knowledge levels, from rooky to expert. The initial setup is rather complex, and needs an experienced architect to make the correct decisions. The change of success is highly depending on the decisions that are made during the setup.Cost and Licensing Advice:I have no info on the ROI or the licensing, but I know the license costs are high, so Oracle Data Integrator is only suitable for the larger companies.Other Advice:To benefit the most of Oracle Data Integrator it is important to assemble a team with the experience to make the project a success.Disclaimer: I am a real user, and this review is based on my own experience and opinions.
Date published: 2017-03-23
Rated 1 out of 5 by from The GUI is extremely unstable and slow. Setup is complex. Valuable Features:ODI objects packages, loadplans, scenarios (parallelisation)Export, import functionalityProceduresCDCImprovements to My Organization:It replaced Oracle Warehouse Builder.Room for Improvement:* Scheduling via loadplansUse of Solution:I have used it for 1.5 years.Deployment Issues:We have not encountered any deployment issues.Stability Issues:Although very logically structured (which is good!), as such, the GUI is extremely unstable and slow. It's a very old-fashioned, fat client. Oracle should be given a ROOTTEN TOMATO for it. Just compare it yourself with the "luxury" UI Pentaho Kettle, which is free, or Integration Services.Scalability Issues:We have not encountered any scalability issues.Customer Service:Customer service is good.Technical Support:Oracle's consultant is very good, but is most of the time overbooked and sits in an other country, which is very problematic during difficult project phases.ODI know-how is rare, so there is also not much information on the internet.Previous Solutions:We previously used Oracle Warehouse Builder. (We switched because it was suddenly not supported.)Initial Setup:If you know Oracle, then you know setup is always NOT straightforward AND complex.Implementation Team:A combination in-house/vendor team implemented it.Cost and Licensing Advice:There isn't really a lot of ROI; it is very expensive (after bargaining).Other Solutions Considered:Before choosing, we did not evaluate other options; we were forced by system needs.Other Advice:Compare it to other tools that are out there, and with comparison, I mean ignore everything you read; ignore sales evangelists.Test installation; test complex mappings; test deployment; test, test, test before you buy.Disclaimer: I am a real user, and this review is based on my own experience and opinions.
Date published: 2017-02-07
Rated 4 out of 5 by from The user interface is the most valuable feature. It is intuitive. Valuable Features: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 been able to understand a lot more about the direction Oracle is heading through the tool. It was very intuitive. It helps to have a good background in data manipulation, but it's very intuitive and has given a good appreciation of what the tool can do.Improvements to 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 came with Oracle. We’re able to easily go in and modify and correct any anomalies that we have.Room for 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 with Informatica. It could be because there aren't enough self-study or self-research resources related to the product. That surely could be improved in the near term.Use of Solution:We've had it implemented for two years.Stability Issues:Any stability issues I've had, have been related to the data itself. It really depends on how whomever has implemented the product. If it stands up, it works well.Technical Support:We get very good and very timely response from technical support. Maybe, we just don't have very complicated questions, but we get very, very good response; very quick answers.Previous Solutions:We decided to move away from Informatica after we attended an Oracle conference about three years ago. We learned a lot more about where Oracle was going with it. One of the key reasons was not just moving forward with the newer technology; it was also because of the compatibility with the applications we use versus the applications that were available in Infomatica.We have the capability to extend it to other data sources, all of the non-standard data sources. We don't have to build out huge data structures in order to feed them in through Infomatica. We can read Excel spreadsheets and a bunch of other sources.Initial Setup:As a customer to a consultant team, I was involved in the installation and deployment of ODI. There were some challenges, which was probably due to the relative inexperience of the team that handled it. Eventually, they were able to get through it. Fortunately, my internal team as costumers were also able to do our research and participate in that discovery, too.Other Advice:You would have to evaluate what your key purpose is, and your existing, internal talent and experience. It's my belief that you should always try to have internal talent that is very confident, rather than having to always rely on consultants. If your talent has the experience in Infomatica – I don't think Infomatica is going anywhere – then it might be the best choice for you. I don’t think your office will fall apart. I think you have to evaluate which one will work for you.We were new customers to data integration, so we decided to go with newer technology that had already come from the same source.Disclaimer: I am a real user, and this review is based on my own experience and opinions.
Date published: 2016-12-19
Rated 4 out of 5 by from With the Knowledge Modules, we're able to create our own reusable integration strategies for connecting to RDBMS, Hadoop, cloud services, etc. Valuable Features: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 the job is pushed down on the underlying technology, for instance the Oracle database or the Spark server.The Knowledge Module approach provides an easy and reusable way to create our own integration strategies. It's easy to create these Knowledge Modules to connect to new technologies, for instance.ODI is really the tool for any kind of integration because it speaks the language of the technology we connect. We can work with RDBMS but also in Hadoop, cloud services, flat files, web services, etc.Improvements to 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!Room for Improvement:- Development Lifecycle- native REST integration- Easier securityUse of Solution:5 yearsStability Issues:A bit unstable and buggy in the 12.1.2 release, but most of it is fixed in 12.1.3, so I would definitely recommend to jump to that version.Previous Solutions:I used Oracle Warehouse Builder (OWB) which is now at the end of its life. ODI is much more flexible and has the great advantage to be able to connect to a lot of different source or target technologies.Initial Setup:It was quite straightfoward.We did a migration for Oracle Warehouse Builder to Oracle Data Integrator 12c using the migration tool provided by Oracle. And I've to say I'm surprised to see a migration tool working so well!Implementation Team:In-houseDisclaimer: I am a real user, and this review is based on my own experience and opinions.
Date published: 2016-11-23
Rated 4 out of 5 by from It has helped identify data quality issues in upstream source systems. As a result, data quality rules have been implemented in order to capture them during data entry. Valuable Features: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.Improvements to My Organization:The use of this product has helped identify data quality issues in upstream source systems. As a result, data quality rules have been implemented in order to capture them during data entry.Room for Improvement: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 scenario that is executed during run time. In order to add a step to the package workflow, you must modify it and re-create another scenario. Thus, making such changes to package workflow can impact other packages that are dependent.Use of Solution:I have used this product for more than 13 years. I was first exposed to this product back in 2003. Before Oracle Corporation purchased the product, it was formerly known as Sunopsis. I learned to develop workflow packages with version 3.Deployment Issues:We experienced no issues with the deployment.Stability Issues:It’s a perfectly stable product and we’ve not experienced any issues.Scalability Issues:We have been able to scale it for our needs.Technical Support:Oracle technical support for this product is excellent.Initial Setup:Although the initial setup was straightforward, you must decide if you will create one schema for the master and work repository or separate schemas. However, the product provides a step-by-step menu-driven UI, which makes the installation a breeze.Implementation Team:The implementation was done by both a vendor and internal resources. In addition, name standards for objects (e.g., packages, scenarios, procedures) should be considered and each package should be design independently from other packages (e.g., Modular Programming).Other Solutions Considered:MS SQL Server Integration Services (SSIS) was considered. However, the internally-preferred vendor company was Oracle. The availability of a license and expertise in product usage helped in the decision-making process.Other Advice:The most important decision is the deployment strategy of the Master and Work Repositories that is the use of Single or Multiple Master Repositories. The company’s internal policy will determine which strategy can be used. However, the most common implementation I have seen is multiple master and work repositories. It performs and works as advertised.Disclaimer: I am a real user, and this review is based on my own experience and opinions.
Date published: 2016-11-08
Rated 5 out of 5 by from A tool that can talk or learn how to talk, with any database or operating system in its own language. Valuable Features: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.Oracle Data Integrator (ODI) can support any type of databases that has a jdbc driver in a native way. I have accessed and retrieve data from an Ingress database.Knowledge Module architecture helps you to build your data integration activities with less effort.You can switch to source, staging area or target to improve your querying performance. If you have to do a join from different source systems, you can decide which data to move to where and figure out the place for best output.Variables can help you to perform loops and conditional statements in packages for helping ETLImprovements to 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.Room for Improvement:They need to work on the multiuser development environment and include the ability to comply with different kinds of SDLCs.Use of Solution:I've been using it for more than 10 years, since Oracle acquired Sunopsis.Deployment Issues:There were no issues with the deployment.Stability Issues:I've experienced no issues with performance. Since sky is the limit, you can do what you want to do within ODI in several ways.Scalability Issues:It's been able to scale for our needs. ODI will fit your needs.Customer Service:10. I generally create a service request per year and they are being solved within a week.Technical Support:They're very efficient.Previous Solutions:We switched because of ODIs impressive increasement in development productivity.Initial Setup:It was straightforward and very easy. Almost the same as setup>next> next>next.Implementation Team:In-house.ROI:Worth every penny.Cost and Licensing Advice:There are various options in licensing, either per seat or per target core count. It depends how you want to use it.Other Solutions Considered:We also looked at Informatica Power Center, AbInitio, Business Objects Data Integrator (BODI), and SQL Server Integration Services (SSIS).Other Advice:If you want a robust, flexible solution with no extra hardware that is easy to learn, then ODI is the right product for you. ODI is a tool, that can talk or learn how to talk, with any database or operating system in its own language. This is the power of ODI.Disclaimer: IT Central Station contacted the reviewer to collect the review and to validate authenticity. The reviewer was referred by the vendor, but the review is not subject to editing or approval by the vendor. The reviewer's company has a business relationship with this vendor other than being a customer:Partner
Date published: 2016-10-31
Rated 4 out of 5 by from 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. Valuable Features: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.Improvements to My Organization:My organization develops solutions using all the Oracle EPM products, and ODI has helped us to integrate all the different technologies.Room for 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.Deployment Issues:There are some difficulties in moving a repository from an environment to a different one due to the internal numbering through which ODI references the objects belonging to a repository. This often causes troubles in the porting, and for this reason you always must pay attention during this operation.Stability Issues:I encountered many problems with the ODI web agent (service that actually executes all the integration tasks) in the 11g version, which was not stable. For this reason, I always suggest using the standalone agent instead of the web one, mostly due to the fact that they do not have significant differences.Scalability Issues:Scaling issues depend mostly on the tools that ODI uses to integrate the technologies. For example, if the number of records inside a table, which is the source of an integration task, increase greatly, the performance of the ODI integrating flows may degrade a lot. Their tuning, by the way, depends on the database (i.e. table partitioning, indexes or hints).Customer Service:I only experienced once the customer service provided by Oracle on ODI and was supported by capable and helpful people.Technical Support:The level of technical support is quite good. Apart from the first approach used to identify if the problem you are pointing out is a real issue or not, the second level support is really efficient and comprised of competent and clever people.Initial Setup:The initial setup is not really easy. To use ODI you must:* Install the ODI studio (client)* Create and configure a master and a work repository to develop on them, being sure that they can reach the database schemas you’ll work on (relational structures involved in the integration)* Install and configure an agent (if you need to communicate with more than a server and to schedule integration tasks), choosing properly where you need it and opening all the communication doors to allow it to reach all the parts of your architectureImplementation Team:I implemented it with an in-house team, since my company is a consultancy and also an Oracle partner.Even if ODI allows implementing a very smart solution with an high level of customization, I think that keeping the model of what you are developing as simple as possible is always the best choice. This is due to its future maintenance. Keep in mind that, even if you may be a very keen developer and you can propose the best and most parametric solution ever, if another (less expert) person inherits the responsibility of what you have developed, they may encounter difficulties in solving problems. For this reason, the easier you keep the complexity or technicalities of what you have created, the better it is.This is also valid for performance - one of the basic rules of the informatics development is “divide et impera”, which means that you should always try to create “objects” as small as you can to improve performance and to be able to identify quickly where a problem is.Cost and Licensing Advice:Being an ODI developer, I never had to pay for this product. I know that the pricing/licensing is not really low, but the product is really good.Other Solutions Considered:I tried many integration tools, both Oracle and other vendors. I think that ODI is one of the most complete and open solutions, since it can work with almost any technology and it gives you the ability to develop the same solution in a wide variety of ways depending on the one you prefer.Other Advice:Always keep in mind that ODI offers a huge number of solutions to any task you are developing. There is not a best practice in solving a problem; being able to identify the best solution for your particular problem is up to you and it may also be difficult to identify. This does not mean that the solution you have in mind is not correct.Always try to maintain an ordered environment, keeping only what you really need, and perhaps organizing the items in different projects or folders, or even different work repositories.Disclaimer: My company has a business relationship with this vendor other than being a customer:My company is an Oracle partner, and we develop with all Oracle business intelligence products.
Date published: 2016-10-31
  • y_2018, m_12, d_17, h_14
  • bvseo_bulk, prod_bvrr, vn_bulk_2.0.9
  • cp_1, bvpage1
  • co_hasreviews, tv_0, tr_31
  • loc_en_US, sid_4271119, prod, sort_[SortEntry(order=SUBMISSION_TIME, direction=DESCENDING), SortEntry(order=FEATURED, direction=DESCENDING)]
  • clientName_cdw