[IDT] Multi source DB & Excel file

building semantic layer
1

Hi all,
I’m trying to have a universe on

  • a database (MySQL or other)
  • an excel file (stored on the server)

I am able

  • to create a multi source universe between 2 relatationnal database connexion.
  • to create a single source data federator on the excel file then Universe … reports…

But even creating a Multi Source Data federator and only selecting the Excel source (wich is OK, published and secured …) the result is KO : I can’t expand/explore use it.
Error message is : “Owners are not available”.

I 've done plenty of tests, even linking the DB universe to the excel universe, in that case, the query says Driver ODBC Excel Issue like can not find object if I use the object comming from the db universe lol.

Any idea ?
I spent too much time on that issue “Owners are not available” knowing my both connexion are OK separated. Even a universe on 2 differents DB connexion works, but not a DB & Excel !

For info : I’ve tried xls & xlsx, differents version of drivers (odbc, odbc 3, excel 97-2000, 2016 etc.) maybe need to combine more and re test more lol
I also didn’t find the info in the PAM (Product Availability Matrix) or I don’t have the good one.

Thanks a lot to you

Cheers

mathieuBO (BOB member since 2011-01-06)

2

Check is it supported for MSU…some are and some are not.

Nick Daniels :uk: (BOB member since 2002-08-15)

3

Hi Mr Daniels, Thanks for answering.
I spent too much time on this yesterday seeking this PAM, I get lost myself on SAP support portal every time.
Anyway this morning in 10 minutes :slight_smile: here you go :

SAP BI Platform PAM 4.2 (PDF)

SAP BI4.2 Data source PAM :
https://support.sap.com/content/dam/launchpad/en_us/pam/pam-essentials/SBOP_BI_42_Supported_Platforms.zip

Excel is supported on my 64bits platform but doesn’t work :wink:

In my case, I m still stuck in my drivers, I’m gonna seek for XLSX 2016 ODBC…
I attached documents (my config) to this response but don’t know where you can find it, did it worked ?

mathieuBO (BOB member since 2011-01-06)

4

OK,
In my case, I needed to define in the IDT, the connection driver as MS Excel 2010 or 2007.
2013 & 2016 are not allowed > appears grey when trying to add in the data federator.
Open IDT > Connect to referential > Open Connection > Modify driver > MS Excel 2010 > ODBC Driver
ODBC Config :
Local PC (64bits) (for dev) :
SysWow64 > odbcab32.exe > add system data source > Microsoft Excel Driver (xls, xlsx etc.) > Version Excel v12 and select file & data source name
BO Server (64bits)
System32 > odbcab32.exe > add system data source : Microsoft Excel Driver (xls, xlsx etc.) > Version Excel v12 and select file & data source name
Make sure you have Microsoft Access Database Engine 2010 Redistributable 32 bits installed on local machine even if 64 bits ? For server machine I don’t know ether.

mathieuBO (BOB member since 2011-01-06)

5

So you are up and going? Thanks letting us know the details.

Nick Daniels :uk: (BOB member since 2002-08-15)