Use of DSEDIT tool to create entry in sql.ini file for Sybase ASE database

[Abhishek_Sinha]

SAP Data Services installation stalls as the installer is unable to identify the CMS and Audit repositories.

Environment for this installation setup

• Product - SAP Data Services 4.3 
• Database - Sybase ASE 16.0
• Operating system - Windows Server 2019 Standard

Initial investigation took us to the ODBC connections and it worked fine and successfully connected to the respective database repositories. However on deeper analysis, it was observed that for the backend Sybase ASE database the connection doesn’t utilizes the ODBC connectors, it requires a Sybase client to be installed on the application machine and the resulting sql.ini file needs to be updated with the entries for CMS and AUDIT repositories.

SAP Data Services or Business Intelligence installation on Sybase ASE database needs the following client to be installed on the application host

After the installation below shown "sql.ini" file is created which needs to be amended with the entries of the repositories required for connection.

The format for the entries are

[CMS]
master=TCP,<Host/IP_of_DataBase_Host>,<Port_of_DataBase>
query=TCP,<Host/IP_of_DataBase_Host>,<Port_of_DataBase>

[AUDIT]
master=<Host/IP_of_DataBase_Host>,<Port_of_DataBase>
query=TCP,<Host/IP_of_DataBase_Host>,<Port_of_DataBase>

Another way of updating the sql.ini file is to use the DSEDIT tool provided by the client.

Launch the tool with administrator access

Click Ok

Click on the ServerObject and select Add

Enter the name of the repository, this should be exactly the same which will be used in the installation, in this example “CMS”

Double click on the server address bar on the right and click on the add button

On the TCP protocol in the network address bar enter the hostname/IP address followed by the port number at which the Sybase ASE DB is reachable separated by a comma

Once the entry is added test the connection

Right click and select Ping Server

Click on Ping

A connect succeeded message will prove the connection is successfully established, and an entry will get created in the sql.ini file with right syntax and parameters.

Now the installer will identify the CMS and AUDIT database repositories