ODBC Environment Permissions

Depending on the Cloud level offerings that you have implemented, you are granted corresponding ODBC permissions to specific environments.

Cloud Level / Environment ODBC Access Allowed ODBC Accounts Allowed ODBC Permissions
Basic (Only with VI)
Production Yes 5 Read
Sandbox No 0 None
Preview Yes 1 Read
Flex
Production Yes 5 Read
Sandbox No 0 None
Preview Yes 1 Read
Enterprise
Production Yes 5 Read / Write
Sandbox No 0 None
Development Yes 1 Read / Write / Execute
Test No 0 None
Preview Yes 1 Read / Write
Note: The ODBC service is configured to limit the size of data responses to 50,000,000 rows. While this restriction might impact the volume of data retrieved in a single query, it significantly contributes to the overall efficiency and responsiveness of our service. This balance strikes the best compromise between delivering rapid data access and maintaining optimal performance. This limit is subject to review and change.

Deltek recommends forming queries into manageable response volumes that work within this limit and to ensure that only changed data is retrieved when appropriate versus pulling all data with each retrieval.