DSXchange: DataStage and IBM Websphere Data Integration Forum
View next topic
View previous topic
Add To Favorites
Author Message

Joined: 29 Aug 2014
Posts: 50
Location: Mumbai
Points: 532

Post Posted: Mon May 13, 2019 1:15 am Reply with quote    Back to top    

DataStage® Release: 11x
Job Type: Parallel
OS: Unix

So far we were downloading SAS datasets manually and using them as input in Datastage jobs. Going forward we have to connect to SAS server and pull data from Datasets directly. There is very limited information available on this online. Can you of you provide your thoughts on this?

I have my server name (let's say ABCD01), port (1234), User ID and Password. I see all the Libraries which have the Datasets. So considering I have Server Name, Port, User ID, Passsword, Library(Lets say 'Maps') and Dataset Names(Lets say 'Country'), how do I call this dataset in Datastage?

Thanks in advance. Any help is appreciated.

Joined: 27 Feb 2016
Posts: 16
Location: Ottawa
Points: 217

Post Posted: Mon Aug 26, 2019 12:25 pm Reply with quote    Back to top    

For DS to connect to SAS server, DS needs a "plugin" that acts as SAS client. Which does not exist, if I am not mistaken.
However, if you have the SAS client software installed on the same host as the DS server, you can initiate a scripted telnet connection by editing the telnet ".scr" file.
If you have the SAS client installed, you should be able to find the telnet scr file. You can edit it to specify the username and password, the SAS commands to invoke after a successful login. The SAS commands will open the SAS dataset and print/output to console/ODS. This output can then be consumed by any DS stage.
You may want to write a wrapper stage to encapsulate this functionality.
You may need to SAS encode the password as well.


ETL, DW, BI Consultant
Rate this response:  
Not yet rated
Display posts from previous:       

Add To Favorites
View next topic
View previous topic
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum

Powered by phpBB © 2001, 2002 phpBB Group
Theme & Graphics by Daz :: Portal by Smartor
All times are GMT - 6 Hours