First job Server Task
Posted: Mon Feb 28, 2005 9:48 am
I have a few questions regarding set up and getting started that I would appreciate any help with.
My client software is UK based with the datastage server in the States. Connectivity to the datastage server is via telnet or through the datastage software itself. I wish to be able to connect to both Sybase and MSSQL servers that are resident in the UK.
For the sybase server, the interfaces file on the datastage server has been updated with server details. I am now able to telnet onto the datastage server and isql onto the sybase server.
However, when I try and create a job server task in datastage I don't see any mention of the sybase server.
I tried using the Dynamic RDBMS within job server and selected a DBMS type of Sybase. I then entered in the details for BKP_ANY2 but no connection was made to the server.
(1) Do I have to set up a data source name in datastage somewhere in order for me to see the sybase server - is this what the uvodbc.config file is for ? Does this file get attached to a specific datastage project ?
I'm not sure about how to set up the MSSQL server but assuming that I have my datastage source name for the sybase server and MSSQL server set up then I would like to do the following :
Connect to the Sybase server and extract data into a transformation process before forwarding it onto the MSSQL server. This sounds easy enough but looking at the types of tasks within job server it doesn't seem that the available options are going to help me much - when I select one of the sybase options when creating a server job the Sybase options are "Sybase BCP Load", "Sybase IQ 12 Load", "Sybase IQ Load" and "Sybase OC" - none of these jump out to me to say that I could connect to a sybase server and extract some data. Should I be using the Dynamic RDBMS.
(2) Could someone point me to what I should be using for this please ?
It is difficult to get these probable easy problems ironed out if I was working in the same time zone as my counterparts.
Thanks for any help.
My client software is UK based with the datastage server in the States. Connectivity to the datastage server is via telnet or through the datastage software itself. I wish to be able to connect to both Sybase and MSSQL servers that are resident in the UK.
For the sybase server, the interfaces file on the datastage server has been updated with server details. I am now able to telnet onto the datastage server and isql onto the sybase server.
However, when I try and create a job server task in datastage I don't see any mention of the sybase server.
I tried using the Dynamic RDBMS within job server and selected a DBMS type of Sybase. I then entered in the details for BKP_ANY2 but no connection was made to the server.
(1) Do I have to set up a data source name in datastage somewhere in order for me to see the sybase server - is this what the uvodbc.config file is for ? Does this file get attached to a specific datastage project ?
I'm not sure about how to set up the MSSQL server but assuming that I have my datastage source name for the sybase server and MSSQL server set up then I would like to do the following :
Connect to the Sybase server and extract data into a transformation process before forwarding it onto the MSSQL server. This sounds easy enough but looking at the types of tasks within job server it doesn't seem that the available options are going to help me much - when I select one of the sybase options when creating a server job the Sybase options are "Sybase BCP Load", "Sybase IQ 12 Load", "Sybase IQ Load" and "Sybase OC" - none of these jump out to me to say that I could connect to a sybase server and extract some data. Should I be using the Dynamic RDBMS.
(2) Could someone point me to what I should be using for this please ?
It is difficult to get these probable easy problems ironed out if I was working in the same time zone as my counterparts.
Thanks for any help.