on 05-23-2016 7:17 AM
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?
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:
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
86 | |
23 | |
11 | |
9 | |
8 | |
5 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.