With Database Search Groups options you can setup a connection to an external database table. Once you have created a link the external database, you can link Property values with the database values.
|
NOTE: You can use one table at the time in one database search group. |
Links between database and the Properties might get broken if the table of the linked database changes while there are one or more links to the Properties.
The Database Search Groups options are located in the CUSTOMTOOLS Profile Options.
Select the desired CUSTOMTOOLS product from the CUSTOMTOOLS Products box to display the further and the product specific instructions to find the Linked Databases options.
| CUSTOMTOOLS Products: |
| Add | Create a new Database Search Group. |
| Edit | Edit the selected Database Search Group. |
| Delete | Remove selected Database Search Group from your CUSTOMTOOLS Profile. |
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.
To open settings of the Database Search Group, select the desired Database Search Group from the Database Search Groups list and then click the Edit button.
|
TIP: You can also double click the desired Database Search Group to open its' settings for editing. |
| Name | Name of the database search group. |
| Server | Host name of the server machine where the source database is located. |
| Catalog (Hidden by default) | Shows name of the database where the data exists. |
| Schema (Hidden by default) | Name of database table set located in the data source. |
| Table | Name of the table located in the source database. |