JDBC Connector Guide > JDBC Connections > 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.
Note: 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: