cancel
Showing results for 
Search instead for 
Did you mean: 

BI 4.1 Connection Server Role (32bit / 64bit)

Former Member
0 Kudos

Hi BO Community,

We would like to know which BI 4.1 Tools utilize the connection servers and what is a recommended sizing of connection servers

We are using Webi, Crystal, Dashboards, Explorer, Lumira & Design Studio in our landscape

Please let us know if you have any questions

Regards,

Swapnil Hoderkar

Accepted Solutions (1)

Accepted Solutions (1)

former_member198519
Active Contributor
0 Kudos

This would give the best explanation for the service in APS. Refer it:

https://wiki.scn.sap.com/wiki/display/BOBJ/Business+Intelligence+4.x+APS+(Adaptive+Processing+Server...

DSL Bridge is needed not only for BICS connection but also for UNX universe and SQL optimization. Also have a look at this thread:

https://archive.sap.com/discussions/thread/3338036

Former Member
0 Kudos

Thanks Kuldeep

Answers (6)

Answers (6)

CdnConnection
Active Contributor

Swapnil,

There are many factors that need to be considered related to connection, such as:

  • Types of ODBC Database engine 32 or 64 bit
  • You current version of BI 4.1 ONLY supports serial database fetch, slower. BI 4.2.3 supports Parallel Data fetch
  • Size / # of Rows being fetched by the several reporting tools
  • Total # of concurrent users running the reports via BI LaunchPad
  • The sizing guide fully expains how to size and adjust the memory based on some of these factors

https://archive.sap.com/documents/docs/DOC-33183

Regards,

Ajay

Former Member
0 Kudos

Hi Ajay,

Thanks for the quick response.

We are currently struggling with issues in our environment since we deployed Lumira & Design Studio in our environment.

Our Lumira Dashboards periodically fail on refresh or schedule and the workaround we found for them to work is to restart the Connection Services (both 32 and 64bit)

And we are not seeing issues with other tools like Webi which are heavily used in our Environment

We wanted to know if Webi in BI 4.1 uses Connections server to connect to the DB or it uses the APS DSL Bridge service as we primarily have all UNX universes

So we can accordingly size the no of connection services in our Environment

Regards,

Swapnil Hoderkar

former_member191664
Active Contributor
0 Kudos

Are you sure that the same version of SAP Lumira Desktop, SAP Lumira for BI Platforms and SAP BusinessObjects BI Platform 4.1 is being used?

See SAP KB 2262361 - Error: Dataset Refresh has failed when refreshing Lumira connecting to BEX query on https://launchpad.support.sap.com/#/notes/2262361

Regards,

Jin-Chong

Former Member
0 Kudos

Hi Siva,

One more questions on connection server does Lumira use connection server? If yes which one 32bit / 64bit?

We have an Lumira Document which is based off an Oracle Data Source (Connection build on ORACLE OCI driver) which fails intermittently with the error "Dataset Refresh failed" and we have seen restarting both connection servers resolves the issue.

However when I checked the properties of both connection servers only 64bit had the Oracle OCI driver.

It would be great if you could share some insight on the role of connection servers in respect to Lumira documents

Thanks.

Swapnil Hoderkar

former_member187093
Participant
0 Kudos

Hi There,

DSL Bridge is mainly to connect BW via BICS. DSL Bridge is not required to connect RDBMS, e.g. Oracle

we have reports based on oracle and don't use DSL bride in our BOBJ system. webi processing server got a component to connect with backend so it's not using connection server.Please refer admin guide for more info. to test, just disable and run the webi report.

Connection server got the all middleware drivers and it's not required huge memory or processing power. Hope helps!!!

Former Member
0 Kudos

Thanks Siva for the clarification this helps a lot

Former Member
0 Kudos

Thanks Ajay i will follow the sizing guide

I wanted to also know if Webi will also contact DSL Bridge service for establishing DBconnection for UNX universes? or will Webi use Connection Server

In our environment we have only relational db sources no SAP BW

CdnConnection
Active Contributor
0 Kudos

Swapnil,

Follow the link provided, it also has link to Lumira sizing guide. You will need to install a separate server for Lumira. The DSL Bridge service is used by the BICS connector, which is used by WebI.

https://archive.sap.com/documents/docs/DOC-33183

Regards,

Ajay