![]() ![]() Either double-click the JAR file or execute the jar file from the command-line.įill in the connection properties and copy the connection string to the clipboard. Server=MyServer Port=MyPort User=SampleUser Password=SamplePassword Database=MyDB Kerberos=true KerberosKDC=MyKDC KerberosRealm=MYREALM.COM KerberosSPN=server-name Built-in Connection String Designerįor assistance in constructing the JDBC URL, use the connection string designer built into the Sybase JDBC Driver. You can find an example connection string below: See the Using Kerberos section in the Help documentation for more information on using Kerberos authentication. 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. Whether you are working with relational, NoSQL, or cloud databases, your data is easily and quickly accessible with Aqua Data Studio. It allows you to develop, access, manage, and visually analyze data. Sybase supports several methods for authentication including Password and Kerberos. Aqua Data Studio is the universal database integrated development environment (IDE) for Database Developers, DBAs, and Analysts. 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:.Aqua Data Studio also provides an Execute Explain button in. In the Register Server form, select the 'Generic - JDBC' connection. Multi-execution plans are supported and executing a script will generate multiple execution plans.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. 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. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |