TABLE OF CONTENTS


Introduction to Database subscriber

Database subscriber provides a way for users to subscribe to data from a remote database. It provides you with a predefined form where you can set up your query with search criteria, selected fields, and relations. Alternatively, it also provides you with flexibility in querying your data using the raw queries option.


Using Database subscriber

Predefined form



  1. Create a new incoming configuration.

  2. Select Database subscriber.

  3. Leave the Use raw queries option unchecked.

  4. Select the database client.

  5. Fill in the Table name.

  6. Optionally, you can set up the search criteria below.

    1. Where (all the conditions are evaluated in AND operators)

    2. Limit

    3. Skip

    4. Order

    5. Search criteria transformer, provides a way to allow users to load any data to be used in the search criteria. The transformer is executed before the query is executed in the remote database.

  7. You can also set up the fields to be returned from the query by adding them up in the Fields field.

  8. Additionally, you can add a relation to be involved in the generated query by setting them up in the ForeignKeys field.

  9. You can optionally enable logging, i.e., for debugging purposes.


Raw query


  1. Create a new incoming configuration.

  2. Select Database subscriber.

  3. Tick the Use raw queries option.

  4. Select the database client.

  5. Fill in the Query field with your own query (only support SELECT statement).

  6. If you need dynamic data in your query, you can use the Input transformer, which provides a way to allow users to load any data to be used in the Query field. The transformer is executed before the query is executed in the remote database.

  7. You can optionally enable logging, i.e., for debugging purposes.