Page Comparison

...

Click Configure > LAYOUTS > Advanced Database.
Click Create Advanced Database Layout.
On the Create Layout screen, select the Layout Builder option from the drop-down list of Select Layout UI Type field.

Click Next. The Create New Advanced Database screen is displayed.

Type the name and description of the new layout activity in the Name and Description text boxes.

Info
Name: Only alphanumeric and underscore are allowed and you must start the layout name with an alphabet or underscore. Description: Only alphanumeric and few special characters (_ - . : , @ $ ? \\ and space) are allowed and you must start the description with an Alphabet/Underscore/Number.

Select the definition mode for the Advanced Database Layout. You can define the layout in the following ways:

Import Definition file

Use Database Table

Using Import Definition File

Select Import Definition File.
Select the type of file from the Definition File drop down list. The available option is JSONJSON in the Definition File field.
Browse and upload the data JSON file in in the Upload Data File field.
Select the project from the Project drop-down list field.
Click Continue.

Using Use Database Table

Select Use Database Table.
Select the database info activity from the Database Info drop-down list field.
Select the project from the Project drop-down list field.
Click Continue.
On the Record Definition page, select the Database Schema from the drop-down list in the Database Schema field, select a database Schema to create the first record.
Info
When you select the Database Schema, all the database tables associated with the selected schema are populated in the drop-down list of the Database Table field.
Select the required Database Table from the drop-down list. Based on the selected Database Table, column details Column Details will be displayed.
In the column details Column Details, select the column(s) that you want to include in Select Query by selecting the checkboxquery statement.
Info
You can also select
the
the Primary Key
checkbox
checkbox to include column(s) in Select
Query
query.
Info
You can also enter the Query in the Query Editor manually.
Based on the selected column(s), Select Query will be displayed in the Query Editor. You As you select a column, the Select query statement is automatically defined in the Query Editor field. You can also manually define an altogether new or update an existing Select query statement in this field. You can edit the query and add the where clause with dynamic parameters as shown in the screenshot below screenshot.
Image Removed
Placeholders will be shown for . For all the added dynamic parameters , where a new field called Placeholders is added to the screen – here you can enter the values of placeholders which is used to generate for the dynamic parameters that are used for generating the XSD for this schemalayout.

Image Added

Click Save to add this record on main view.
The Record Definition page displays the details of created records and Records Hierarchy.
Screenshot

Info

On Record Definition windowscreen, you can click
1. Click Image Modified to edit
and click
1. a record.
2. Click Image Modified to remove a record.
On Records Hierarchy window, You can The database table you selected in the previous step gets listed under the Records Hierarchy panel. You can also click Image Modified to add a root table.
Image Modified
Records Hierarchy displays selected Database table name. You can hover over the table name select a table under the Record Hierarchy panel and click Image Modified to add a child table and click Image Removed to view the data in the tableto it.

In the Definition panel,
Select the Project from the drop-down list of Project.
1. Expand the Advanced Properties

to view the advanced properties of the layout

1. .
2. Define the Character-set encoding for your Database layout in the Character Set Encoding field. For example UTF-8.
3. Select the Schema Version checkbox.
4. Select the Filter Invalid XML Characters checkbox to filter out invalid XML characters (if any) in the input data
  Info
  In case, the input data contains some characters that are invalid in XML, then this may result in the mapping getting aborted.
5. Select the Query Batch Update checkbox to enable the query batch update, and enter the batch size in the Query Batch Size field.
  Info
  Enabling the Query Batch Update checkbox leads to database updation in batches as per the positive value set in the Query

1. Batch Size field.
  For example, setting a value '10' in the Query

Batch Size field will group 10 separate statements and submit them as a single batch. However setting the value to '0' will disable the batch execution and execution of every statement will occur simultaneously.

You can achieve performance optimization by using batch update. The advantage of batch update is to reduce the network calls to the database by not executing every single SQL query when they are raised. By using this feature, you can send multiple queries to the database in a single instant and thereby reducing the number of JDBC calls and improving performance.

This feature is available for the Insert and Update operation only.

Select the Use Commit Count checkbox to enable the Commit Count field, and enter the number of statements that you want to commit to the database in a single instance in a field.

Info
When you set the commit count value to a positive integer value then the layout starts and commits a batch of transaction as per the number in the Commit Count text box. This helps in reducing the network traffic and in turn increases network performance. This is called as batch transaction.

Select the Handle Null/Empty Element(s) checkbox to handle Null or Empty elements.

Click Save Layout to save Advanced Database Layout.

...

Versions Compared

Old Version 48

New Version 49

Key