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.
Parent Topic: Set Up Direct Database Access