Database Search Groups

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 receive data from one external database table 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(s) 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 it 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.



Send Feedback


Related Topics

Adding external databases for CUSTOMTOOLS use
Database Options of the Properties
Defining Property with help of ERP database
Maintain the selected Database Search Group with help of the Database Search Group editor
Tips for CUSTOMTOOLS usage

Tutorial: Property Linked to Microsoft Excel