QC database

kennyapril · Post by **kennyapril** » Mon Mar 18, 2013 2:09 pm

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!

ray.wurlod · Post by **ray.wurlod** » Mon Mar 18, 2013 3:14 pm

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.

chulett · Post by **chulett** » Mon Mar 18, 2013 3:18 pm

QC? As in the Quality Center product from HP?

kennyapril · Post by **kennyapril** » Wed Mar 20, 2013 9:42 am

@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

ray.wurlod · Post by **ray.wurlod** » Wed Mar 20, 2013 1:43 pm

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

eph · Post by **eph** » Thu Mar 21, 2013 2:52 am

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

kennyapril · Post by **kennyapril** » Tue Mar 26, 2013 10:46 am

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?

ray.wurlod · Post by **ray.wurlod** » Tue Mar 26, 2013 1:39 pm

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.

chulett · Post by **chulett** » Tue Mar 26, 2013 1:56 pm

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.

kennyapril · Post by **kennyapril** » Tue Mar 26, 2013 3:58 pm

Thank you Ray!

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

ray.wurlod · Post by **ray.wurlod** » Tue Mar 26, 2013 5:04 pm

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

chulett · Post by **chulett** » Tue Mar 26, 2013 6:26 pm

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

kennyapril · Post by **kennyapril** » Wed Mar 27, 2013 2:44 pm

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