Deltek Vantagepoint Help

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

Import ODBC DSN Files

You can import ODBC DSN files from outside sources into Vantagepoint.

Prerequisites: To import ODBC DSN files, you must set up the ODBC driver as the System DSN on the Vantagepoint Application server. The database source must be in a folder that the server has access to, so that you can select it when you set up the System DSN. Your IT staff may be needed for initial setup. Common databases include SQL Server and Access.

To import ODBC DSN files, you may need to enter a valid user ID and password. Only some ODBC DSNs require a user ID and password, depending on the data source for that DSN.

Follow these guidelines:
  • Vantagepoint only supports System DSN; it does not support File DSN.
  • The names of the source fields cannot contain any spaces or punctuation.
  • To import a default value for a standard area of Vantagepoint such as a check box, place the value in single quotation marks in the Expression field.

To import ODBC DSN files:

  1. On the Navigation menu, click Utilities > Utilities > Data Import.
  2. In the Table Description field on the Import Utility form, select a table type.
    By default, this field lists only data entry type tables. However, if you have the proper security access, you can also access other types of tables. To do this, hold down CTRL + SHIFT and click on the screen. Vantagepoint displays a Password dialog box. Enter your valid password and click OK.
  3. In the From field, select ODBC DSN.
  4. In the Input Table Name field, specify the name of the temporary Vantagepoint table that stores the validated or error records before they are imported to the final destination in Vantagepoint.
    Ensure that the table name does not contain a period or other special characters.
  5. Complete the fields on the Main tab.
  6. Complete the fields on the ODBC Fields Mapping tab.
    This tab is available only if you set the From field to ODBC DSN. You can save the settings on this form, so that you can apply them the next time you load a file of the same data type. (You can change the saved settings.)
  7. Click Validate.
    Vantagepoint verifies the source data and inserts both the valid and error records into the temporary table that you specified on the Main tab.
  8. Correct any records that require correction and re-validate them.
  9. Click Import.
    Vantagepoint verifies the source data and inserts the records into the final destination in Vantagepoint.