Database Administration Tools for SQL Anywhere CMS and Audit DBs
As you may already know, SAP Business Objects 3.1 (SP5 and higher) and 4.1 uses the SAP Sybase SQL Anywhere 12.0.1 embedded database for its default CMS and Audit databases. When you install BOBJ, the installation of SQLA happens automatically and you only need to define standard credentials to log in to the database, such as administrator user name/password.
One thing the default BOBJ installation does not do is install the SQL Anywhere administration tools; however, you can still get them using one of two methods:
- The BOBJ 3.1 installation media includes a file called “SA1201_Client.exe” (Windows) and “sa12_client_linux_x86.x64.1201_3152_l10n.tar.gz” (Linux) inside the folder “SAW”. Execute (Windows) or extract/execute (Linux) this file to install the SQL Anywhere Client, which includes the administration tools.
- Download the SQL Anywhere Client from here: http://scn.sap.com/docs/DOC-35857. You need to do this if using BOBJ 4.1.
There are three database administration tools provided to manage the database:
- Sybase Central: the main tool to create/view/edit database objects, such as tables, views, stored procedures, etc.
- Interactive SQL: a query editor to execute ad-hoc queries.
- SQL Anywhere Console: a monitoring tool to display database connections, properties, server messages, etc.
The most useful tool is Sybase Central since that’s what you use to define events and maintenance plans for CMS and Audit database validation and backups. It’s all wizard-based so creating those management tasks is a breeze. If you’re in for a challenge, you can always create your events using pure SQL, in which case Interactive SQL is your friend… but if you’re a GUI person like me, stick to Sybase Central 🙂
Hello,
You mentioned SAP Business Objects 3.1 SP5. Ths is a very old version. I installed BI 4.1 and it installed with SQL Anywhere 12.01. This is a default DB from BI 4.1 ownwards. It was SQL Server until 4.0.
Is it the correct tool.
Please verify.
SC
Yes it is! The version of SQL Anywhere that is included is the same (12.0.1), so you can use the database administration tools. Thank you for pointing out the different version of BOBJ - I will update the blog posting.
Hello,
My another question is that what will be the value of -
Server Name and Database Name. I belive they different from Host name and port.
I am ble to connect to it from the serevr itself using data source. But I want to connect to the BOE server from the Laptop.
Please let me knwo if you have any information about it.
Regards,
Sc
To connect to the database server on a different machine, you first need to install the SQL Anywhere client on that machine. You basically need the ODBC driver. Then you need to enter the following:
Host: The name or IP address of the BOE server
Port: 2638 (this is the default port for SQL Anywhere)
For Server Name and Database Name, those are the same values you see in the ODBC DSN definition on the BOE server. The Server Name must be unique - by default this name will be "BOE120SQLAW_" followed by the BOE user name. The Database Name is "BOE120". Please look at the data source name profile for the exact values.
Thank you for reply.
Can you please tell me where to check the Server Name and Database name on CMC page or anywhere else. I checked the Settings page and i can see the data source names. I belive the Database name will be nothing but the datasource name. Where I can see thet server name.
Please let me know.
Regards,
SC
Are you running under Windows? If so, go to your BOBJ server and open the ODBC Administrator. In there, go to the System DSN tab to find an entry called "BOE120". Open that entry to see the SQL Anywhere ODBC configuration for the CMS database. Click the Login tab - the Server Name and Database Name are displayed there.
Thank you.
I do see it.
Regards,
SC
For those who need Server Name and Database Name (for e.g. using Linux). Open CMC > Servers.
Check the Metrics of x.CentralManagementServer. Under the System Database Server Name you will find the correct server name. Typically the Audit database name is BI4_Audit. Here you can also see the CMS database name, user and all the other relevant information. Port: 2638 (as mentioned is the default port for SQL Anywhere).
in attached screen where can i found Metrics of x.CentralManagementServer. Under the System Database Server Name you will find the correct server name
Thanks for your blog post.
However, do you know if there is any limitation for using the default bundled version of Sybase ASE ? Any limitation on size / performance etc ?
Regards,
Good work Jose 🙂
hi
i´m new with sap bo 4.1 then i will need help with the installation.
i´m trying to install sap bo 4.1 on sql server , i created 2 databases on sql server like these
SAPBO_CMS
SAPBO_AUDIT
when the installer asking for the information to cms, i can choose the odbc for sap_cms correctly, then i click next but when it asking for the DSN for the Audit DataBase i can´t choose the odbc for sapbo_Audit that i have created before.
anybody can help me with that, i don´t know what i have to do in order to continue the install