Add the Sybase IQ Connector
Authenticate to Sybase IQ
After you add the connector, you need to set the required properties.- Server: Enter the host name or IP of the server that hosts either your or SAP SQL Anywhere database instance.
- Port: Enter the port number for your database. The default port value is 2638.
- Database: Enter the name of either your or the SAP SQL Anywhere database that runs on your specified server.
Password
Kerberos
To connect with Kerberos, specify these settings:- Auth Scheme: Select Kerberos.
- Kerberos KDC: Enter the host name or IP Address of your Kerberos Key Distribution Center (KDC) machine.
- Kerberos Realm: Enter the Kerberos realm that you use to authenticate to Kerberos.
- Kerberos SPN: Enter the service principal name (SPN) for the Kerberos domain controller.
- Kerberos User: Enter the principal username (in the format Host/User@Realm) for the Kerberos domain controller.
- Kerberos User: Enter the principal name for the Kerberos Domain Controller. The name should be in the form Host/User@Realm.
- (Optional) Kerberos Keytab File: Enter the full file path to your Kerberos keytab file.
- (Optional) Kerberos Ticket Cache: Enter the full file path to an MIT Kerberos credential cache file.
Complete Your Connection
To complete your connection:-
For Connection Type, select the server to which you want to connect:
- SybaseIQ (default)
-
SQLAnywhere: If you select this server, specify the following properties:
- Use SSL: Select whether you want to enable Secure Sockets Layer (SSL). By default, the Enable checkbox is not selected.
- SSL Server Cert: Enter the certificate that should be accepted from the server when you connect with Transport Layer Security (TSL) /Secure Sockets Layer (SSL) encryption.
- Define advanced connection settings on the Advanced tab. (In most cases, though, you should not need these settings.)
- Click Connect to to connect to your account.
- Click Create & Test to create your connection.