database,middleware and BO compatibility

general discussion
1

Here is a scenario…

We have 2 databases …say db1 and db2 each on a different server. At present both the databases are Oracle 7.3.3 On the client side, users have been using BO 4.1.4 with sql*net 2.3.3 on their desktops. They query data from both the databases db1 and db2 ( i.e universes are created for both databases)

Now, the DBAs here want to migrate db1 to Oracle 8.(net8) This means that a user may want to have BO 5 to use db1 and BO 4.1.4 to use db2 ( am I missing something here ???)
This means a need of a separate repository for BO 5. Can the user have 2 versions od BO on the same desktop ? ( as BO 3.1 and 4.1 did).

Please help me find the answers…

Thanks
Ashish

Listserv Archives (BOB member since 2002-06-25)

2

Ashish,

We have 2 databases …say db1 and db2 each on a different server. …
Now, the DBAs here want to migrate db1 to Oracle 8.(net8) This means that a user may want to have BO 5 to use db1 and BO 4.1.4 to use
db2 ( am I missing
something here ???)
This means a need of a separate repository for BO 5. Can the user have 2 versions od BO on the same desktop ? ( as BO 3.1 and 4.1
did).

You have a few options…

  • BO v5.x allows multiple repositories. you can make use of it. * BO v5.x and v4.x can be on the same desktop * You can define different connection parameters for certain users/universes thru the supervisor

Hope this helps.
-Sai

Listserv Archives (BOB member since 2002-06-25)

3

BusinessObjects 4.1 supports sql*net 2.3 and Net8 middleware. You don’t have to upgrade to BusinessObjects 5 in order to access an Oracle8 database. The most recent version of 4.1 is 4.1.7.

Also, BusinessObjects 4.1 and 5.0 can reside on the same PC concurrently.

Kumar

Listserv Archives (BOB member since 2002-06-25)

4

7F537688E0D6D0119A0B00805FFEBE9403C69F40@exc03crdge.crd.ge.com, mirji@CRD.GE.COM (Mirji, Ashish (CRD)) wrote:

( am I missing

something here ???)

BO 4.1.4 will work with Oracle 8, so there is no real reason to upgrade to 5 if not required.

Regards

Brian Patterson

Listserv Archives (BOB member since 2002-06-25)

5

Kannan,

When you say…

“Also, BusinessObjects 4.1 and 5.0 can reside on the same PC concurrently.”

Do you mean that 4.1 and 5.0 will have 2 different repositories or just 1 repository ( a 5.0 upgraded one).

Ashish

Listserv Archives (BOB member since 2002-06-25)

6

7F537688E0D6D0119A0B00805FFEBE9403C69F60@exc03crdge.crd.ge.com, mirji@CRD.GE.COM (Mirji, Ashish (CRD)) wrote:

Do you mean that 4.1 and 5.0 will have 2 different repositories or just 1 repository ( a 5.0 upgraded
one).

BO 4.1 and BO 5 can both use the same (version 5) repository.

However, for sanity and peace of mind, I would upgrade all users to v5 or not at all. There are some oddities in using the same repository for both versions, in particular with regard to using DAS/BCA and WebI.

Regards

Brian Patterson--------------------------------------------------------------------------- Pls report bounces in response to postings to BUSOB-L-Request@listserv.aol.com Web archives (24 hrs. a day now!): listserv.aol.com/archives/busob-l.html
OR search: Mail to listserv@listserv.aol.com, ‘search a_phrase in BUSOB-L’ Unsubscribe: Mail to listserv@listserv.aol.com, ‘unsubscribe BUSOB-L’

Date: Tue, 18 Jan 2000 16:04:05 -0500

Wait, I wasn’t following this… I thought that BO warned about running 7.3x and 8.0 oracle on the same box… I could see this being hard to keep straight, from a strictly Oracle perspective…

If you can get / keep that configuration running on your pc, you should be able to have multiple datasources on the BO side - BO should support multiple datasources, oracle, db2, whatever - if your box can run the connecting layer…

