TrustRadius: an HG Insights company

Microsoft Power Automate vs. Oracle Data Integrator (ODI)

Save this comparison

Save this comparison

Add Product

Recommended Comparisons

    Overview
    ProductRatingMost Used ByProduct SummaryStarting Price

    Microsoft Power Automate

    Score8.5 out of 10
    N/AMicrosoft Power Automate is an advanced automation platform offering a range of features, including AI-powered automation, robotic process automation (RPA), business process automation (BPA), digital process automation (DPA), and process/task mining. The platform aims to empower organizations to securely automate their operations at scale by leveraging low-code and AI technologies.

    $15

    per month per user

    Oracle Data Integrator (ODI)

    Score8.8 out of 10
    N/AOracle Data Integrator is an ELT data integrator designed with interoperability other Oracle programs. The program focuses on a high-performance capacity to support Big Data use within Oracle.N/A
    Pricing
    Microsoft Power AutomateOracle Data Integrator (ODI)
    Editions & Modules
    Power Automate Premium
    $15
    per month per user
    Power Automate Process
    $150
    per month per bot
    Hosted RPA add-on
    $215
    per month per bot
    Process Mining add-on
    $5,000
    per month per tenant
    No answers on this topic
    Offerings
    Pricing Offerings
    Microsoft Power AutomateOracle Data Integrator (ODI)
    Free Trial
    YesNo
    Free/Freemium Version
    YesNo
    Premium Consulting/Integration Services
    NoNo
    Entry-level Setup FeeNo setup feeNo setup fee
    Additional Details——
    More Pricing Information
    Community Pulse
    Microsoft Power AutomateOracle Data Integrator (ODI)
    Considered Both Products
    Microsoft
    No answer on this topic
    Oracle
    No answer on this topic
    Key User Insights
    Would buy again
    93%
    Would buy again
    78 Answers
    90%
    Would buy again
    9 Answers
    Delivers good value for the price
    96%
    Delivers good value for the price
    75 Answers
    88%
    Delivers good value for the price
    7 Answers
    Happy with the feature set
    93%
    Happy with the feature set
    78 Answers
    100%
    Happy with the feature set
    10 Answers
    Lived up to sales and marketing promises
    94%
    Lived up to sales and marketing promises
    51 Answers
    100%
    Lived up to sales and marketing promises
    7 Answers
    Implementation went as expected
    94%
    Implementation went as expected
    58 Answers
    100%
    Implementation went as expected
    8 Answers
    Features
    Microsoft Power AutomateOracle Data Integrator (ODI)
    Data Source Connection
    Comparison of Data Source Connection features of Microsoft Power Automate and Oracle Data Integrator (ODI)
    Feature
    Microsoft Power Automate
    -
    Ratings
    Oracle Data Integrator (ODI)
    9.6
    11 Ratings
    14% above category average
    Connect to traditional data sources00 Ratings9.911 Ratings
    Connecto to Big Data and NoSQL00 Ratings9.39 Ratings
    Data Transformations
    Comparison of Data Transformations features of Microsoft Power Automate and Oracle Data Integrator (ODI)
    Feature
    Microsoft Power Automate
    -
    Ratings
    Oracle Data Integrator (ODI)
    9.9
    11 Ratings
    20% above category average
    Simple transformations00 Ratings9.911 Ratings
    Complex transformations00 Ratings9.911 Ratings
    Data Modeling
    Comparison of Data Modeling features of Microsoft Power Automate and Oracle Data Integrator (ODI)
    Feature
    Microsoft Power Automate
    -
    Ratings
    Oracle Data Integrator (ODI)
    9.2
    11 Ratings
    15% above category average
    Data model creation00 Ratings9.310 Ratings
    Metadata management00 Ratings9.510 Ratings
    Business rules and workflow00 Ratings9.111 Ratings
    Collaboration00 Ratings8.510 Ratings
    Testing and debugging00 Ratings9.311 Ratings
    Data Governance
    Comparison of Data Governance features of Microsoft Power Automate and Oracle Data Integrator (ODI)
    Feature
    Microsoft Power Automate
    -
    Ratings
    Oracle Data Integrator (ODI)
    9.1
    9 Ratings
    12% above category average
    Integration with data quality tools00 Ratings9.59 Ratings
    Integration with MDM tools00 Ratings8.77 Ratings
    Best Alternatives
    Microsoft Power AutomateOracle Data Integrator (ODI)
    Small Businesses
    airSlate WorkFlow
    Score10 out of 10
    Skyvia
    Score10 out of 10
    Medium-sized Companies
    excentia Admin Tools
    Score7.3 out of 10
    IBM InfoSphere Information Server
    Score10 out of 10
    Enterprises
    ServiceNow AI Platform
    Score8.5 out of 10
    SolarWinds Task Factory
    Score8.3 out of 10
    All AlternativesView all alternativesView all alternatives
    User Ratings
    Microsoft Power AutomateOracle Data Integrator (ODI)
    Likelihood to Recommend
    8.6
    (89 ratings)
    8.0
    (29 ratings)
    Likelihood to Renew
    9.3
    (9 ratings)
    10.0
    (4 ratings)
    Usability
    9.0
    (7 ratings)
    -
    (0 ratings)
    Support Rating
    7.9
    (12 ratings)
    -
    (0 ratings)
    In-Person Training
    9.0
    (1 ratings)
    -
    (0 ratings)
    Online Training
    8.9
    (2 ratings)
    -
    (0 ratings)
    Implementation Rating
    8.3
    (39 ratings)
    7.0
    (1 ratings)
    Configurability
    9.0
    (1 ratings)
    -
    (0 ratings)
    Contract Terms and Pricing Model
    10.0
    (1 ratings)
    -
    (0 ratings)
    Ease of integration
    8.5
    (2 ratings)
    -
    (0 ratings)
    Professional Services
    8.0
    (1 ratings)
    -
    (0 ratings)
    Vendor post-sale
    9.0
    (1 ratings)
    -
    (0 ratings)
    Vendor pre-sale
    10.0
    (1 ratings)
    -
    (0 ratings)
    User Testimonials
    Microsoft Power AutomateOracle Data Integrator (ODI)
    Likelihood to Recommend
    Microsoft
    Very useful RPA tools for automating processes with minimal coding and drag-and-drop functionality, with a wide variety of triggers, including scheduled time-based triggers and activity-based triggers, such as modifying a file/list in SharePoint to run a Power Automate flow. Very easy-to-use UI with native integration with every Microsoft product, and a very low automation failure rate for deployed workflows.
    Incentivized
    Read full review
    Oracle
    Oracle Data Integrator is well suited in all the situations where you need to integrate data from and to different systems/technologies/environments or to schedule some tasks. I've used it on Oracle Database (Data Warehouses or Data Marts), with great loading and transforming performances to accomplish any kind of relational task. This is true for all Oracle applications (like Hyperion Planning, Hyperion Essbase, Hyperion Financial Management, and so on). I've also used it to manage files on different operating systems, to execute procedures in various languages and to read and write data from and to non-Oracle technologies, and I can confirm that its performances have always been very good. It can become less appropriate depending on the expenses that can be afforded by the customer since its license costs are quite high.
    Incentivized
    Read full review
    Pros
    Microsoft
    • Sending confirmation email to clients and user once the flow is triggered.
    • Fetching or Dumping files from one location to another if the flow is triggered.
    • Schedule flow helps to send alerts and triggers the flow at a specific interval of time to carry out the required task.
    • Power Automate also be used to convert any file format to a specific file format and save it to the required location
    Incentivized
    Read full review
    Oracle
    • Oracle Data Integrator nearly addresses every data issue that one can expect. Oracle Data Integrator is tightly integrated to the Oracle Suite of products. This is one of the major strengths of Oracle Data Integrator. Oracle Data Integrator is part of the Oracle Business Intelligence Applications Suite - which is highly used by various industries. This tool replaced Informatica ETL in Oracle Business Intelligence Applications Suite.
    • Oracle Data Integrator comes with many pre-written data packages. If one has to load data from Excel to Oracle Database, there is a package that is ready available for them - cutting down lot of effort on writing the code. Similarly, there are packages for Oracle to SQL, SQL to Oracle and all other possible combinations. Developers love this feature.
    • Oracle Data Integrator relies highly on the database for processing. This is actually an ELT tool rather than an ETL tool. It first loads all the data into target instance and then transforms it at the expense of database resources. This light footprint makes this tool very special.
    • The other major advantage of Oracle Data Integrator, like any other Oracle products, is a readily available developer pool. As all Oracle products are free to download for demo environments, many organizations prefer to play around with a product before purchasing it. Also, Oracle support and community is a big advantage compared to other vendors.
    Incentivized
    Read full review
    Cons
    Microsoft
    • Steep learning curve.
    • It can be slow to develop simple solutions compared to other automation platforms such as Smarsheet.
    • Troubleshooting and developing can be frustrating without proper access to edit the code directly.
    • Only able to edit through the GUI and with expressions.
    • Many ways to do the same thing can be frustrating when you need to rework your flow.
    Incentivized
    Read full review
    Oracle
    • ODI does not have an intuitive user interface. It is powerful, but difficult to figure out at first. There is a significant learning curve between usability, proficiency, and mastery of the tool.
    • ODI contains some frustrating bugs. It is Java based and has some caching issues, often requiring you to restart the program before you see your code changes stick.
    • ODI does not have a strong versioning process. It is not intuitive to keep an up to date repository of versioned code packages. This can create versioning issues between environments if you do not have a strong external code versioning process.
    Incentivized
    Read full review
    Likelihood to Renew
    Microsoft
    The tool is very useful when used with its various native connectors, taking great advantage of the integration between the components and systems of the Office365 universe. However, its cost is still high, and automation using more advanced components containing AI resources becomes unfeasible for some companies. Due to the financial crisis that many companies are currently experiencing, investment in automation systems or tools is taking a back seat.
    Incentivized
    Read full review
    Oracle
    It is maturing and over time will have a good pool of resources. Each new version has addressed the issues of the previous ones. Its getting better and bigger.
    Read full review
    Usability
    Microsoft
    Power Automate features a clean and intuitive user interface that allows users to create, manage, and monitor workflows easily. The UI is designed to be accessible to both technical and non-technical users, with drag-and-drop functionality for building workflows. Power Automate supports integration with a wide range of Microsoft and third-party applications. This flexibility in integration allows users to automate workflows across various systems, enhancing overall productivity and efficiency.
    Incentivized
    Read full review
    Oracle
    No answers on this topic
    Support Rating
    Microsoft
    both Community support and Microsoft official support typically respond to (and resolve) reported issues in a VERY expedient manner, usually going above and beyond for education and bugfixing. I have been thoroughly impressed with the level of support I had been provided in the past.
    Incentivized
    Read full review
    Oracle
    No answers on this topic
    In-Person Training
    Microsoft
    after reviewing the main features of Power Automate, the Microsoft trainer focused on some of our real life use cases implementation, from simple to more advanced.
    Incentivized
    Read full review
    Oracle
    No answers on this topic
    Online Training
    Microsoft
    although it was productive, it is more difficult to stay focused and in a 7 hours a day online training (including screen share issues and the fact that the trainer just can't precisely show the exact location of your mistake)
    Incentivized
    Read full review
    Oracle
    No answers on this topic
    Implementation Rating
    Microsoft
    Overall, our experience implementing Microsoft Power Automate has been positive, with a relatively low barrier to entry and a fast time-to-value—especially because it integrates natively with Microsoft 365, which we were already using extensively. With Respect to migration, I had a very good experience where existing workflows were reviewed and simplified. Unnecessary steps were removed. Business rules were reimplemented using Power Automate logic. We migrated Approval workflows, email-based notifications, SharePoint-centric processes, and simple integrations.
    Incentivized
    Read full review
    Oracle
    No answers on this topic
    Alternatives Considered
    Microsoft
    Microsoft Power Automate is worlds ahead of Zapier in so many ways. The looping, DOM access, and flow controls are much better. I feel that accessing different data within previous connectors used in a flow is much easier in Microsoft Power Automate as well. The custom connector creation process is a lot more pleasant in Microsoft Power Automate. The DateTime data type is handles MUCH better in Microsoft Power Automate, which is reason enough to use it.
    Incentivized
    Read full review
    Oracle
    I have used Trifacta Google Data Prep quite a bit. We use Google Cloud Platform across our organization. The tools are very comparable in what they offer. I would say Data Prep has a slight edge in usability and a cleaner UI, but both of the tools have comparable toolsets.
    Incentivized
    Read full review
    Contract Terms and Pricing Model
    Microsoft
    I have not done any participations
    Incentivized
    Read full review
    Oracle
    No answers on this topic
    Professional Services
    Microsoft
    Microsoft's professional services provide hands-on support throughout the implementation lifecycle of Power Automate.This includes initial setup, configuration, integration with existing systems, testing, and deployment. They ensure that workflows are correctly designed, optimized for performance, and aligned with security best practices.
    Incentivized
    Read full review
    Oracle
    No answers on this topic
    Return on Investment
    Microsoft
    • You can automate a lot of process very easy like automatic mails for status updates and such. This will save a lot of time and is more accurate, faster and up-to-date than a user can be.
    • Task approval is centralized and automatic reminders save us a lot of time.
    • The ROI is good if you have a lot of use cases and things to automate
    Incentivized
    Read full review
    Oracle
    • From a business intelligence perspective, it allows us to provide users with the necessary data and information to make informed decisions.
    • Compared with other Oracle products and licensing, I do not think the pricing was unreasonable.
    • It is part of a larger install, so for ease of use, we purchased it with other Oracle products.
    Incentivized
    Read full review
    ScreenShots

    Microsoft Power Automate Screenshots

    Screenshot of Microsoft Power Automate (Interface Screenshot) - Work Queues, Initial pageScreenshot of Microsoft Power Automate (Interface Screenshot) - Signed-in web portal home pageScreenshot of Microsoft Power Automate (Interface Screenshot) - Signed-in web portal create pageScreenshot of Microsoft Power Automate (Interface Screenshot) - Desktop designerScreenshot of Microsoft Power Automate (Interface Screenshot) - Hosted RPAScreenshot of Microsoft Power Automate (Interface Screenshot) - Display of DLP violations (on Run)