cancel
Showing results for 
Search instead for 
Did you mean: 

Business Objects Open Connectivity Configuration in Universe Connection

Former Member
0 Kudos

Friends,

               i'm trying to create a Universe based on a flat file. I found out this Business Objects Open Connectivity (in Generic Sources) to use files as sources.
But I'm not sure how to use it? Can anyone help with this or share a doc how to use this functionality?

Accepted Solutions (0)

Answers (2)

Answers (2)

former_member182342
Active Contributor
0 Kudos

Hi BHARATH C S ,

Follow the below steps.

1. Save the Excel in Local disk.

2. Go to Start>>Control Panel>>Administrative tools>Data Sources(ODBC)

3. Select System DSN>>Add>>Microsoft excel Driver(*.xls)

4. Give a new data source name and click on 'Select workbook' and point the saved excel sheet and click on OK

5. Create a new connection in Universe designer by using the Generic ODBC connection

6. Create a new universe and insert the table which we have defined in the Excel sheet.

If this solve your issue then Mark the answer as a correct.

Regards,

Anish

jyothirmayee_s
Active Contributor
0 Kudos

Hi,

What is the version of the BO you have?. X3 or 4?.

If it is BO 4.0, Is it IDT or UDT?.

Thanks,

Jothi

Former Member
0 Kudos

Jothi,

       It is BO xi 3.1

Thanks,

Bharath

Former Member
0 Kudos

Hi Bharath,

Creating a universe with flat file as a data-source is not possible in SAP BO 3.1

it is possible from SAP BO 4.0 versions.