Search

JDBC Connector Guide

JDBC Connector Guide

Back Next

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: https://www.youtube.com/watch?v=XouJ5OjDAuY 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

JDBC Connections

Watch

Comments

Cloud Application Integration Homepage

0 COMMENTS

We’d like to hear from you! Log in to comment.