How to Connect the Sybase IQ as a Data Source in MS SQL Analysis Services 2005

Hi
All,

Can any one know how to make a data source of Sybase IQ in Analysis Services.

I have OLE DB for Sybase.

Can i use that to connect Sybase IQ? If Yes than How.

Thanks,
Satish

Currently OLEDB for Sybase is not supported by Analysis Server. You will have to use a workarond to get data from Sybase. I can think of couple.

One is to create a linked server in SQL Server.
Second is to create a SSIS package reading data from Sybase and pumping it into Analysis Server using Dimension and Partition processing tasks.

Edward Melomed.
--
This posting is provided "AS IS" with no warranties, and confers no rights.

|||Hi
Edward,

Thanks for reply.

For Sybase it is working fine.

But My source is Sybase IQ.

In Sybase IQ, we have host and port with database server name, while in sybase we have only database server name.

Thanks,
Satish|||

Edward,

At the following link you suggest creating a linked server from SQL Server to Sybase IQ as a workaround for getting Sybase IQ data in analysis services. What are the parameters that are necessary to link IQ to SQL Server. Which Provider do I use? Do I need to install a special driver?

Thanks,

Eli