relational DB as source for qualitystage?

Infosphere's Quality Product

Moderators: chulett, rschirm

Post Reply
bryan
Participant
Posts: 91
Joined: Sat Feb 21, 2004 1:17 pm

relational DB as source for qualitystage?

Post by bryan »

hi

We are having data quality issues. Making evaluations between Quality stage or Evoke.

Does Quality stage support only flat file inputs for matching or standardisation?


Thanks
vmcburney
Participant
Posts: 3593
Joined: Thu Jan 23, 2003 5:25 pm
Location: Australia, Melbourne
Contact:

Post by vmcburney »

QualityStage on it's own only reads flat files. You will need to write your RDBMS data out to flat files. The QualityStage plugin for DataStage lets you feed any DataStage plugin data source into a QualityStage job where DataStage formats it into a fixed width format that QualityStage can handle. This removes the need to save the data to a flat file.

I wouldn't be comparing QualityStage to Evoke, far more appropriate to compare Evoke to ProfileStage/AuditStage and Discovery and to compare QualityStage to other quality cleansing products. From what I know of Evoke it does not correct problems, it only performs profiling.
JamasE
Participant
Posts: 32
Joined: Sun Aug 31, 2003 5:52 pm

Re: relational DB as source for qualitystage?

Post by JamasE »

We've been passing data to QualityStage from Sybase via an ODBC connection (although getting it working for our server set up took us a while). From the manuals, ODBC connections are fairly standard, and remove the need for a lot of file creation and even file definition.

(Writing back from QualityStage to Sybase had its own hassles, but we've managed that as well.)

Cheers,
Jamas
Post Reply