Can AS 2005 connect to Teradata directly?

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Byron - 17 Aug 2005 02:17 GMT

Hi,

We need Analysis Service 2005 connect to Teradata directly, but we can¡¦t
find the way. There is no odbc driver selection in AS 2005. How can we do
that?

Thanks

Byron Hu

Reply to this Message

Dave Wickert [MSFT] - 17 Aug 2005 02:43 GMT

Contact Teradata. They are releasing an OLEDB Provider for TD and it can be
used by AS2K5.

Signature

Dave Wickert [MSFT]
dwickert@online.microsoft.com
Program Manager
BI Systems Team
SQL BI Product Unit (Analysis Services)
--
This posting is provided "AS IS" with no warranties, and confers no rights.

> Hi,
>
[quoted text clipped - 5 lines]
>
> Byron Hu

Reply to this Message

Byron - 17 Aug 2005 06:56 GMT

Thank you.

We'll try it. We have heard AS 2005 will not support ODBC. Is that true?

Byron

"Dave Wickert [MSFT]" <dwickert@online.microsoft.com> ¼¶¼g©ó¶l¥ó·s»D:O01DX1soFHA.764@TK2MSFTNGP14.phx.gbl...

> Contact Teradata. They are releasing an OLEDB Provider for TD and it can
> be used by AS2K5.
[quoted text clipped - 7 lines]
>>
>> Byron Hu

Reply to this Message

Dave Wickert [MSFT] - 17 Aug 2005 22:04 GMT

I don't know if I would word it that way.
AS2K5 only supports OLEDB (in fact this is true with *all* versions of AS,
even back to the V7 days). What is new is that SQL2K5 on the relational side
has dropped support for the OLEDB Provider for ODBC. Thus AS has no way of
getting to a general ODBC data source.

If the only way of getting to your data is via ODBC then you will have to
read it from SSIS and then pump it into AS with the AS processing task that
is available to it -- or you could stage it in a data source with an OLEDB
provider being available.

Signature

> Thank you.
>
[quoted text clipped - 15 lines]
>>>
>>> Byron Hu

Reply to this Message