Cloud Administrator's Help System

Using the Help Search
Using the Help Search
  • Phrase:Returns all topics that contain the exact phrase in the search criteria. Use quotation marks around the phrase.
    Ex."system administration"
  • And:Returns all topics that contain all the words in the search criteria, in any combination. Insert a plus sign between all words in the search criteria.
    Ex.system + administration
  • Or:Returns all topics with any combination of words in the search criteria. This is the default.
    Ex.system administration
For more information:Searching Online Help

Create ODBC Accounts

Before you can use the ODBC connection, you must set up the accounts that you need for ODBC access. You can have up to five active ODBC accounts in your production database.

ODBC Access for Vantagepoint Preview Databases

One ODBC account is supported in the Preview databases. Preview databases are previews of the next major release of the software and are provided for purposes of testing integrations and features in the next version. See the Cloud Levels help topic for preview database eligibility.

Customers are allowed to refresh their preview database from production. In such a scenario, please remember to disable the ODBC user in your preview database before the refresh is requested and processed.

Procedure for Creating ODBC Accounts

Prerequisite: Use Vantagepoint security configuration (Settings > Security > Users) to enable, edit, and disable ODBC accounts.

To enable a user to have ODBC access:

  1. On the Vantagepoint Navigation pane, select Settings > Security > Users and then find the user who needs ODBC access.
  2. In the Cloud ODBC Settings section of the Users form, select the Enable Cloud ODBC Connectivity checkbox and enter the user’s email address.
    Email addresses are used to communicate with the user regarding account setup and information.
    Note: An ODBC Password field is not provided because Deltek manages the password for the ODBC service. If you need to change your ODBC password, contact Deltek Support directly.

    ODBC Username Convention

    Deltek uses the first and last name of the employee that is associated with the User record to generate the ODBC username. The first initial of the first name plus the first 9 letters of the last name will be used. If the User record is not associated with an employee, the ODBC username will incorporate the first 10 characters of the ODBC email address up to the @ symbol.

  3. Click Save.
    You receive two notifications:
    • Immediately, you receive a notice telling you the account was successfully created and that the Deltek Cloud Operations team will complete the configuration within three business days.
    • When the configuration is complete, you receive a notice from Deltek Support Services with your account information.
After you enable cloud ODBC connectivity for a user, the following apply:
  • If you delete a user in Settings > Security > Users, Deltek Cloud Operations will receive a notification to remove the ODBC account.
  • If you select the Disable Login checkbox on the Users form in Settings > Security > Users (so that the user cannot log in to Vantagepoint), this does not disable ODBC access for the user. To disable ODBC access, you must also clear the Enable Cloud ODBC Connectivity checkbox on the Users form or delete the user record completely in Users Settings.