Rant on, I know - but my concern is that having BO 4.1x and BO 5.0x on your developers’ machines doesn’t get you closer if you can’t keep both sql*net layers working… Can you use the Oracle 8.x sqlnet to connect to your 7.3x database? I think the generic answer to that is yes…

Very curious to see more on this thread, let us know what happens / what you find out…

Brent

Here is a scenario…

We have 2 databases …say db1 and db2 each on a different server. At present both the databases are Oracle 7.3.3 On the client side, users have been using BO 4.1.4 with sql*net 2.3.3 on their desktops.

Listserv Archives (BOB member since 2002-06-25)

7

From what we have seen, this statement is right on :

<< Also, BusinessObjects 4.1 and 5.0 can reside on the same PC concurrently.>>

My question is: has anyone been able to get a stable setup that involves Oracle 7.3.x and oracle 8.0x on the same box, and if so, was that NT, 95, Solaris…?

Brent

Listserv Archives (BOB member since 2002-06-25)

8

From what we have seen, this statement is right on :

<< Also, BusinessObjects 4.1 and 5.0 can reside on the same PC concurrently.>>

Agreed, do not install oracle 7.x and 8 on the same box. However, if you do want multiple repositories, it does not meccessarily mean that they have to reside on the same machine.

Also, if you want both bo 4 and 5 on the same machine for development, this is perfectly feasible - I have such an install here. However, bo is not renowned (particular 5.0) for being the most stable of products, so for end users, one or t’other is recommended.

As for the middleware - there should be no problem accessing oracle 7.x or 8.x using sql net or net 8. They do not have to both be installed to access either version or oracle. In fact, if you update the repository to version 8, then as far as the client is concerned, there should be no changes neccessary (as long as the oracle server name/logon details do not change)

Regards

Brian Patterson

Listserv Archives (BOB member since 2002-06-25)

9

Yes, v5 can co-exist with v4.
The file associations (to .rep, .unv) may all change to v5 but v4 runs fine.

Can the user have 2 versions od BO on the same desktop ? ( as BO 3.1 and 4.1 did).

Listserv Archives (BOB member since 2002-06-25)

10

Brent

Can you use the Oracle 8.x sqlnet to connect to your 7.3x database? I
think the generic answer to that is yes…<

I couldn’t get the Oracle 7 client to work against my Personal Oracle 7.3.4 database so I installed Net8 and used that, so the answer is definitely yes. Jonathan Bliss, Product Consultant
McKessonHBOC Computer Centre, Harold Wood Hospital site, Gubbins Lane, Romford, RM3 0NE
mobile:0498 668084, tel 01708 336135 (direct line with voicemail), fax 01708 376270

Listserv Archives (BOB member since 2002-06-25)

11

At our site…

We are not able to use Net 8.0 with Oracle 7.3x, We have to use sql Net 2.3 or 3.3.

Aris

Listserv Archives (BOB member since 2002-06-25)

12

Bliss" at Jan 20, 100 9:05 am

Net8 can access both Oracle 7.x and 8.x
also Sql Net 2.3 can access both.

But if you have both client products installed on your client machine it doesnot work.

un-install sql net totally from your machine, including directories and registry entries.

vasan

Baton Rouge International Inc.
Data warehousing

Brent

Can you use the Oracle 8.x sqlnet to connect to your 7.3x database? I
think the generic answer to that is yes…<

I couldn’t get the Oracle 7 client to work against my Personal Oracle 7.3.4 database so I installed Net8 and used that, so the answer is definitely yes. Jonathan Bliss, Product Consultant
McKessonHBOC Computer Centre, Harold Wood Hospital site, Gubbins Lane, Romford, RM3 0NE
mobile:0498 668084, tel 01708 336135 (direct line with voicemail), fax 01708 376270

OR search: Mail to listserv@listserv.aol.com, ‘search a_phrase in BUSOB-L’ Unsubscribe: Mail to listserv@listserv.aol.com, ‘unsubscribe BUSOB-L’

Listserv Archives (BOB member since 2002-06-25)