xMII query against a SAP NetWeaver database
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.
Ill appreciate any advice on this problem!
Joe Montagna replied
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.