JDBC Connector Guide

JDBC Connector Guide

Basic Connection Properties

Basic Connection Properties

The following table describes the basic properties that you can configure on the
Properties
tab of the connection creation page:
Property
Description
Name
Required. A unique name for the JDBC connection that identifies it in the Process Designer. The name must start with an alphabet and can contain only alphabets, numbers, or hyphens (-).
Location
Optional. The location of the project or folder where you want to save the connection. Click
Browse
to select a location.
If the
Explore
page is currently active and a project or folder is selected, the default location for the connection is the selected project or folder. Otherwise, the default location is the location of the most recently saved asset.
Description
Optional. A description of the connection.
Type
Required. The type of connection that you want to create.
Select
JDBC Generic Cloud Adapter
.
Run On
Required. The Secure Agent group or the Secure Agent machine where the connection must run.
Connection Test
Displays the result of the last connection test.
OData-Enabled
Optional. Specifies whether OData feeds are enabled for the connection.
Select
Yes
to enable OData feeds. If you select
Yes
, you must specify either the allowed users or the allowed groups that can access the connection at design time. You can also enable or disable Cloud access to the OData endpoint URLs.
Default is
No
.
For more information about the OData endpoint URLs, see Endpoint URLs for OData-Enabled Connections.
OData Cloud Access Enabled
Optional. Specifies whether you can access data from the OData service by using the Cloud endpoint URLs or the Secure Agent endpoint URLs.
If you enable OData and configure the connection to run on a Secure Agent machine or a Secure Agent group, you can choose to disable access to the Cloud endpoint URLs for security purposes.
Select
No
to disable access to the Cloud endpoint URLs. If you select
No
, you cannot access data from the OData service by using the Cloud endpoint URLs. You can access data only by using the Secure Agent endpoint URLs.
The following video shows you how to disable access to Cloud endpoint URLs for security purposes in OData-enabled JDBC connections:
Select
Yes
to access data from the OData service by using both the Cloud endpoint URLs and the Secure Agent endpoint URLs.
Default is
Yes
.
If you set the
OData-Enabled
option to
No
, the value that you set for the
OData Cloud Access Enabled
option does not apply because Application Integration does not generate the OData endpoint URLs.
For more information about the OData endpoint URLs, see Endpoint URLs for OData-Enabled Connections.
Allowed Users for OData
Optional. The users that have access to the connection at design time.
You can specify more than one user. After you specify the first value, press the Enter key or the Comma key, and then specify the next value.
Allowed Groups for OData
Optional. The user groups that have access to the connection at design time.
You can specify more than one user group. After you specify the first value, press the Enter key or the Comma key, and then specify the next value.
After you configure the basic properties, you must also define the following properties:
  • The properties applicable to the JDBC connection type
  • The read and write attributes for the JDBC connection