DbSchema for SAP Adaptive Server Database

DbSchema is a powerful database management and design tool for SAP Adaptive Server. It offers features such as visual schema design, team collaboration with GIT, schema deployment and HTML schema documentation.

How to Connect to SAP Adaptive Server Database

  1. Access the Connection Dialog

    Choose "Connect to the database" or "New Model Connected to the Database" will let you select your database and open the Connection Dialog.

    DbSchema automatically downloads the JDBC driver to connect to your database.

  2. Configure the Connection

    3. In the Connection Dialog window, select the JDBC URL you want to connect with. If your database is running in the cloud, choose Edit Manually and insert the JDBC URL from the cloud console.

    Enter the host name, the authentication details, select your database as described in the Connection Dialog page.

  3. Troubleshoot Firewall Issues
    4. If you encounter connection issues, it may be due to firewall settings. Read how to enable Firewall Connections.
Remember to enable Windows Firewalls Firewalls & anti-viruses may block database connections.

Enabling the TCP/IP Port

For all editions of SAP Adaptive Server Enterprise:
  1. From the SAP Adaptive Server Configuration Manager, select SAP Adaptive Server Network Configuration in the left panel and navigate to the Sybase Adaptive Server instance.
  2. The right panel displays all protocols for the specified SAP Adaptive Server instance and their status.
  3. Ensure that TCP/IP is enabled.
  4. (If TCP/IP is disabled), right-click TCP/IP and select Properties. The TCP/IP Properties dialog box appears.
  5. In the Protocol tab, select enabled, and click Apply.
  6. Restart the SAP Adaptive Server instance.

Finding the TCP/IP Port

To find the TCP/IP port number for a particular SAP Adaptive Server instance, run the following query: 
Select address_info from syslisteners
The above query returns the host address followed by the port number.

Debug Connectivity Issues

  1. Check Network:
    From the machine where DbSchema is running execute: 
    ping HOST_NAME
    If this is failing it means the host name is wrong. In this case look on how to find the server host name as described in Connect to SqlServer.
  2. Check if the port is open.
    To verify that SQL Server listening port, you can use the telnet from the computer where you run DbSchema. If not installed, you can install Telnet like this:
    1. Click Start > Control Panel.
    2. Click Programs and Features.
    3. Click Turn Windows features on or off.
    4. In the Windows Features dialog box, check the Telnet Client check box.
    5. Click OK. The system installs the appropriate files. This will take a few seconds to a minute.
    Assume that SQL Server's IP address is 192.168.1.1 or host name 'samplehost', port 11433, you can run the following command: 
    telnet 192.168.1.1 1433
or
telnet samplehost 1433
    If the TELNET successful, then the result will be a only a black screen with cursor in flash. If unsuccessful, then you will get an error message. In this case please the port may be wrong. Please How to enable TCP/IP connections regarding on how to see the configured TCP/IP port.
  3. Check On Server the Port value and TCP/IP to be enabled
    Read the chapter How to enable TCP/IP connections. There you will find also instructions about finding the configured TCP/IP port.
  4. Create an exception for SQL Server in Windows Firewall:
    Follow the steps from the Firewall chapter.
  5. Enable the SQL Server Browser service:
    If you connect to a named instance, make sure the SQL Server Browser service by using SQL Server Configuration Manager is enable or specify the TCP port when connecting to it.