Installing BI4.0 SP2 on Sybase ASE

[Former Member]

Hello,

I would like to install SAP BusinessObjects BO BI 4.1 SP2 on Sybase ASE 15.7 / Red Hat 6.5.

I have done this type of installation on Oracle and I had to create DB manually (with create databse command), add tablespace for Audit manually and create CMS and Audit users manually.

So, I need your help to do these steps on SAP ASE ?

SAP ASE is a new DB for me so is someone has already created SAP ASE database for BO BI 4.1?

Regards

[Former Member]

Hi,

is someone can give me SAP ASE command line to create both users <sid>audit & <sid>cms with good options and good rights?

Regards

[Henry_Banks]

Hi,

As a side note, i would recommend that you evaluate a high SP than SP02. for example, SP04 or SP05

If you are looking for specific information about migrating your existing databases to Sybase SQL Anywhere, please follow the steps described in “Migrating to Sybase SQL Anywhere” (section 7) in

the SAP BusinessObjects Business Intelligence Suite 4.1 Support Package Update Guide.

https://websmp101.sap-ag.de/~sapidb/012002523100017039532014E/sbo41sp5_sp_update_en.pdf

Regards,

H

[srinivasan_vinayagam]

Hi Durecu,

You can create user in Sybase Central.

CREATE USER CMSADM IDENTIFIED BY XXXXXXX ;

CREATE USER AUDADM IDENTIFIED BY XXXXXXX ;

Permission Required

GRANT { DBA | GROUP | MEMBERSHIP IN GROUP userid [, …] | RESOURCE | ALL } ... TO userid [, …]

Grant dba, group, resource to cmsadm;

grant dba, group, resource to audadm;

Regards,

V Srinivasan

[matus_petrek2]

Hi,

are you sure these commands are ok? Seems to be for Oracle, not Sybase.

Regards,

[srinivasan_vinayagam]

Hi Matus,

If Sybase you can use to create in Sybase Central or follow in command prompt.

http://infocenter.sybase.com/help/index.jsp?topic=/com.sybase.infocenter.dc00801.1510/html/iqrefso/C...

Regards,

V Srinivasan