I am working on a demo that has the purpose to create a WEBI report in BO which holds both data coming from SAP and data coming from a random database (through a Universe of course). The end user should be able to run the report by entering his or her credentials only once.
I've finally managed to load the data coming from a SQL Windows 2008 server in my WEBI report. I am using a connection through ODBC drivers. Both the client (me) and the server which holds the database are in the same domain and have an ODBC datasource set under Administrative Tools in the control panel. The thing is, I can only load this data in my WEBI report when I'm using the WEBI rich client. We also have a BO portal running on a server inside our organisation. When I try to create a report there using the same universe, I get the following error:
On the server which runs the BO portal, the ODBC datasource connection has been set (just like on my own client pc - with "Windows NT Authentication using the network login ID").
I suppose some extra steps are necessary on the server which is running the BO portal, but I don't know which ones?
My universe and its connection have been configured with the BO Credentials authentication mode (using LDAP).
Thanks in advance,