ram

• Sep 14th, 2007

 

You should create DSN in Unix box where datastage server is installed.  Creating at client machine would not be of any use..
You need to have database client software installed on the datastage server (Unix box).

nikhilanshuman

 Profile Answers by nikhilanshuman 

• Dec 25th, 2009

 

In UNIX,three files need to be configured.

a) uvodbc.config
b) odbc.ini
c) dsenv

a)uvodbc.config : Here you need to specify the name of data spurce(DSN).Existing configurations in the file can be referred to create new DSN.
For example :
<DSN>
DBMSTYPE = ODBC

b)odbc.ini : Here you need to provide the configuration details of the DSN created in uvodbc.config.The name of data source should be same in uvodbc.config and odbc.ini here the details like like driver location, database name, ip, user id, etc are specified.
Refer the exsting configurations in this file to create new ones.

c)dsenv : It contains the Environment variables needed by the ODBC drivers to connect to the ODBC data source.You need to setup certain env variables to connect to the ODBC data source.
For example :
# Oracle 8i
    ORACLE_HOME=/space/oracle8i
    ORAHOME=/space/oracle8i
    LD_LIBRARY_PATH=$LD_LIBRARY_PATH:$ORACLE_HOME/lib:$ORACLE_HOME/rdbms/lib;export LD_LIBRARY_PATH
    ORACLE_SID=WSMK5
    ORASID=WSMK5
    export ORACLE_HOME ORAHOME ORACLE_SID ORASID