Various Connection Types
Moderators: chulett, rschirm, roy
-
- Charter Member
- Posts: 88
- Joined: Tue Jan 13, 2004 3:07 pm
Various Connection Types
Can anybody give me details how Datastage Enterprise connection is made to Database (What kind of connection is this?, What set up is required at Unix side?).
Are these set up at Server level or project level? If we create a new project in the existing server (where other projects are created with proper acces set-up) do we need to still set up connection (like entries in tnsnames.ora and any other set up needed at Server end) for new project?
How does enterprise stage connects to database? Is it instant client? When you connect to Oracle thorogh Enterprise stage we need to have corresponding entry in tnsnames.ora file right? and for ODBC connection we need to have an entry in uvodbc.config?
Thanks
-Vinay
Are these set up at Server level or project level? If we create a new project in the existing server (where other projects are created with proper acces set-up) do we need to still set up connection (like entries in tnsnames.ora and any other set up needed at Server end) for new project?
How does enterprise stage connects to database? Is it instant client? When you connect to Oracle thorogh Enterprise stage we need to have corresponding entry in tnsnames.ora file right? and for ODBC connection we need to have an entry in uvodbc.config?
Thanks
-Vinay
Database vendor specific connections are managed thru the database client software, be it an connection layer (OCI, CLI plugins to native DB APIs) or a command line layer (sqlldr, OSQL, etc). ODBC is handled thru the ODBC manager.
Any Oracle configurations are managed via Oracle. You need to worry about DS specific environment variables to interact with your database client software, such as ORACLE_HOME and shared library paths.
Any Oracle configurations are managed via Oracle. You need to worry about DS specific environment variables to interact with your database client software, such as ORACLE_HOME and shared library paths.
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
.odbc.ini and uvodbc.config files are to be configured if your using an odbc handle to connect to the database. If your using native clients then you need to install clients at the server end. Set the variables associated. Thats it. Details can be found in DataStage manuals.
Creativity is allowing yourself to make mistakes. Art is knowing which ones to keep.
DSguru2B - Should there be any configuration required in dsenv regarding the individual database home directory. When I look into Install and Upgrade Guide for odbc Configuration, the sample oracle configuration is given as
Shouldn't it need Oracle client installation again.
Code: Select all
# 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
Impossible doesn't mean 'it is not possible' actually means... 'NOBODY HAS DONE IT SO FAR'
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact: