TrustRadius: an HG Insights company

Oracle Enterprise Data Quality

Score9.5 out of 10

11 Reviews and Ratings

What is Oracle Enterprise Data Quality?

Oracle Enterprise Data Quality is, as the name would suggest, a data quality offering from Oracle for enterprises.

Categories & Use Cases

Top Performing Features

  • Data profiling

    Ability to find anomalies and hidden relationships between data elements

    Category average: 8.3

  • Data source connectivity

    Ease of connection to multiple data sources

    Category average: 8.3

  • Master data management (MDM) integration

    Quality of integration with MDM systems

    Category average: 8.6

Areas for Improvement

  • Data element standardization

    Parsing and standardization of data elements according to predefined rules

    Category average: 8.3

  • Match and merge

    Ability to identify potential matches and then merge

    Category average: 8.2

  • Address verification

    Data format checking and valid address checking

    Category average: 8.6

Best Software For Maintaining Data Quality

Use Cases and Deployment Scope

We deal with lot's of customer data and we are using Oracle Enterprise Data Quality to identify and manage duplicate data across our customer database. The software makes it easy to improve data quality. After putting th the data in order, we backup the data to be used when contacting our client or when running marketing campaigns. The software has made it easy to have a single data source containing clean and verified data.

Pros

  • Visualizing data flow is easy.
  • Cleaning data is easy.
  • We are able to solve data quality issues.
  • Setup and using this software is easy.

Cons

  • Data export limitations needs to addressed.

Return on Investment

  • With Oracle Enterprise Data Quality we only backup quality data.
  • We are able to detect data flows and correct them before using th the data.

Alternatives Considered

Informatica Data Quality

Other Software Used

Zoom, Formstack Forms

Trustworthy, Efficient, and Collective Database Manager.

Use Cases and Deployment Scope

Oracle Data Quality remains to be a proficient, substantial, and advanced data support program, that ensures there is security throughout the database, the analytical platform is digitized, and a secure cloud area. Further, the elimination of redundant data and any duplicates makes Oracle Data Quality more demanded. The cleansing of the entire data content acts as a transformational solution that fosters quality support and digitizes every activity. Lastly, there is data connectivity, address affirmation, and reputable communications.

Pros

  • Accuracy of database through quality address verification and certification.
  • Determined sales analytics and procedural evaluation of the business procedures.
  • Extensive data modelling and content mapping.

Cons

  • Oracle Data Quality requires a mobile version, which would apprehend many users.
  • Oracle Data Quality has an inflexible UI, which should be more enhanced.
  • Oracle Data Quality fails to revise prices, which are candid solutions in controlling the number of subscribers.

Return on Investment

  • Details verification, for instance, address ensure the quality of every operation is sustained.
  • Further, sales analytics improves the market share as customers get to apprehend the business needs.
  • Oracle Data Quality has consistent data connectivity, a standard way of improvising business requirements.

Alternatives Considered

Aginity and SAP Data Quality Management

Other Software Used

Barracuda Email Security Gateway, Data Quality Batch Suite, IBM Power System S914

OEDQ makes your life easier!

Pros

  • Address verification helps you filter bad data out and improve your data quality.
  • Strength by DnB enriched information to address the correct customer by address.
  • expert data profiling to help us quickly understand our current data health.

Cons

  • The UI could be more user-friendly for non-tech people.
  • There is always an export limitation due to how EDQ uses an old version of MS Excel as the default export file type.

Return on Investment

  • OEDQ reduces a lot of the manual work to review bad addresses.
  • OEDQ helps to validate similar records and make it easier to keep customer loyalty.

Alternatives Considered

Oracle ERP Cloud and Oracle Engagement Cloud (formerly Oracle Sales Cloud)

Other Software Used

Oracle ERP Cloud

Ease Of Management Within ODI.

Pros

  • Ease of management within Oracle Data Integrator (ODI) and effectivity of EDQ Director
  • Ease of installation with web based client.
  • Data Quality issues solved quickly, easily and jobs are controlled within Oracle Data Integrator (ODI) seamlessly.
  • Setup is straightforward. Java web application (OEDQ Director) helped us for not installing any client application.

Cons

  • Mobile support and mobile app can be implemented, since business users generally prefers to work with not only their laptops, but also mobile phones or tablets.
  • Data profiling could be standalone option instead of OEDQ Director. A business user generally wants to see the format or templated counts or other aggregations based on a full dataset.

Return on Investment

  • Data Quality issues solved quickly, easily and jobs are controlled within Oracle Data Integrator (ODI) seamlessly.
  • Business users created their data quality packages and those packages are called from Oracle Data Integrator easily and merged into data warehouse.
  • OEDQ jobs can be created by not only IT teams, but also business teams. That is why we called a "DQ job is not a part of our development, it is a part of our DWH solution".

Alternatives Considered

Trillium Data Quality and SAS DataFlux

Other Software Used

SAS DataFlux, Trillium Data Quality

Oracle Enterprise Data Quality - versatile and easy to use

Pros

  • Simplifies the data quality aspects.
  • Visualizes data flows.
  • Provides many pre-built processes that are very powerful.
  • Quickstats overview is an amazing tool to quickly understand how bad the data currently is.

Cons

  • Updates are few and far between as this has transitioned to the Cloud and is the core engine for DIPC (Data Integration Platform Cloud).
  • Needs governance around the tool if multiple people are running reports (e.g. if someone is running a process, it locks out other users).

Return on Investment

  • Positive - it is required for clients and for us to understand how bad the data really is - it allows for iterative review and improvement of creating data quality rules
  • Positive - the ease of use and visual review allows us to quickly create the rule set and show (in the tool) how it works. We save a lot of time by not creating powerpoints to explain what is happening.