Does anyone know how to specify the authentication method in the Qlikview Teradata connector? Or in the Qlik Sense Teradata connection?
I have successfully run a BTEQ query using LDAP authentication as the .LOGMECH parameter, but I don't see where to specify the LOGMECH in the Qv Connector wizard.
Preparatory steps include:
1) Install the Teradata tools and Utilities (especially FastExport and BTEQ)
2) Edit the hosts file located at: C:\Windows\System32\drivers\etc to include the ip address of the named data source (BASDW).
3) telnet and ping to the server are successful
4) Test a connection to the server using BTEQ
.LOGMECH LDAP
.LOGON BASDW/HC_PRD_U_MICHAEL.KINNEY
<password>
**Successful
5) The TPTConnector wizard does not give the option to specify the authentication method, but I try anyway and get the following errors:
Qliksense - Error Message: Please check the values for Username, Password, Host and other properties. Description: Access credentials are not valid for this connection.
Qlikview - The connection test failed. Failure 8017 The UserID, Password or Account is invalid...
Perhaps the wizard requires a very picky syntax?
Here is the resulting log generated by the QvTPTCOnnector in Qlikview:
000175 2017-07-20T14:47:19.495-04:00 AD005\z003du2z Notice QvxLibrary version 2.0.9993.0
000176 2017-07-20T14:47:19.504-04:00 AD005\z003du2z Notice QvTptConnector version 1.0.0.27914
000177 2017-07-20T14:47:34.721-04:00 AD005\z003du2z Notice QvxLibrary version 2.0.9993.0
000178 2017-07-20T14:47:34.727-04:00 AD005\z003du2z Notice QvTptConnector version 1.0.0.27914
000179 2017-07-20T14:48:31.439-04:00 AD005\z003du2z Error Error executing bteq: *** Error: Logon failed!
000179 2017-07-20T14:48:31.448-04:00 AD005\z003du2z Error Tool output:
000180 2017-07-20T14:48:31.454-04:00 AD005\z003du2z Error Error executing bteq: *** Warning: You must log on before sending SQL requests.
000181 2017-07-20T14:48:31.468-04:00 AD005\z003du2z Error BTEQ 15.10.01.01 Thu Jul 20 14:48:22 2017 PID: 10360
000183 2017-07-20T14:48:31.481-04:00 AD005\z003du2z Error
000184 2017-07-20T14:48:31.487-04:00 AD005\z003du2z Error +---------+---------+---------+---------+---------+---------+---------+----
000185 2017-07-20T14:48:31.494-04:00 AD005\z003du2z Error .SET ERROROUT STDERR;
000186 2017-07-20T14:48:31.501-04:00 AD005\z003du2z Error *** Error messages now directed to STDERR.
000187 2017-07-20T14:48:31.509-04:00 AD005\z003du2z Error +---------+---------+---------+---------+---------+---------+---------+----
000188 2017-07-20T14:48:31.515-04:00 AD005\z003du2z Error .SET ECHOREQ OFF;
000189 2017-07-20T14:48:31.522-04:00 AD005\z003du2z Error +---------+---------+---------+---------+---------+---------+---------+----
000190 2017-07-20T14:48:31.529-04:00 AD005\z003du2z Error +---------+---------+---------+---------+---------+---------+---------+----
000191 2017-07-20T14:48:31.535-04:00 AD005\z003du2z Error +---------+---------+---------+---------+---------+---------+---------+---------+---------+---------+---------+---------+---------+-
000192 2017-07-20T14:48:31.541-04:00 AD005\z003du2z Error *** Failure 8017 The UserId, Password or Account is invalid.
000193 2017-07-20T14:48:31.547-04:00 AD005\z003du2z Error
000194 2017-07-20T14:48:31.554-04:00 AD005\z003du2z Error *** Total elapsed time was 9 seconds.
000195 2017-07-20T14:48:31.559-04:00 AD005\z003du2z Error
000196 2017-07-20T14:48:31.563-04:00 AD005\z003du2z Error +---------+---------+---------+---------+---------+---------+---------+---------+---------+---------+---------+---------+---------+-
000197 2017-07-20T14:48:31.567-04:00 AD005\z003du2z Error *** To reset export, type .EXPORT RESET
000198 2017-07-20T14:48:31.571-04:00 AD005\z003du2z Error +---------+---------+---------+---------+---------+---------+---------+---------+---------+---------+---------+---------+---------+-
000199 2017-07-20T14:48:31.576-04:00 AD005\z003du2z Error +---------+---------+---------+---------+---------+---------+---------+---------+---------+---------+---------+---------+---------+-
000200 2017-07-20T14:48:31.580-04:00 AD005\z003du2z Error *** Output returned to console.
000201 2017-07-20T14:48:31.585-04:00 AD005\z003du2z Error +---------+---------+---------+---------+---------+---------+---------+---------+---------+---------+---------+---------+---------+-
000202 2017-07-20T14:48:31.589-04:00 AD005\z003du2z Error *** BTEQ exiting due to EOF on stdin.
000203 2017-07-20T14:48:31.593-04:00 AD005\z003du2z Error *** Exiting BTEQ...
000204 2017-07-20T14:48:31.598-04:00 AD005\z003du2z Error *** RC (return code) = 8
000205 2017-07-20T14:48:31.602-04:00 AD005\z003du2z Error *** Error: Logon failed!
000206 2017-07-20T14:48:31.607-04:00 AD005\z003du2z Notice bteq executed in 00:00:09.8670000
000207 2017-07-20T14:48:31.612-04:00 AD005\z003du2z Notice Test connection failure details:
000208 2017-07-20T14:48:31.617-04:00 AD005\z003du2z Notice BTEQ 15.10.01.01 Thu Jul 20 14:48:22 2017 PID: 10360
000209 2017-07-20T14:48:31.622-04:00 AD005\z003du2z Notice
000210 2017-07-20T14:48:31.626-04:00 AD005\z003du2z Notice +---------+---------+---------+---------+---------+---------+---------+----
000211 2017-07-20T14:48:31.631-04:00 AD005\z003du2z Notice .SET ERROROUT STDERR;
000212 2017-07-20T14:48:31.635-04:00 AD005\z003du2z Notice *** Error messages now directed to STDERR.
000213 2017-07-20T14:48:31.639-04:00 AD005\z003du2z Notice +---------+---------+---------+---------+---------+---------+---------+----
000214 2017-07-20T14:48:31.644-04:00 AD005\z003du2z Notice .SET ECHOREQ OFF;
000215 2017-07-20T14:48:31.648-04:00 AD005\z003du2z Notice +---------+---------+---------+---------+---------+---------+---------+----
000216 2017-07-20T14:48:31.652-04:00 AD005\z003du2z Notice +---------+---------+---------+---------+---------+---------+---------+----
000217 2017-07-20T14:48:31.657-04:00 AD005\z003du2z Notice +---------+---------+---------+---------+---------+---------+---------+---------+---------+---------+---------+---------+---------+-
000218 2017-07-20T14:48:31.661-04:00 AD005\z003du2z Notice *** Failure 8017 The UserId, Password or Account is invalid.
000219 2017-07-20T14:48:31.666-04:00 AD005\z003du2z Notice
000220 2017-07-20T14:48:31.671-04:00 AD005\z003du2z Notice *** Total elapsed time was 9 seconds.
000221 2017-07-20T14:48:31.675-04:00 AD005\z003du2z Notice
000222 2017-07-20T14:48:31.679-04:00 AD005\z003du2z Notice +---------+---------+---------+---------+---------+---------+---------+---------+---------+---------+---------+---------+---------+-
000223 2017-07-20T14:48:31.683-04:00 AD005\z003du2z Notice *** To reset export, type .EXPORT RESET
000224 2017-07-20T14:48:31.687-04:00 AD005\z003du2z Notice +---------+---------+---------+---------+---------+---------+---------+---------+---------+---------+---------+---------+---------+-
000225 2017-07-20T14:48:31.691-04:00 AD005\z003du2z Notice +---------+---------+---------+---------+---------+---------+---------+---------+---------+---------+---------+---------+---------+-
000226 2017-07-20T14:48:31.695-04:00 AD005\z003du2z Notice *** Output returned to console.
000227 2017-07-20T14:48:31.700-04:00 AD005\z003du2z Notice +---------+---------+---------+---------+---------+---------+---------+---------+---------+---------+---------+---------+---------+-
000228 2017-07-20T14:48:31.704-04:00 AD005\z003du2z Notice *** BTEQ exiting due to EOF on stdin.
000229 2017-07-20T14:48:31.709-04:00 AD005\z003du2z Notice *** Exiting BTEQ...
000230 2017-07-20T14:48:31.714-04:00 AD005\z003du2z Notice *** RC (return code) = 8
000231 2017-07-20T14:48:31.719-04:00 AD005\z003du2z Notice *** Error: Logon failed!
000232 2017-07-20T14:48:31.723-04:00 AD005\z003du2z Notice *** Warning: You must log on before sending SQL requests.
