Question

How Do You Connect To Sql Server To Create A Universe To Use In A Webi Report?

Answer 1

Answer:

The first thing you need to do is create a connection to the database. This is done in the Designer tool. When you click new in Designer it will display a wizard and you can set it up as part of this, or alternatively you can use the tools connections. For SQL Server the connection can be created using ODBC drivers or direct to SQL Server. If ODBC then you will need to have configured the DataSource.

Having created the connection, you can use it by setting it in the universe parameters.

To see a list of tables available simply right click the data view panel (main panel on the right)

Answer 2

I have an SQL Server database, which i want to use with Web Intelligence / Xcelsius. How to i add this database to the ...