cancel
Showing results for 
Search instead for 
Did you mean: 

How to get data from Universe?

Former Member
0 Kudos

I used Design Studio 1.3, log on the server and add a new data source. When I selected the Universe I published on the server, Edit the Query, then I click the "Refresh" button on the "Edit Query Specification" dialog window, it showed me :

[Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified

I can Execute the query in Rich Client.

The universe is based on Microsoft Access 2010. I saved the .accdb file on my local drive ( not on the server ).

Should I copy my .accdb file to the server?

Thank you very much!

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

Hi Chunfeng,

When you access a Universe via the BI platform you need to ensure that the BI platform can access the data source. If this runs locally on your client this might not be the case. Are you working in local mode when using the Webi Rich client? If that's the case the client uses the local defined connection.

With kind regards,

Martijn van Foeken

Former Member
0 Kudos

Thank you, M. van Foeken!

I can select the Universe which is published on server via WIRC and can execute the query correctly. But I can't execute the query via Webi by BI launch pad. it shows: [Microsoft][ODBC][ODBC Driver manager] data source name not found and no default driver  specified

I am sure that I use C:\Windows\SysWOW64\odbcad32.exe to create the sdn.

mike_howles4
Active Contributor
0 Kudos

It should be a System DSN that is running wherever your ConnectionServer APS is running.  Also, I'm assuming you are using the .accdb driver and not trying to use the .mdb driver.

It looks like you are using the 32-bit ODBC DSN (I think that's right for Access driver, maybe try x64 to be sure?) but you may want to make sure that the DSN name matches the one specified in your Universe connection.

Former Member
0 Kudos

Thank you, Michael.

I  used .accdb driver and 32bit odbc dsn(from syswow64 dir) on my local computer. I used IDT to create a Universe and published to repository on BI Platform Server( no .accdb driver on that server).

I tried to create universe based on Excel also, because there is odbc driver on the server, and I also use odbc32.exe to add dsn on server(using the same dsn name and selected the excel file on server as data source), but still error.

How can I try 64bit ODBC? I just find SQL Server driver there, I can't find .accdb driver.

Former Member
0 Kudos

Thank you.

I tried it on my computer before, but I couldn't install 64bit driver because there was already 32bit driver.

Today I tried it on the server. It works.

Thanks a lot!

Answers (1)

Answers (1)

former_member193885
Contributor
0 Kudos

Can you access the Universe from WebI (BI launch Pad)?

Former Member
0 Kudos

Thank you Deepu Sasidharan.

I can access the Universe, can put the fields to do query design, but can't execute the query. The error is odbc data  source error I posted below.