Design

Back Next

Testing the data access service connector

When you use the data access service connector editor, click

Test

to send a request to the database and display the response data on the

Test Results

tab:

Generate Process Objects
: Click to see the process objects that you have defined for the data access service connector.

Result:
Displays the status of the test.

Sometimes, a request made to the Databricks database might display a timeout error due to system latency or slow execution. Increase the value in the

Max Wait (ms)

field to avoid the request timeout.

Output
and Value
: Shows the data returned from the database that is assigned to the fields defined on the

Output

tab.

Response Payload
: Shows the payload sent to Process Designer from the database (not the full response sent by the database).

SQL Request
: Shows the data sent to the database from the data access service connector. The tab displays a list of SQL names on the left pane and the corresponding data on the right pane.

SQL Response
: Shows all of the data sent back to the data access service connector from the database (whereas the response payload is only a portion of the returned data). The tab displays a list of SQL names on the left pane and the corresponding data on the right pane.

The SQL Response
section displays hexadecimal values for the characters that are not allowed in XML.

If the response includes one or more attachments, you can also download the attachments.

The

Response Payload

and

SQL Response

sections show a maximum of 10,000 records. You can't specify a limit greater than 10,000 on the

SQL Binding

tab.

The following image shows the

Test Results

tab:

Generate Process Objects

A process object is usually tied to a specific set of elements. You may sometimes have a large number of identical objects, each of which applies to one set of elements. For example, when you define the data being returned, you create a process object whose sole purpose is to define a subset of returned data. These objects are non-reusable
and can only be used by a single process object field. The object names are also the name of a field.

You can also create objects that are reusable
. For example, the refType element in NetSuite has two fields: a name and an internalID. Instead of creating many objects, each of which contains these two fields, you can create a single, reusable process object.

Click

Generate Process Objects

to show the process objects that you have defined for the data access service connector.

Select the process objects that you want to make reusable and then click

Process Designer displays a list of generated process objects.

Click

Finish

Creating a Data Access Service Connector

Metadata parameters in response payload

OData expand parameter in response payload

Download Guide

Watch