Skip to Content

Issue - New Dataset with SAP MII

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.

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Jul 27, 2017 at 07:41 PM

    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

    Add comment
    10|10000 characters needed characters exceeded