Like many BusinessObjects administrator out there, I’m discovering these days a lot about the SAP “classic” technologies.  In this article I will be writing about SAP Sybase SQL Anywhere as it comes out-of-the-box as the Repository and Audit databases server for the latest SAP BO/BI products.  See Database Administration Tools for SQL Anywhere CMS and Audit DBs.

I have three main objectives:

  1. I want to learn a new tech!
  2. I would like to be able to manage (backup / restore / monitoring / more) my SAP BI 4.x databases.
  3. I need new databases to configure SAP Data Services.  As I’m building a test VM, I don’t really need MS SQL, Oracle of any of the other usual vendors.  I don’t know if we are licensed to do this – to be checked with SAP.

The articles below on the BI Platform Space are why I need new databases:

Table of Contents:

Installing SAP Sybase SQL Anywhere Database Client

Run: SA1201_Client.exe

1- Welcome.png

Click: Next

2- Language.png

Click: OK

3- Welcome.png

Click: Next

4- License.png

Select Country or Region: United Kingdom

I accept the terms of this agreement: selected

Click: Next

5- Features.png

Click: Next

6- Ready.png

Click: Install

7- Done.png

Click: Finish

Managing and Maintaining your SAP BI databases

I’m not a DBA and I won’t try to be!  There are plenty of clever people on this Space: SQL Sybase SQL Anywhere but hopefully this is going to be helpful for the beginners like me with this technology.


Open Sybase Central

1- Open.png

2- Connect.png

Right-click: SQL Anywhere

Click: Connect…

3- Connect.png

Authentication: Database

User ID: dba (or whatever was selected during the SAP BI 4.x installation)

Password: ********

Action: Connect with an ODBC Data Source

Click: Browse

Select: BI4_CMS_DSN

Click: Connect

4- Tasks.png

In this screen you have access to a lot of useful features such as Database Maintenance Tasks, list of Tables, Overview (for Statistics), etc

You can also find a great article by Jose Ramos: Backing Up the CMS and Audit Databases Using SQL Anywhere Maintenance Plans

Note: Doing the above steps will connect to the local instance and also list the Audit Database (BI4_Audit_DSN)

5- Audit.png

Click: Context

Select: BI4

Creating a new database in SAP Sybase SQL Anywhere

Open Sybase Central

1- Open.png

1- Create.png

Click: Tools menu > SQL Anywhere 12 > Create Database…

2- Welcome.png

Click: Next

3- Location.png

Click: Next

4- DB File.png

Enter the location and file name you want your database file to be

Click: Finish

Note: You could click Next to modify other optional configurations such as log files location, credentials, etc

5- Success.png

You now have a new database.  The default credentials are:

  • Username: dba
  • Password: sql

6- End.png

I hope this was helpful.  I welcome and suggestions, comments or anything else to make this article better.

Thanks

To report this post you need to login first.

9 Comments

You must be Logged on to comment or reply to a post.

    1. Chris Keating

      The Client software install does not require a license key. Licensing is required for server components installs and you will be required to supply the license key when installing those components. For embedded use cases, the user might not be responsible for supplying a license key – that may be handled behind the scenes by the application or its installer that is using the SQL Anywhere server components.

      (0) 
  1. Vikas Kaul

    Hi Patrick,

    Would you also send the steps to backup and restore the sybase database? How to restore on same host and on different host?

    Thanks

    (0) 

Leave a Reply