Universe Design tool, Unable to connect Datasource

1. Open Universe Design tool and open project efashion universe
2. I click on "detect join"
or From Webi facing below error:

Error

Database error: [Microsoft] [ODBC Driver Manager] Data source name not found and no default driver specified.
(IES 10901) (WIS 10901)

Problem:

No correct database connection defined to the universe

Solution

Go to File, click on parameters.

Create a new connection or edit existing connection pointing to the correct database.

It works!!

Universe Design Tool - Oracle jdbc connection error

Facing error while creating jdbc connection with oracle from "Universe Design Tool"

1. Open "Universe Design Tool" and create a new connection.

2. Fill correct details about connection and test it.

Error:

CS: Java Class not found in classpath : oracle.jdbc.OracleDriver

Cause : Missing JDBC driver 

Resolve:

1. Copy Oracle JDBC driver from oracle server/client installtion path and paste it somewhere on machine at safe place.
oracle installation path - "\app\******\product\11.2.0\dbhome_1\jdbc\lib"
or
Download the ojdbc driver from internet

It is good practice to paste the jdbc driver in C drive "C:\Users\******"

2. Now move to the installation directory of BO
"SAP BusinessObjects Enterprise XI 4.0\dataAccess\connectionServer\jdbc\"

3. Edit the file "oracle.sbo", open with notepad++.

Edit tab classpath, add new line highligheted in yellow color, which is pointing to the ojdbc driver (place in c drive as above).

4. Restart "universe design tool"

5. Try to create same connection again.

BO1 Prerequisite Window Version Failed

Information: This product needs to be installed on Windows Server 2008 or a higer Windows Server Version. please verify that your version of Windows meets these requirements.

Install SAL BO 4.1 on Windows 7. Yes this is possible , u need to change one file "product.seed.xml"

• First of all extract 51046778 folder and move to below specified path 

"..\51046778\DATA_UNITS\BusinessObjectsServer_win\dunit\product.businessobjects64-4.0-core-32"

• Now open file  "product.seed.xml"
• Move to line number 1520

• Change parameter value from "server" to "Workstation"
• Save and close
• Now reinstall.

Thanks!!!!!!