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

    Back To Top