To leverage Kerberos authentication, begin by enabling it setting AuthScheme to Kerberos. To connect with LDAP authentication, you will need to configure Sybase server-side to use the LDAP authentication mechanism.Īfter configuring Sybase for LDAP, you can connect using the same credentials as Password authentication. Password: Set this to the username of the authenticating Sybase user.User: Set this to the username of the authenticating Sybase user.Set the AuthScheme to Password and set the following connection properties to use Sybase authentication. Sybase supports several methods for authentication including Password and Kerberos. Optionally, you can also secure your connections with TLS/SSL by setting UseSSL to true. Database: Set this to the name of the Sybase database running on the specified Server.Server: Set this to the name or network address of the Sybase database instance.To connect to Sybase, specify the following connection properties: URL: Enter the JDBC URL, which starts with jdbc:sybase: and is followed by a semicolon-separated list of connection properties. Driver: Enter the Driver's class name,.Driver Location: Click the Browse button and select the file, located in the lib subfolder of the installation directory.Name: Enter a name for the data source for example, Sybase.Enter the following JDBC connection properties:.In the Register Server form, select the 'Generic - JDBC' connection.In Aqua Data Studio, select Register Server from the Servers menu.The Sybase data source can then be accessed from Aqua Data Studio tools. You can use the connection manager to define connection properties and save them in a new JDBC data source.
#Conneting in aqua data studio how to#
This article shows how to connect to Sybase data through the connection manager and execute queries. The CData JDBC Driver for Sybase integrates Sybase data with wizards and analytics in IDEs like Aqua Data Studio.