Setting up connection between SQL server and Business Objects

[Former Member]

Hi,

I am new to BO, want to setup connection between SQL server and Business Objects. What are the steps which needs to be followed.

Many thanks in Advance.

[Former Member]

Assuming you have all the privileges to create and publish in Designer and webi?deski

1) Create system DSN on the server and your machine (in case if you are developing on your system and exporting to server)

2) In Designer, Create a Connection

3) Design Universe

4) Export universe

5) Create a report (DeskI/ WebI) depending on your need.