Setting
|
Description
|
LogPath
|
Path to save log files in when LogToFile is enabled.
|
LogToFile
|
Boolean, Default False. If enabled, a log file (at the “High” level) with be created within the specified LogPath location.
|
CommandTimeout
|
Length in seconds for SQL commands to execute
|
ProxyEnabled
|
Boolean, Default False. If enabled, Starfish ETL™ will use the specified Proxy server when validating it’s license.
|
ProxyURL
|
URL for proxy server
|
ProxyPort
|
Port proxy server is running on
|
ProxyUseDefaultCredentials
|
Boolean, Default False. If enabled, default network credentials will be used.
|
ProxyUseSuppliedCredentials
|
Boolean, Default False. If enabled, the credentials specified below will be used.
|
ProxyCredentialsUsername
|
Proxy username
|
ProxyCredentialsPassword
|
Proxy password
|
ProxyCredentialsDomain
|
Proxy user’s domain
|
RowThreadCount
|
Default: 1. The default number of threads to use when executing a Starfish ETL™ job.
|
UseParamQueries
|
Boolean, Default False. If enabled (default), Starfish ETL™ will build parameterized SQL queries. If disabled, queries will instead be sent as normal text. Useful for performance tweaking.
|
UseNoLock
|
Boolean, Default False. If enabled, Starfish will append the SQL “WITH(NOLOCK)” command to generated lookup statements. Useful for performance tweaking.
|
UseDatabaseXRef
|
Setting this value to true will use the SQLite database to store XREF files instead of text documents.
|
CountStatement
|
Default “COUNT(*)”. When doing lookups, Starfish ETL™ will perform a statement such as “SELECT COUNT(*) FROM TABLE WHERE …” to determine if a record exists or not. Changing this value to something like “COUNT(1)” may help performance for some database systems.
|