| Author |
Can AS 2005 connect to Teradata directly?
|
|
|
| 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
| |
| Dave Wickert [MSFT] 2005-08-17, 3:23 am |
| 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...
> 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
>
| |
|
| 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> 撰寫於郵件新聞:O01DX
1soFHA.764@TK2MSFTNGP14.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...
>
>
| |
| Dave Wickert [MSFT] 2005-08-17, 8:23 pm |
| 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>
> 撰寫於郵件新聞:O01DX
1soFHA.764@TK2MSFTNGP14.phx.gbl...
>
>
|
|
|
|