cancel
Showing results for 
Search instead for 
Did you mean: 

Encountered errors while importing .xlsx file on SAP Predictive Analytics 2.5

Former Member
0 Kudos

While using "Define New Data Manipulation" to import .xlsx file as table for further analytics, I selected "Excel Files" as database source and when clicking Browse button for the Table parameter, a prompt box came up and displayed the following message:

"2016-05-23 11:49:28  Error Message from ODBC: Connection failed: [IM014][Microsoft][ODBC Driver Manager] The specified DSN contains an architecture mismatch between the Driver and Application."

I've re-checked the configuration of "Excel Files" in ODBC Data Source Administrator and confirmed that the .xlsx file is selected as workbook of the data source. Can anyone help clarify the cause of encountering such problem and the solution for this?

Accepted Solutions (1)

Accepted Solutions (1)

achab
Product and Topic Expert
Product and Topic Expert
0 Kudos

Hello,

I suspect the root cause is the following:

1. A 64-bit application can only use 64-bit ODBC drivers

2. A 32-bit application can only use 32-bit ODBC drivers

3. Windows has a very old bug that brings more confusion : the ODBC Administrator (and therefore Automated Analytics as it uses the same API as the ODBC administrator) displays the DSNs using 32-bit drivers as well as the 64-bit ones.

Please refer to our Knowledge Base Article here: https://launchpad.support.sap.com/#/notes/2254951

Data Manager cannot be used on Excel files, it's dedicated to databases and generates SQL code that gets executed by the underlying database.

If you need to use the data sitting in Excel, you  can use the Data Transfer feature to transfer the content of your Excel file to a real database.

Once the data will be in a table, there will be no issue using Data Manager.

Thanks & regards

Antoine

Older SCN discussions that might be of interest:

How to connect InfiniteInsight Explorer to MS E... | SCN

ODBC Issues with SAP Predictive Analytics 2.0 -... | SCN

Answers (1)

Answers (1)

marc_daniau
Advisor
Advisor
0 Kudos

Data Manager works on SQL databases, not Excel. If you load the Excal file into a database table you will be able to define Data Manipulations against that table.