Skip to Content
Author's profile photo Patrick Perrier

Tutorial: Installing and Using SAP Sybase SQL Anywhere Database Client

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.


Assigned Tags

      You must be Logged on to comment or reply to a post.
      Author's profile photo Babacar Toure
      Babacar Toure

      Thank you Patrick for sharing!

      Author's profile photo Former Member
      Former Member

      Great content as always, Patrick. Keep up the good work!

      Author's profile photo Michal Jezewski
      Michal Jezewski

      How the License Key is installed during the installation process ? I do not see anywhere the place to put it 🙂

      Author's profile photo Chris Keating
      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.

      Author's profile photo Vikas Kaul
      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?


      Author's profile photo Jeff Albion
      Jeff Albion

      Hi Vikas,

      For instructions on how to backup / restore the BI CMS/Audit databases, see the document here:

      Author's profile photo Simon Iglesias
      Simon Iglesias

      Hi Patrick ,

      Dou you have this guide for Unix/Linux environments ?

      Thanks in Advance

      Knd Rgds


      Author's profile photo Sawa Ito
      Sawa Ito

      Hello Patric, I am translating English SQL Anywhere related documents on SCN into Japanese for Japanese users. Would you mind if I translate this document into Japanese and post on the following page? Regards, Sawa Ito

      Author's profile photo Former Member
      Former Member

      Good article but not worth without part 2.