Error while connecting to Teradata in QMC

[Anonymous]

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

[kaushiknsolanki]

Hi Niharika,

Have you installed the driver on the server.

Also check if it is connected using the QlikView.

Regards,

Kaushik Solanki

[Anonymous]

might be helpful for you?

Is it possible to connect qlikview to teradata?

Direct discovery Teradata 14

[Anonymous]

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

[Anonymous]

Any suggestions ?

[jerrysvensson]

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

[Anonymous]

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

[pooja_sn]

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);

[jerrysvensson]

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

And you use OLEDB CONNECT32 in QMC also?

[pooja_sn]

No. I have used ODBC CONNECT on QMC.