Login to your SQL Server using for example the sa account to establish connection to the external data source.
Property value can be imported from an External data source. The Database Options page of the Property Wizard can be used to connect Properties to item in the external data source.
You can setup connections to your external data sources in the External Data Sources options available in CUSTOMTOOLS Administration Tool.
|
NOTE: Because of the Microsoft SQL Server security policy, the System Administrator role is required in the SQL Server level in order to be allowed to establish connections to the external data sources.
Login to your SQL Server using for example the sa account to establish connection to the external data source. |
| Database search group | Selects the database search group used by the custom property. |
| Database column |
Select the column from the External data soure where the Property value is retrieved.
The Database column box is disabled if the property type is set as Date. |
If you add edit colums available in the data source used in the selected Database Search Group, refresh the columns in the Database Search Group by opening settings of the affected Database Search Group in the CUSTOMTOOLS Database Search Group options. You do not have to make any modifications to the Database Search Group while refreshing the columns list.
| Enable property in search | If selected, the Property can be used as a search criteria to search file in the CUSTOMTOOLS database. |
| Exclude from item search condition | The custom property having this option selected cannot be used as a search criteria to search item in the External datasource.
The Database Item Search is used to search item values in the external datasource and link them with the Properties. |
|
NOTE: Several Properties on the different document type scopes, could be linked to the same database attribute. The Enable property in search option could be in use for only one of the Properties linked to one attribute. |
Other Properties using a button to search item from the same Database search group will be disabled, once other Properties using the same Database search group are field.
Disabling the buttons prevents from overwriting linked properties.
The general controls are included in all pages of the Property Wizard.
| Back | Return to the previous page of the Property Wizard. |
| Next | Proceed to the next page of the Property Wizard. |
| Finish | Save the property and close the Property Wizard. |