topic Re: Error while connecting to Teradata in QMC in QlikView

Error while connecting to Teradata in QMC

Anonymous — Mon, 22 Feb 2016 07:36:43 GMT

Hi All,

I have created a task in QMC- System - Supporting Tasks - Database Command and connecting to Teradata which is installed in the machine in below format

Provider=Teradata;DBCName=MyDbcName;Database=myDataBase;Uid=myUsername;Pwd=myPassword;

But upon running the task, I get a error as below

QDSMain.Exceptions.TaskFailedException: Task failed ---> System.InvalidOperationException: The 'Teradata' provider is not registered on the local machine.

Can anyone help me with this.

Thanks,

Niharika

Re: Error while connecting to Teradata in QMC

kaushiknsolanki — Mon, 22 Feb 2016 07:42:28 GMT

Hi Niharika,

Have you installed the driver on the server.

Also check if it is connected using the QlikView.

Regards,

Kaushik Solanki

Re: Error while connecting to Teradata in QMC

Anonymous — Mon, 22 Feb 2016 07:53:12 GMT

might be helpful for you?

Is it possible to connect qlikview to teradata?

Direct discovery Teradata 14

Re: Error while connecting to Teradata in QMC

Anonymous — Mon, 22 Feb 2016 13:20:20 GMT

Hi Kaushik,

Teradata Driver is installed in the server and a ODBC connection is created for the required Datasource.

Now in QlikView I am using Database as OLEDB and selecting Provider as Microsoft OLEDB Provider for ODBC drivers and selecting the Datasource which is created. Then the connection is successful in Qlikview.

The connection string which is generated is in below format

OLEDB CONNECT32 TO [Provider=MSDASQL.1;Persist Security Info=False;User ID=userid;Data Source=mydatasource;Extended Properties="DSN=mydatasource;UID=userid; "];

Now, I have created a task in QMC(same server)- System - Supporting Tasks - Database Command and connecting to Teradata in below format:

Provider=TDOLEDB;Data Source=mydatasource;Persist Security Info=True;User ID=userid;Password=mypassword;Session Mode=ANSI;

But I am getting an error that

System.InvalidOperationException: The 'TDOLEDB' provider is not registered on the local machine. ||

Kindly help me with this.

Regards,

Niharika

Re: Error while connecting to Teradata in QMC

Anonymous — Tue, 23 Feb 2016 14:54:11 GMT

Any suggestions ?

Re: Error while connecting to Teradata in QMC

jerrysvensson — Tue, 23 Feb 2016 15:09:58 GMT

Maybe I am missing something, but why not use the same Connection string in QMC as in Developer?

Re: Error while connecting to Teradata in QMC

Anonymous — Tue, 23 Feb 2016 15:24:55 GMT

Hi Jerry,

I have even tried using

Provider=MSDASQL.1;Persist Security Info=False;User ID=userid;Data Source=mydatasource;Extended Properties="DSN=mydatasource;UID=userid; " in QMC,

but it is throwing an error that

The .Net Framework Data Provider for OLEDB (System.Data.OleDb) does not support the Microsoft OLE DB Provider for ODBC Drivers (MSDASQL). Use the .Net Framework Data Provider for ODBC (System.Data.Odbc).

Regards,

Niharika

Re: Error while connecting to Teradata in QMC

pooja_sn — Wed, 24 Feb 2016 06:44:03 GMT

I am not really sure about what you are looking for. but I have tried steps below and it works fine for me:

1. On QMC server Control Panel -> Administrative Tools -> Data Source(ODBC) -> System DSN -> Add DataSourceName with specifications to connect to database.

2. And in Qlikview script , below code to connect to database:

ODBC CONNECT TO DataSourceName(XUserId is userId XPassword is password);

Re: Error while connecting to Teradata in QMC

jerrysvensson — Wed, 24 Feb 2016 07:55:53 GMT

But it does work in Developer on the same machine with the same user?

And you use OLEDB CONNECT32 in QMC also?

Re: Error while connecting to Teradata in QMC

pooja_sn — Wed, 24 Feb 2016 08:40:26 GMT

No. I have used ODBC CONNECT on QMC.

Re: Error while connecting to Teradata in QMC

Anonymous — Wed, 24 Feb 2016 08:59:14 GMT

Hi Jerry,

I am not using OLEDB connect32 in the connection string in QMC.

Re: Error while connecting to Teradata in QMC

jerrysvensson — Wed, 24 Feb 2016 11:04:27 GMT

Why not use the same connection in QMC as in Developer?

Since that seems to work..