Setting advanced connection properties
In the Advanced tab, you can set the following parameters:
- Automatically enable SAP Sybase ASE replication: Select this to automatically enable SAP Sybase ASE replication. This is only required if SAP Sybase ASE replication has not been enabled already. For more information, see Prerequisites.
-
Additional ODBC connection properties: Specify any additional ODBC connection parameters that you want to use.
Information noteIf the user name or password specified in the General tab contains non-Latin characters (e.g. Chinese), the following property is required:
charset=gb18030
-
Advance truncation point every (seconds): The frequency with which to advance the secondary truncation point when reading changes from the Sybase ASE log.
-
Dump the log every (seconds): How often to dump the parts of the log which Replicate has finished reading (i.e. the log behind the secondary truncation point). The default is "0" which means that Replicate never dumps the log.
Warning noteYou must change the default value. If you do not change the default value, the log will eventually consume all available disk space. In addition to changing the default value, you also need to create a stored procedure and turn off automatic truncation on checkpoint as described below.
-
Create a stored procedure for dumping the log, as shown in the following example:
create procedure attrep_dumpaction @DbName varchar(255)
as
if @DbName = '<source_db>'
Begin
<Check dump log not running.>
<Add your database logic here.>
print "Truncating log for database '%1!'", @DbName
dump transaction <source_db> with truncate_only
end
-
Turn off automatic truncation on checkpoint as follows:
sp_dboption <source_db>, "trunc log on chkpt", false
go
-
Internal parameters
Internal parameters are parameters that are not exposed in the UI. You should only use them if instructed by Qlik Support.
To add internal Qlik Replicate parameters:
-
Click the Internal Parameters link.
The Internal Parameters dialog box opens.
- In the edit box, type the name of the parameter you need to add and then click it.
- The parameter is added to the table below the search box with its default value.
- Change the default value as required.
- To reset the parameter value to its default, click the "Restore default value" icon at the end of the row.
More options
These options are not exposed in the UI as they are only relevant to specific versions or environments. Consequently, do not set these options unless explicitly instructed to do so by Qlik Support or product documentation.
To set an option, simply copy the option into the Add feature name field and click Add. Then set the value or enable the option according to the instructions you received.
Settings summary
You can view a summary of your settings by clicking the Setting Summary link. This is useful if you need to send a summary of your settings to Qlik Support.