FluentPro Help Center

What do you need help with?

SQL Datasource

Lookup Manager can pick up data from an SQL Server Database.

Please note: All edited values in source will be added as new values.

To configure this mode:

  1. Click New Item from the ribbon.
  2. Select SQL data source item in:
    Project Server 2010.
    In Project Server 2013.
  3. Type a name of this item.
  4. Type a name of a lookup table that needs to be synchronized.
  5. Type an SQL Server name.
  6. Type a database name Type an sql query to select data
    Note: First column from query will be mapped to Lookup Table value, second to Description.
  7. Type a character used to separate different levels of hierarchy in case hierarchy is present.
  8. Click Save.

Was this article helpful?

Table of contents

    Request an article Export to PDF
    Back To Top