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
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.
Have you installed the driver on the server.
Also check if it is connected using the QlikView.
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.
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).
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);