Tuesday, February 14, 2012

Connecting toTeradata .NET data provider

I need help connecting to the Teradata .NET data provider inReporting Services.

In Visual Studio I selectNew Project thenBusiness IntelligenceProject.

Once open, in theSolution Explorer I right-click onSharedData Sources and clickAdd New Data Source.

I do not understand how to get "Teradata" to show in theType list ofavailable data sources. I do not want toconnect to Teradata via ODBC or OLD DB. I want to connect directly to the Teradata .NET data provider.

Can anyone with more experience with SSRS help me shed somelight on this?

Add a new report say Test.rdl. Double click on it. The on click on Data tab. This is where you set Datasource etc.

-kushpaw

|||

kushpaw:

Add a new report say Test.rdl. Double click on it. The on click on Data tab. This is where you set Datasource etc.

-kushpaw


Hi kushpaw, that did not answer my question.

I am aware of how to set a datasource of type ODBC, SQL Server, XML, OLE DB, or Orical. What I want to know is how add Teradata to that list. Keep in mind, from my original question, I do not want to connect to Teradata through ODBC or OLE DB, but connect directly to the Teradata .NET data provider.

|||

Here is the solution for others who may want to do the same thing:

Inrsreportserver.config andRSReportDesigner.config add to the <data> tag
<ExtensionName="Teradata"Type="Teradata.Client.Provider.TdConnection,Teradata.Client.Provider, Version=1.0.0.0, Culture=neutral, PublicKeyToken=76b417ee2e04956c"/>
*note* The Version, Cutlure, and PublicKeyToken can be found in C:\Windows\assembly

In RSReportDesigner.config add to the <Designer> tag
<ExtensionName="Teradata"Type="Microsoft.ReportingServices.QueryDesigners.GenericQueryDesigner,Microsoft.ReportingServices.QueryDesigners"/>

No comments:

Post a Comment