Adding a DSN entry

[aramachandra]

Hi All

I am more of a developer then an administrator but in my new job we currently do not have a dedicated ETL administrator. We are to pick that role.

I am required to create a new ODBC DSN for an oracle access and I just wanted to make sure I am understanding the process before making any changes.

The DSEngine folder is under the path

/usr/IBM/InformationServer/Server/DSEngine

There is an

uvodbc.config
.odbc.ini

files in the above path

I can make the entries in those after getting my oracle SID and port.

But is it true that I also have to make the same entry in the

uvodbc.config in the project folder as well.

So I need to make changes to 3 files to make it work.

It that right or am i missing something

Thanks
Arvind

[attu]

Arvind,

you need oracle setup in dsenv

path of ORACLE_HOME
path of ORAHOME
ORACLE_SID
ORASID

entry of oracle dsn in .odbc.ini
entry of oracle dsn in uvodbc.config (project folder)

[aramachandra]

I added an entry in the .odbc.ini under the DSEngine folder

I added an entry in the Projects uvodbc.config file

And my odbc enterprise stage recognises the new DSN.


So why or what is the reason one should have the uvodbc.config under the DSENGINE updated.

Please let me know

Currently I have not updated the uvodbc.config under the DSEngine. What is the effect of not making that change

Please let me know

Thanks
Arvind

[aramachandra]

I added an entry in the .odbc.ini under the DSEngine folder

I added an entry in the Projects uvodbc.config file

And my odbc enterprise stage recognises the new DSN.


So why or what is the reason one should have the uvodbc.config under the DSENGINE updated.

Please let me know

Currently I have not updated the uvodbc.config under the DSEngine. What is the effect of not making that change

I believe the ORACLE entries in DSENV are when you want to setup the ORACLE enterprise stage. But i will check on that as well.

Please let me know

Thanks
Arvind