xAPPnow LOW CODE PLATFORM - User Manual 

Still no account yet?
×

Service Model - Database Connector Configuration

 
 
 
This topic describes the Configuration of a Database Connector, which is available in a Sub TAB of the Implementation TAB.
 
The following properties are available for this element:
 
  • Connection Object: the data source of the database, containing all required information for connection, e.g. port, db name or URL.
  • Error Object: the object where the error is saved in case an error is thrown
  • Query Type: the query the database connector should execute
  • Query Object: the object containing variables needed for a the query
  • View Object (List): the view object or list of view objects the connector work with
  • Page Index: the variable specifying the index of the next retrieved db page
  • Page Rows: the variable describing the number of page rows to be retrieved
  • View Objects Filter: contains the view object used for filtering
  • Return as output: this option allows to return the data on the view object after Create or Update functions
 
The DB Connector allows to connect to any external database. The Configuration TAB provides the configuration of the DB connection, specified in the connection object, as well as the configuration of the DB Query itself.
 
Depending on the selected Query Type, different properties are available. The detailed configuration is explained in the Query Types.
 
 
Service Model - Database Connector Configuration
 
 
 
1

Select Query Type

1. Select Query Type
Select the query type. The query can be Read, Create, Update or Delete with different options.
2

Map Query Object

2. Map Query Object
This field is needed to use filtering and attributes of this object can be used in the Filter & Ordering Sub TAB, which is automatically displayed next to Configuration subtab if this field is present. See Filter & Ordering.
3

Map Result List

3. Map Result List
This field is for mapping the view object list. Depending of the query type, either the result is saved here or the view objects used for the query.
4

Map Index and Rows

4. Map Index and Rows
These fields are optional and only available for the query Read Multiple Objects. These fields can be mapped with integer values to defined the page index or the quantity for rows.
5

Map Connection

5. Map Connection
From the Definition Objects drag and drop a previously created connection object.
6

Map Error object

6. Map Error object
All connectors have a standard flow for a successful operation and an error flow in case an error happens. The error code is defined in a Definition Object Model as ErrorDB and then must be an Error Business Object must be created on Business Object Model.