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"


Can anybody help what I am missing here ?

I am using trial version 1.31.4 Build 133. Screenshot attached


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:

    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:

    Add comment
    10|10000 characters needed characters exceeded