use tables from other schema than DBO

use tables from other schema than DBO


Isn't it possible to use tables in a other schema? I would like to use a table in a schema "abc", but I only see tables from the "dbo" schema.

How can i use this table? I'am using a dataconnector (Microsoft SQL Server Direct Connect).

Kind regards,

Matthias Preuer
Hi Matthias,

Did you checked if the platform runtime user have access to that specific schema?


Yes, i did.

I have a workaround:
  • first use a Linked server to import the entity 
  • then change the logical database to the Dataconnector
Kind regards,
Matthias Preuter

This doesn't work, i can't compile the extension