Connecting to remote Database
When using DirectQuery, Atoti delegates various queries to the remote database. In order to do that it requires a connection to this database and the permissions to access the data and run these queries.
This section describes various methods and best practices to connect to a remote database when using it in DirectQuery.