Re: free oracle data profiling/quality tool

On Jun 20, 9:40 am, goog <ning...._at_dfa.state.ny.us> wrote:
> On Jun 20, 8:11 am, gazzag <gar..._at_jamms.org> wrote:
>
>
>
> > On 19 Jun, 19:43, goog <ning...._at_dfa.state.ny.us> wrote:
>
> > > Hi,
>
> > > I am in search of a downloadable oracle data profiling/quality tool.
> > > Any recommendation is highly appreciated. Thanks!
>
> > Oracle provide a free tool called SQL Developer which can be
> > downloaded from here:http://www.oracle.com/technology/software/products/sql/index.html.
>
> > You need to create a Metalink account before you can download it but
> > this is free and quick to do.
>
> > HTH
>
> > -g
>
> Thanks. No, this is not what I am looking for. I am looking for open
> source tools that can do
> column profiling, dependency profiling and redundancy profiling, etc.
>
> N.

Let me first say I don't know of any free (I assume that is what you mean by downloadable) tools that will do this, but that kind of tool always scares me.

I never know the kind of queries it will be use to validate the business data. I know that purists out there will say that a well designed relational schema will not need to be validated, but I also know people (designers) make mistakes. However, just turning a third party tool loose on a production database to find table *data* dependencies and redundancies (not just structurual dependencies or redundancies) seems to be a risky proposition at best.

Regards,

Steve Received on Wed Jun 20 2007 - 09:24:03 CDT