Does the .net data provider for Teradata work the same way as the ole db provider for Teradata? I have created a data source using the .net provider and verified the connection to Teradata but when I go through the data source view wizard it will not bring back a list of tables/views and appears to just sit idle.
Thanks.
I experienced the same problem with a self-developed .NET provider for anotherdatabase while creating a data source view in BI Development Studio:
A connection to the database is established without any problems. Then the
application just queries the provider's data source information table and that's all.
It does not even try to query the tables in the database.
Is this a known bug in SSAS 2005?|||
I also found this where the tables/views were not shown.
If you click Next to accept an empty Data Source View screen I found that you can then add tables/view by right-click on the DSV screen and click on 'New Named Query'. Name the table and add you SQL to extract from the Teradata table (you can click the small arrow icon to run the query or click OK to return to the DSV and then use 'Explore Data'.
I have used this as a workaround until someone comes up with a better answer.
No comments:
Post a Comment