Re: QvTPTConnector Authentication - Qlik Community

Report Inappropriate Content · ‎2017-07-20

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

**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.

Report Inappropriate Content · ‎2017-07-28

Can you try with ODBC connector?

samuelll · ‎2022-03-23

did you ever come right with a solution here?

QvTPTConnector Authentication

QlikView App Dev