We have installed OBIEE on linux machine.
What we are doing currently : created a db link to sqlserver and pull the tables from sqlserver as views into oracle database and create RPD.
I want to know If we can connect directly from RPD on linux machine to sqlserver??
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 ???