Warning noteThe Sybase ASE Connector in the Qlik ODBC Connector Package is no longer supported. As an alternative, you can install an ODBC driver for Sybase ASE and create a data source DSN. See ODBC.
To access your data stored on a Sybase ASE database, you will need to know the server and database name that you want to connect to, and you must have access credentials. Once you have created a connection to a Sybase ASE database, you can select data from the available tables and then load that data into your app or document.
In Qlik Sense, you connect to a Sybase ASE database through the Add data dialog or the Data load editor.
In QlikView you connect to a Sybase ASE database through the Edit Script dialog.
Setting up the database properties
| Database property | Description | Required |
|---|---|---|
| Host name | Host name to identify the location of the Sybase ASE database. | Yes |
| Port | Server port for the Sybase ASE database. | Yes |
| Database | The name of the Sybase ASE database. | Yes |
Authenticating the driver
Qlik Sense: Sybase ASE authentication properties
| Authentication property | Description |
|---|---|
| Username | User name for the Sybase ASE connection. |
| Password | Password for the Sybase ASE connection. |
| Name |
Name of the Sybase ASE connection. The default name will be used if you do not enter a name. |
QlikView: Sybase ASE authentication properties
| Authentication property | Description |
|---|---|
| Username | User name for the Sybase ASE connection. |
| Password | Password for the Sybase ASE connection. |
Miscellaneous properties
| Property | Description |
|---|---|
| Query timeout | Amount of time before a data load query times out. Can be set from 30 seconds to 65535 seconds. Default is 30 seconds. |
Advanced options
Information noteThis section is for advanced users who want to add their own custom connection parameters that are not displayed above.
| Property | Description | Required |
|---|---|---|
|
Name |
Name of the custom property. You can add additional properties by clicking the |
No |
| Value |
Value of the property. |
No |
. Information noteWhen you connect to a Sybase ASE database with the Data load editor or the Edit Script dialog, Test Connection enables you to test the connection before you attempt to create it.