Data ServicesConfigure a JDBC Update Data Service

To configure a JDBC Update data service so that administrators can save changes to a database, 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. should use this procedure. You can use a Data Service business rule in conjunction with a JDBC Update data service, but one cannot create data sources in Label Design Label Design associated with this type of data service.

Before You Begin: Instead of specifying a connection URL and credentials in each JDBC Update data service, you can configure a Link data service to centrally manage those parameters. This is particularly useful if multiple JDBC Update data services will use the same connection URL and credentials, or if label templates are frequently moved from one Loftware Application Server to another that requires different credentials to access a database. As a best practice, it is recommended that you configure the Link data service first. For more information, see Configure a Link Data Service.

Important! Java Database Connectivity (JDBC) API drivers for Oracle 19c, PostgreSQL 14.4 to 15 for Linux, and PostgreSQL 14.4 to 15 for Windows Server, are installed with Loftware Enterprise SP. To enable Loftware Enterprise SP to connect to another type of database, you must install a third-party JDBC API driver on the computer where Loftware Enterprise SP is installed. For more information, see Add a JDBC Driver.

Note: You do not have to stop a data service to make changes to its configuration or for those changes to take effect, but you must save your changes.

  1. In Data Services Data Services, in the ribbon click > JDBC Update Data Service.
  2. If the connection URL and credentials will be provided via a Link data service, in the General panel select Is Data Link
  3. Configure each parameter of the data service, entering a value or a data ref. Changes made to the parameter in the JDBC Update data service are propagated to the corresponding Data Service business rule component. For more about each parameter, see Configuration Parameters for JDBC Update Data Services.
  4. For the JDBC Update Results, enter a name by which to refer to the data returned by the JDBC Update data service.
  5. To add a custom parameter, click Add Parameter.

    ClosedMore about adding a parameter

    1. In the Add Parameter dialog box, enter a Variable Name for the parameter. When the parameter is displayed to administrators, this name identifies the parameter.
    2. Select a Data Type for the parameter.

      Note: The maximum length for a string is 4,000 characters.

    3. Click OK. The parameter is displayed in the data service.
    4. Enter a value or a data ref to associate with the parameter. For a data ref, use the format ${<DataRef>}. If you enter a data ref, label templates that contain a Database data source associated with this data service must include a data source with that data ref.

    Note: To remove the parameter, click the Delete button next to it.

  6. Optionally enter a Description.
  7. In the ribbon, click Save Save.

    The following characters are permitted in the name: letters, numbers, parentheses, square brackets, ampersands, plus signs, commas, semi-colons, and tildes. Additionally, the following characters are permitted but cannot begin or end the name: spaces, double quotation marks, single quotation marks, hyphens, underscores, periods, and grave accents. For letters, the case that you specify is displayed, but case is ignored when Loftware Enterprise SP interprets a name. If you will be installing the Loftware Enterprise SP application on a computer running Windows Server, and transferring data between Loftware Enterprise SP instances, see the "Transferring Data in a Compressed File" section of the Loftware Enterprise SP Data Transfer Guide.

    Important! Provide a Display Name that is easily recognizable to Designers. When a DesignerClosed Person who creates and designs label templates, forms, and applications for use by Data Providers. creates a Database data sourceClosed A connection to a database that acts as a data source and can serve as the data ref for a document field. A Database data source is associated with a Database data service., the Display Name (but not the Description) is displayed. Data service names are case sensitive.

  8. If the data service has not been started, click Start Data Service.
  9. In the ribbon, click Save Save.

The data service is updated with the connection information. You can view the status of the data service in the Properties pane. If the data service is stopped, you must start it to make the results available when printing labels.

Important! An administrator must create a Data Service business rule component to be used in conjunction with this data service. You cannot create data sources in Label Design Label Design associated with a JDBC Update data service. For more information, see dataService Business Rule Component.

Important! Whenever you add a new device, data service, integration, or facility, you must ensure that the service is activated on all Loftware Application Servers on which it should be available to run and started on at least one. In an environment with only one Loftware Application Server, these types of services are automatically activated and started when they are created. For more information, see High Availability with Distributed Services.

Note: If you want to delete a data service, you must stop it before you can delete it.