DSXchange

We have a requirement to extract data from QC database.

Please suggest which stage will be appropriate to extract data from the QC database.



Thank you!

If you have an ODBC driver for QC, then the ODBC Connector stage would be favourite. If not, then you probably have to either create your own stage, or have the database dump data in some flat file format that you can read with Sequential File stage.

QC? As in the Quality Center product from HP?

@Ray, Thank you!

So if we do not have Driver for QC, can we get it from IBM anytime?



@Chulett

Yes, it is Quality center from HP

I think you'd have to get it from HP.

Hi,

Usually QC database would be Oracle or MS SQL Server, so you should be able to query those db with the correct connector.

Regards,
Eric

Thanks Ray, so is it something we need to purchase from HP as a pack?


Thanks Eric, If it is Oracle or MS SQL server then we use Oracle or MS SQL DB stages in datastage...right?

As noted, you can also get drivers from database vendors and third party providers. Since you've bought QC you may be able to get HP to provide one without charge.

And as noted and you've asked, if it is a known relational database with an associated Connector, you should be able to use that as well.

Thank you Ray!

Thank you Chulett.
I assume that I can use the ODBC connector is the QC is known relational database.

Only if you have an ODBC driver can you use the ODBC Connector stage.

By 'known relational database' I meant Oracle, SQL Server, etc. In that case use the corresponding 'native' connector.

Thanks very much for all the input, I will find out on which DB it has been placed and connect with the appropriate connector.