DesignCreate a Database Data Source

To create a Database data source, a DesignerClosed Person who creates and designs label templates, forms, and applications for use by Data Providers. should use this procedure.

Before You Begin: A Data Service AdministratorClosed A local administrator who creates and configures data services for use by Designers who configure Database data sources and Alternate data sources. must create the data service with which you intend to associate the Database data source. (If you are a Data Service Administrator, see Configure a JDBC Data Service for more information.)

  1. In Label Design Label Design or Application Design , open an existing label template or form, or create a new label template or form.
  2. In the View tab, click Data Sources.
  3. Click Database, and click Add Data Source. The Database Data Source dialog box is displayed.
  4. In the General Data box, enter a Name by which to refer to this label data source.

    Note: The name of a label data source can include letters and numbers. Additionally, the following characters are permitted but cannot begin or end the name: double quotation marks, single quotation marks, grave accents, hyphens, underscores, and periods.

  5. If you want to specify where in the data map the database search result should go, enter text in the Data Ref field. Otherwise, you can leave this field blank.
  6. In the Data Service box, select the data service to use, and then click OK.
  7. Edit the data service configuration. Depending on how the data service is configured, you may be able to edit some of the configuration information or data service parameters that were provided by the Data Service Administrator.
    1. If text boxes are displayed, you can enter either static values or data refs using the format ${<DataRef>}. After you begin typing in the field, a message may be displayed about the type of data required until you finish entering a value or data ref. For information about default parameters, see Configuration Parameters for JDBC Data Services.
    2. If a Result Map option is displayed, you can configure which columns are displayed to a Data ProviderClosed Person or process that enters data into a form or other data entry view for a label that was configured by a Designer. A user acting as a Data Provider requires the DOCUMENT_PRINTER role or equivalent permissions.. For more information, see Configuration Parameters for JDBC Data Services.
    3. If you want the Data Source Results dialog box to display so the Data Provider must manually click a row to select it, leave both Auto Select First Row or Auto Select Single Row check boxes clear.
    4. If you want to automatically insert data into the form from the first row returned by the SQL Query, select the Auto Select First Row check box. If this option is selected, the Data Source Results dialog box is not displayed.
    5. If a single row is returned by the SQL query and you want to automatically insert the data into the form, select the Auto Select Single Row check box. If this option is selected, the Data Source Results dialog box is not displayed.

      Note: If you select this option, it is recommended that you include at least one Prompt field in the Form that is populated by the results to provide confirmation to the Data Provider that the query was executed.

    6. When you have finished configuring the data service parameters, click OK.
  1. In the Data Sources box, the Database section now lists the Database data source that you created. You can continue with any of the following:
    • Drag the data source onto a field in the Label view such as a Variable Text field to assign the data source as the data ref for that field, or enter a data ref manually. For more information, see Use a Data Source to Fill a Field.
    • Create a formula and select the data refs for the data source for use in the formula.
    • Configure a control to run the data source. For more information, see Configure a Control to Run a Data Source.