BusinessObjects Board

TnsNames entry included in connection information

building semantic layer
#1

I am sure I sure a posting here recently where it was explained how to include the TNSNAMES entry in the BO connection defined by Designer. Anyone point me at it?
:stuck_out_tongue:

Paul Shovlar :uk: (BOB member since 2002-09-05)

WebI Rich Client
Centralized TNSNAMES file
oracle connections via asp
FAQ: Designer Database Specific
Giving a long TNS entry in the Supervisor-Repository
#2

Its on the old listserv - I have a copy at work and will dig it out tomorrow if you don’t have an answer by then. Basically if you past the tnsnames entry into your connection box you won’t be far away…

Nick Daniels :uk: (BOB member since 2002-08-15)

#3

Paul,

The Name that you give your connection in the TNSNames.ora file is the name that you put in the Database field of your connection in Designer. Define the connection in TNSNames, and the use that connection as the database.

I hope that makes sense.

MichaelWelter :vatican_city: (BOB member since 2002-08-08)

#4

Here’s what you are looking for. It works pretty well. Users still have to have the middleware, but you don’t have to deal with TNSNames entries on every desktop/server.

[list]You can make connections to Oracle db’s without having entries in the
TNSNAMES on the local machines. The whole entry can be specified in the
Connection.

Where you normally specify the name of the database as defined in the
TNSNAMES file, you can specify the whole TNSNAMES entry instead.

Note, you have to remove all spaces. <<

So, where it asks for database, put something like:

(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=)(PORT=<port

)))(CONNECT_DATA=(SERVICE_NAME=)))

This allows you to specify the connections in the repository and the clients
only need to have the Oracle client installed. You can add or change
connections w/o having to synch up all the TNSNAMES.[/list]

Steve Krandel :us: (BOB member since 2002-06-25)

#5

This goes by the name of “smart connections” here at Nortel / CSC.

You do have to remove all the spaces. Make sure you don’t remove any of the other punctuation, though. You need all those parentheses.

This has worked very well for us here. Smart connections made our server move very easy, since we didn’t have to worry about the TNSNAMES.ORA file being moved from one machine to another.

Good luck
Judy

JMulders :us: (BOB member since 2002-06-20)

#6

This is extremely neat…

Thanks a lot

avaksi :us: (BOB member since 2002-08-22)

#7

It seems to me that BO XI R2 is not able to connect with these parameters.
Have u guys tried?

wshiguetaka (BOB member since 2002-08-16)

#8

I’m sure XI can’t do this. Keep in mind that this post is 4 years old. XI is completely different.

Steve Krandel :us: (BOB member since 2002-06-25)

#9

Hi,

Can we use this feature in BO 6.5.1 version?

Currently we have Oracle 8i on my system but I need to connect to New Application(CMS) Oracle 9i(Exist in Server) using BO 6.5.1.

While creating universe and databse connection, I could not find any CMS related DSN (Oracle 9) names.

Can I use this smart solution or do I need to install Oracle 9 and update TNSNames.ora?

Please reply.

Thanks.
Regards,
Santhosh

optimist1001 (BOB member since 2007-02-13)