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