A forum for discussing DataStage<sup>®</sup> basics. If you're not sure where your question goes, start here.
Moderators: chulett , rschirm , roy
kennyapril
Participant
Posts: 248 Joined: Fri Jul 30, 2010 9:04 am
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!
Regards,
Kenny
ray.wurlod
Participant
Posts: 54607 Joined: Wed Oct 23, 2002 10:52 pm
Location: Sydney, Australia
Contact:
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.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
chulett
Charter Member
Posts: 43085 Joined: Tue Nov 12, 2002 4:34 pm
Location: Denver, CO
Post
by chulett » Mon Mar 18, 2013 3:18 pm
QC? As in the Quality Center product from HP?
-craig
"You can never have too many knives" -- Logan Nine Fingers
kennyapril
Participant
Posts: 248 Joined: Fri Jul 30, 2010 9:04 am
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
Regards,
Kenny
ray.wurlod
Participant
Posts: 54607 Joined: Wed Oct 23, 2002 10:52 pm
Location: Sydney, Australia
Contact:
Post
by ray.wurlod » Wed Mar 20, 2013 1:43 pm
I think you'd have to get it from HP.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
eph
Premium Member
Posts: 110 Joined: Mon Oct 18, 2010 10:25 am
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
Participant
Posts: 248 Joined: Fri Jul 30, 2010 9:04 am
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?
Regards,
Kenny
ray.wurlod
Participant
Posts: 54607 Joined: Wed Oct 23, 2002 10:52 pm
Location: Sydney, Australia
Contact:
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.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
chulett
Charter Member
Posts: 43085 Joined: Tue Nov 12, 2002 4:34 pm
Location: Denver, CO
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.
-craig
"You can never have too many knives" -- Logan Nine Fingers
kennyapril
Participant
Posts: 248 Joined: Fri Jul 30, 2010 9:04 am
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.
Regards,
Kenny
ray.wurlod
Participant
Posts: 54607 Joined: Wed Oct 23, 2002 10:52 pm
Location: Sydney, Australia
Contact:
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.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
chulett
Charter Member
Posts: 43085 Joined: Tue Nov 12, 2002 4:34 pm
Location: Denver, CO
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.
-craig
"You can never have too many knives" -- Logan Nine Fingers
kennyapril
Participant
Posts: 248 Joined: Fri Jul 30, 2010 9:04 am
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.
Regards,
Kenny