Can AS 2005 connect to Teradata directly?

Hi,
We need Analysis Service 2005 connect to Teradata directly, but we cant
find the way. There is no odbc driver selection in AS 2005. How can we do
that?
Thanks
Byron HuContact Teradata. They are releasing an OLEDB Provider for TD and it can be
used by AS2K5.
--
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.
"Byron" <byron_hu@.uuu.com.tw> wrote in message
news:eJi2wlsoFHA.1948@.TK2MSFTNGP12.phx.gbl...
> Hi,
> We need Analysis Service 2005 connect to Teradata directly, but we cant
> find the way. There is no odbc driver selection in AS 2005. How can we do
> that?
> Thanks
> Byron Hu
>|||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> glsD:O01DX1soFHA.764@.TK2
MSFTNGP14.phx.gbl...
> Contact Teradata. They are releasing an OLEDB Provider for TD and it can
> be used by AS2K5.
> --
> 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.
>
> "Byron" <byron_hu@.uuu.com.tw> wrote in message
> news:eJi2wlsoFHA.1948@.TK2MSFTNGP12.phx.gbl...
>|||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.
--
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.
"Byron" <byron_hu@.uuu.com.tw> wrote in message
news:Ozj%23FCvoFHA.2472@.TK2MSFTNGP15.phx.gbl...
> 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>
> glsD:O01DX1soFHA.764@.TK2MSFTNGP14.phx.gbl...
>