ODBC Issues with SAP Predictive Analytics 2.0 - Automated Analysis

[Former Member]

Dear all,

maybe this adds only an aspect to the Infinite Insight OCBC Connection difficulties discussed in

http://scn.sap.com/message/15766247#15766247

but after trying and searching the web for more than a day any help would be appreciated.

This is the situation:

I'm using SAP PA 2.0 Desktop version and would like to upload a flatfile (*csv) to the Data Manager of Automated Analysis. Unfortunately, none of the solutions found by now worked.

It is a SAP PA 2.0 64bit version installed on a Windows 7.0 64 bit P. The installed MS Office version is 32bit as all available drivers. Deinstalling MS Office and reinstalling a 64bit version is not an option. It is not possible to install SAP PA 2.0 32bit version either - the Installation process stops due to the wrong operations system.

The DSN configuration suggested in the SCN discussion mentioned above didn't work, although displayed as data source in the Data Manager data base/file selection Screen. The error message returned is a Microsoft ODBC error [IM014] indicating that for the DSN used, there is an architecture mismatch between driver and application,

The attachments shows screenshots of the error message and the situation in the ODBC adminitrator consoles both for 32bit and for 64bit (in system32 and SysWOW64 shares).

Is there a solution to this problem?

Kind regards

Elisabeth

[Former Member]

Hi Pierpaolo,

thanks for the explanation. Meanwhile I succeeded analyzing files

Elisabeth

[achab]

Hi Elisabeth,

Could you please be so kind to flag the question as Answered?

Thanks & regards

Antoine

[Former Member]

Hi Elisabeth,

If I understand correcty, you would like to upload your csv file to a database.
What kind of database is it ?

The Automated part of Predictive Analytics supports the following databases:

• SAP HANA
• Sybase IQ
• Oracle
• Hive
• Teradata
• Microsoft SQL Server
• MySQL 5
• Netezza
• IBM DB2
• PostgreSQL
• Vertica
• Greenplum

Your screensot shows ODBC connections to Excel and Text files. It is is not real databases, it cannot execute SQL code.

For more information on configuring a database connection on your machine, you can refer to this document : https://websmp204.sap-ag.de/~sapidb/012002523100001708812015E/pa20_conndb_win_conf_en.pdf

Note that you need a database driver installed on your machine and access to a database (either installed on your machine or on a remote server).

In general, all documentation related to PA2.0 can be found here : SAP Predictive Analytics 2.0 – SAP Help Portal Page.

Hope this helps.

Kind regards,

Armelle

[Former Member]

Hi Armelle,

thanks for your reply. I refer to the Automated Analytics User Guide, Vol. "Classification, Regression, Segmentation and Clustering Scenarios". On p12 it is clearly stated (Phase 1, Data Access):

"Automated Analytics acceppts many types of data sources:

- "Flat files" such as .csv files, files of text tables and other files of type text.

- ODBC-compatible sources such as Oracle, SQL Server or IBM DB2 databases."

After reading this description, I would expect the application to be able to upload simple flatfiles without too many difficulties.

Kind regards

Elisabeth

[PPaolo]

Hello Elisabeth,

the information in the guide is correct. You can perform classification, regression, etc. on flat files and you can do that without going through the data manager.

To use a flat file in Classification/Regression e.g. you go to [Modeler][Create a Classification/Regression model ] and in the choice of sources data type you will find the text file and Excel types. You can upload the file directly from there.

Data Manager is used to do complex manipulations of data (e.g. creating timestamped populations) and it requires a real database in the background (problem is that the UI shows all ODBC connections hence even the Excel ones which are not supposed to work).

If you really need to do complex manipulations on your dataset based on Excel then you should upload it into a real database and you can use the [Toolkit][Perform data transfer]  workflow.

Hope that it helps

Regards

PPaolo