Set up of Websphere Datastage and Quality Stage Designer
Posted: Fri Mar 28, 2008 11:43 am
Hi there,
I am 'brand new' to datastage. I have worked on a huge oracle database as a ETL developer and 'partly' DBA for 8yrs now. I am currently on a assignment to work on Datastage on a DB2 database - both Datastage and DB2 are new for me which the employer understands. The hiring manager liked my datawarehousing expertise and thought I could easily adapt to Datastage and DB2. I am currently stuck with installing and configuring Datastage. I am in a bad need of your help to get me going.
My first assignment is to pull data from a DB2 database on a daily basis and do some transformations (not sure what transformations yet. I just started in this new job) and load the data into the DB2 datawarehouse.
1) What tools I would need? I have installed IBM's Websphere Datastage and Quality Stage Designmer. Is this the right tool for the purpose?
2) When I open this, I am seeing a screen shot which says "Attach to project" asking for Domain, Userid, password and Project. What should be the domain name? Is uid/password the same as database's login or is it a separate uid/pwd for datastage?
3) Do I have to install anything for 'metadata' or does it come automatically with the DS designer?
4) Is there a need for having a separate database account for datastage?
5) Where could I get more info on the subject? Premium membership on DSXchange website ($99/year)? And/Or any other training or tutorials or mentoring that you would suggest And/Or are there any good books that you recommend. I am ready to pay some to get going. I hate to see myself stuck in the 'setting up' phase. I atleast want datastage to be connected to the database so I could get myself familiarized to the environment.
PS: There is no sys admin in this company to help out. There is no one else with datastage expertise. They have developed their own ETL with sql scripts and are looking for me to help them migrate everything from hand-written sql scripts to datastage.
PS: My previous company also engaged in 'hand written' sql code for ETL - hence I never got exposure to the state of the art ETL tools.
Thank you,
Joy.
I am 'brand new' to datastage. I have worked on a huge oracle database as a ETL developer and 'partly' DBA for 8yrs now. I am currently on a assignment to work on Datastage on a DB2 database - both Datastage and DB2 are new for me which the employer understands. The hiring manager liked my datawarehousing expertise and thought I could easily adapt to Datastage and DB2. I am currently stuck with installing and configuring Datastage. I am in a bad need of your help to get me going.
My first assignment is to pull data from a DB2 database on a daily basis and do some transformations (not sure what transformations yet. I just started in this new job) and load the data into the DB2 datawarehouse.
1) What tools I would need? I have installed IBM's Websphere Datastage and Quality Stage Designmer. Is this the right tool for the purpose?
2) When I open this, I am seeing a screen shot which says "Attach to project" asking for Domain, Userid, password and Project. What should be the domain name? Is uid/password the same as database's login or is it a separate uid/pwd for datastage?
3) Do I have to install anything for 'metadata' or does it come automatically with the DS designer?
4) Is there a need for having a separate database account for datastage?
5) Where could I get more info on the subject? Premium membership on DSXchange website ($99/year)? And/Or any other training or tutorials or mentoring that you would suggest And/Or are there any good books that you recommend. I am ready to pay some to get going. I hate to see myself stuck in the 'setting up' phase. I atleast want datastage to be connected to the database so I could get myself familiarized to the environment.
PS: There is no sys admin in this company to help out. There is no one else with datastage expertise. They have developed their own ETL with sql scripts and are looking for me to help them migrate everything from hand-written sql scripts to datastage.
PS: My previous company also engaged in 'hand written' sql code for ETL - hence I never got exposure to the state of the art ETL tools.
Thank you,
Joy.