Skip to Content
0

Issue - New Dataset with SAP MII

Jun 06, 2017 at 07:56 PM

23

avatar image

Hello Everyone,

I am trying to create a new dataset to connect with SAP MII using natively provided SAP Manufacturing Integration and Intelligence-JDBC drivers but getting error after selecting dataset name on selection of Preview Button

Error : Error retrieving result set. Incorrect SQL statement

I tried with these syntax but no help :

select * from Nikhil.sql_name

select * from "Nikhil"."sql_name"

SELECT * from NIKHIL.SQL_NAME

Can anybody help what I am missing here ?

I am using trial version 1.31.4 Build 133. Screenshot attached

lumira-mii-error.jpg


Thank you.

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

1 Answer

Ludek Uher
Jul 27, 2017 at 07:41 PM
0

Please see the Lumira PAM for supported datasource connections:

https://support.sap.com/content/dam/library/ssp/infopages/pam-essentials/TIP/SAP%20Lumira/SAPLD_PAM.pdf

If it is not there, it is not supported.

- Ludek Senior Support Engineer AGS Product Support, Global Support Center Canada

SAP is now offering chat support. For more details please see KBA 2213344 - How to start a chat with SAP Support[video]

Follow me on Twitter: https://twitter.com/crnanalysistips

Share
10 |10000 characters needed characters left characters exceeded