xMII query against a SAP NetWeaver database

[Former Member]

Hi all,

I have set up a data server for a SAP NetWeaver MSSQL database (DX1 on SAPSRV03) for SAP Web AS 6.40. The status of this data source shows OK. I try to create a new query template. In the SQL Query details, I can see the list of the tables and the list of the columns from a selected table. However, the test result always shows an error: “A SQL Error has occurred on query, [SAPSRV03\DX1]Invalid object name 'TMP_PRD_LINES'” It does not work for any table from that database, so it seems that the error has nothing to do with the table name.

If I change the database name of that data server to something else, like pubs or Northwind, on the same SQL server, the query works well with any table.

I wonder whether there is any special parameters that I need to set up so that I can query against a NetWeaver database.

I’ll appreciate any advice on this problem!

Best regards,

Hart

[Former Member · Accepted solution]

Hart,

We are able to query a Netweaver DB, but we needed to include a schema.

Your query to the TMP_PRD_LINES table should look like the following:

Select * from SAPDX1DB.TMP_PRD_LINES

Working with you through support I know that this worked for you - I am just wanted to post the answer for everyone to see.

Thanks,

Joe