Ease Of Management Within ODI.
Gurcan Orhan | TrustRadius Reviewer
Updated April 10, 2019

Ease Of Management Within ODI.

Score 10 out of 10
Vetted Review
Verified User
Review Source

Overall Satisfaction with Oracle Enterprise Data Quality

Oracle Enterprise Data Quality (OEDQ) helped my organization to define Data Quality issues from a business perspective by business users and ability to manage those issues within our ETL tool (Oracle Data Integrator - ODI).
  • 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.
  • 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.
  • 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".
Yes - I am a member of the Independent Oracle User Group, ODTUG, Colombia Oracle Users Group, Costa Rica Oracle Users Group, Ecuador Oracle User Group, Grupo de Usuarios Oracle El Salvadore, Oracle User Group Guatemala, Oracle User Group Mexico, Panama Oracle User Group, Azerbeidzjan Oracle User Group, Bulgarian Oracle User Group, Oracle Gebruikersclub Holland, Oracle User Group Finland, Oracle User Group Norway, Romanian Oracle User Group, Slovenian Oracle User Group SIOUG, Spain Oracle User Group, TROUG Turkish Oracle User Group, UK Oracle User Group and All India Oracle User Group.

I am presenting in various Oracle User Groups worldwide and share my expertise with Oracle Enterprise Data Quality in many of my sessions.
Trillium and SAS DataFlux was considered but not having in-ETL management and licensing cost.
  • Ease of adding localized and customized data quality formulations (for instance asking for Turkish Citizenship Number from governmental web service and checking whether data is the same with the output).
  • Finding the "golden record" from the duplicated records.
  • Adding and/or merging missing information from different data sources.
  • Using patterns and statistical functions to complete the data.
  • Address verification (can be localized).
  • Parsing of combination of records.
  • Enriching required data from free text (story told) inputs.

Oracle Data Quality Feature Ratings

Data source connectivity
10
Data profiling
8
Master data management (MDM) integration
8
Data element standardization
9
Match and merge
10
Address verification
10