Setting general connection properties

This section describes how to configure general connection properties. For an explanation of how to configure advanced connection properties, see Setting advanced connection properties.

To add a SAP Sybase IQ database to Qlik Replicate:

1. In Tasks view, click Manage Endpoint Connections to open the Manage Endpoints Connections dialog box. Then click the New Endpoint Connection button.
2. In the Name field, type a name for your database. This can be any name that will help to identify the database being used.
3. In the Description field, type a description that helps to identify the Sybase database. This is optional.

4. Select Target as the database role.

5. Select SAP Sybase IQ as the database Type.
6. In the Host field, enter the hostname or IP address of the computer on which SAP Sybase IQ is installed.
7. In the Server field, enter the name of the Sybase server.
8. Optionally, change the default port (7878).

9. Type the Sybase authentication information (User Name, Password) for the authorized user for this Sybase database. If you do not know this information, see your Sybase database Administrator (DBA).

   Information note

   •   This information is required. If you are using the Advanced tab to create a custom string, make sure to include the User Name and Password properties. See Setting advanced connection properties for more information.

   • This information is case sensitive.
   • If you want to set custom properties for this database, see Setting advanced connection properties.
   Information note

   Make sure that the Sybase user entered in the Sybase Authentication section has the correct access privileges. For information on how to provide the required privileges, see Security requirements.

10. In the Database field, enter the name of the SAP Sybase IQ database.