Yes we can do that,Create ODBC Connection to the sql server and start importing tables into the rpd by creating new connection pool.
Mark if helps.
Pls. check the OBIEE certification matrix for your OBIEE version... The version I've get indicates that SQL Server is certified for version 2005, 2008.
I can created a odbc connection on my local system and import tables.. etc.. That's fine..... What will happend after I deploy the RPD on to linux server ???