How to connect to DataStage for test automation
Moderators: chulett, rschirm, roy
How to connect to DataStage for test automation
Looking to connect DataStage ActiveX (COM) controls to a third Party for test automation. Can this be done through routines/plug-ins?
Why complicate something so simple?
DataStage jobs DO something. All you need to do is run the jobs. What would you vary, job parameters? Different data in the source and target? The jobs are static.
Just run the jobs when necessary via the command line interface program dsjob.
DataStage jobs DO something. All you need to do is run the jobs. What would you vary, job parameters? Different data in the source and target? The jobs are static.
Just run the jobs when necessary via the command line interface program dsjob.
Kenneth Bland
Rank: Sempai
Belt: First degree black
Fight name: Captain Hook
Signature knockout: right upper cut followed by left hook
Signature submission: Crucifix combined with leg triangle
Rank: Sempai
Belt: First degree black
Fight name: Captain Hook
Signature knockout: right upper cut followed by left hook
Signature submission: Crucifix combined with leg triangle
-
- Participant
- Posts: 3593
- Joined: Thu Jan 23, 2003 5:25 pm
- Location: Australia, Melbourne
- Contact:
Running jobs has always been the easy part of testing, verifying results has always been the hard part. Automation of jobs can be done via the API but all that time would probably give you very little benefit. It's having a good regression testing strategy with static test data and a tool to verify that the results are what is expected that is more valuable.
Certus Solutions
Blog: Tooling Around in the InfoSphere
Twitter: @vmcburney
LinkedIn:Vincent McBurney LinkedIn
Blog: Tooling Around in the InfoSphere
Twitter: @vmcburney
LinkedIn:Vincent McBurney LinkedIn
vmcburney wrote:Running jobs has always been the easy part of testing, verifying results has always been the hard part. Automation of jobs can be done via the API but all that time would probably give you very little benefit. It's having a good regression testing strategy with static test data and a tool to verify that the results are what is expected that is more valuable.
Can you point me to the API? I looked in the documentation and could not find it
-
- Participant
- Posts: 3593
- Joined: Thu Jan 23, 2003 5:25 pm
- Location: Australia, Melbourne
- Contact:
We are struggling to understand because the type of test automation you are trying to get is something most of us have never tried, nor would ever try. The cost benefit of automating the running of DataStage jobs through a test tool is dubious. This is not a end user GUI tool where test automation ensures the save, cancel and help buttons works. This is an ETL job. Most of us work on a layer of job control either through BASIC routines, 3rd party scheduling tools or sequence jobs and we code in the error handling into this layer. Therefore we have an easy way to start all jobs via this job control and we have an easy way to verify results via reports. So who needs test automation? You are duplicating effort. You will end up building test automation job control and normal job control.
Certus Solutions
Blog: Tooling Around in the InfoSphere
Twitter: @vmcburney
LinkedIn:Vincent McBurney LinkedIn
Blog: Tooling Around in the InfoSphere
Twitter: @vmcburney
LinkedIn:Vincent McBurney LinkedIn
The exact reasoning for the "job control" is the reason for the test repository direct linkage. The automation aspect is only for job control and automatic saving of test runs and test results in that repository. Something that doesn't seem to be duplication since it doesn't exist as far as the direct linkage of DataStage results to the client test repository. Extending the functionality into the format and function of the testing team charter is all the that is being attempted.vmcburney wrote:We are struggling to understand because the type of test automation you are trying to get is something most of us have never tried, nor would ever try. The cost benefit of automating the running of DataStage jobs through a test tool is dubious. This is not a end user GUI tool where test automation ensures the save, cancel and help buttons works. This is an ETL job. Most of us work on a layer of job control either through BASIC routines, 3rd party scheduling tools or sequence jobs and we code in the error handling into this layer. Therefore we have an easy way to start all jobs via this job control and we have an easy way to verify results via reports. So who needs test automation? You are duplicating effort. You will end up building test automation job control and normal job control.
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
dsobjects.dll is already a COM object. One of the objects exposed therein is a Subroutine object which can, of course, return values. But it's probably a cumbersome approach, and you need to establish a connection to DataStage using a Session object. "They" don't provide any documentation on this, but the IBM manual "UniObjects" will get you close.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.