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

Install and Configure the ODBC Driver

You must install and configure a driver on every workstation that will be used to connect to the Vantagepoint database.

The user who installs the ODBC drivers must, at a minimum, have local administrator privileges.

To install and configure the ODBC driver:

  1. Download the ODBC driver installer from the following link:
    https://dsm.deltek.com/DFVE/ODBC/HDPDriver.zip
  2. Extract all the files in the downloaded ZIP file to a folder on your computer.
  3. Execute either the 32-bit or 64-bit .EXE installer file.
    Execute the file that corresponds to the application from which you will be connecting via ODBC. For example, if the ODBC connection will be made from the 32-bit version of Excel, then use the 32-bit version of the installer (regardless of the architecture of the operating system).
  4. Run the ODBC driver installer; follow the prompts, accepting all of the defaults.
  5. From the ODBC Data Source Administrator dialog box, create either a User DSN or System DSN.
    User DSNs are for a single user; System DSNs are available to all users of the workstation. Select the User DSN or System DSN tab, based on your needs.
  6. Click Add.
  7. On the Create New Data Source dialog box, select DataDirect HDP 4.6 and click Finish.
  8. On the ODBC Cloud Driver Setup dialog box, enter a name in the Data Source field.
    This can be any name that helps you identify the data source. You do not need to add a value in the Description field.
  9. In the Hybrid Data Pipeline Source field, enter the database name and service URL that you received from Deltek Customer Care when you requested the ODBC accounts; leave the Port Number field as is.
    Important: When entering the service URL, do not include the https:// if that was included in the service URL you received. Including the https:// will result in an error when testing the connection.
  10. On the Security tab, make sure that the Enable SSL checkbox is selected.
  11. Click Test Connect, enter the credentials that you received from Deltek Customer Care when you requested the ODBC accounts, and click OK.
  12. Click OK when you see A Connection established!
  13. Click OK on the ODBC Cloud Driver Setup dialog box.
  14. Click OK on the ODBC Data Source Administrator dialog box.