Configure data sources configure-data-sources

Go to Experience Manager web console at https://server:host/system/console/configMgr.

Locate Day Commons JDBC Connections Pools configuration. Select to open the configuration in edit mode.

In the configuration dialog, specify the details for the database you want to configure, such as:

• Java™ class name for the JDBC driver

• JDBC connection URI

• Username and password to establish connection with the JDBC driver

• Specify a SQL SELECT query in the Validation Query field to validate connections from the pool. The query must return at least one row. Based on your database, specify one of the following:

  • SELECT 1 (MySQL and MS® SQL)
  • SELECT 1 from dual (Oracle)

• Name of the data source

Sample strings for configuring a relational database:

   "datasource.name": "sqldatasourcename-mysql",
   "jdbc.driver.class": "com.mysql.jdbc.Driver",
   "jdbc.connection.uri": "jdbc:mysql://$[env:AEM_PROXY_HOST;default=proxy.tunnel]:30001/sqldatasourcename"

Select Save to save the configuration.

Go to Tools > General > Configuration Browser.

• See the Configuration Browser documentation for more information.

Do the following to enable the global folder for cloud configurations or skip this step to create and configure another folder for cloud service configurations.

1. In the Configuration Browser, select the global folder and select Properties.

2. In the Configuration Properties dialog, enable Cloud Configurations.

3. Select Save & Close to save the configuration and exit the dialog.

In the Configuration Browser, select Create.

In the Create Configuration dialog, specify a title for the folder, and enable Cloud Configurations.

Select Create to create the folder enabled for cloud service configurations.

Go to Tools > Cloud Services > Data Sources. Select to select the folder where you want to create a cloud configuration.

See Configure folder for cloud service configurations for information about creating and configuring a folder for cloud service configurations.

Select Create to open the Create Data Source Configuration wizard. Specify a name and optionally a title for the configuration, select RESTful Service from the Service Type drop-down, optionally browse and select a thumbnail image for the configuration, and select Next.

Specify the following details for the RESTful service:

• Select a URL or File from the Swagger Source drop-down, and accordingly specify the Swagger URL to the Swagger definition file or upload the Swagger file from your local file system.

• Based on the Swagger Source input., the following fields are pre-populated with values:

  • Scheme: The transfer protocols used by the REST API. The number of scheme types that display in the drop-down list depend on the schemes defined in the Swagger source.
  • Host: The domain name or IP address of the host that serves the REST API. It is a mandatory field.
  • Base Path: The URL prefix for all API paths. It is an optional field.
    If necessary, edit the pre-populated values for these fields.

• Select the authentication type — None, OAuth2.0(Authorization Code, Client Credentials), Basic Authentication, API Key, or Custom Authentication — to access the RESTful service, and accordingly provide details for authentication.

If you select API Key as the authentication type, specify the value for the API key. The API key can be sent as a request header or as a query parameter. Select one of these options from the Location drop-down list and specify the name of the header or the query parameter in the Parameter Name field accordingly.

Select Create to create the cloud configuration for the RESTful service.

Go to Tools > Cloud Services > Data Sources. Select to select the folder where you want to create a cloud configuration.

See Configure folder for cloud service configurations for information about creating and configuring a folder for cloud service configurations.

Select Create to open the Create Data Source Configuration wizard. Specify a name and optionally a title for the configuration, select RESTful Service from the Service Type drop-down, optionally browse and select a thumbnail image for the configuration, and select Next.

Specify the following details for the RESTful service:

• Select a URL or File from the Swagger Source drop-down, and accordingly specify the Swagger 3.0 URL to the Swagger definition file or upload the Swagger file from your local file system.
• Based on the Swagger Source input, the connection information with the target server is displayed.
• Select the authentication type — None, OAuth2.0(Authorization Code, Client Credentials), Basic Authentication, API Key, or Custom Authentication — to access the RESTful service, and accordingly provide details for authentication.

If you select API Key as the authentication type, specify the value for the API key. The API key can be sent as a request header or as a query parameter. Select one of these options from the Location drop-down list and specify the name of the header or the query parameter in the Parameter Name field accordingly.

Select Create to create the cloud configuration for the RESTful service.

Select Form Data Model HTTP Client Configuration for REST data source.

In the Form Data Model HTTP Client Configuration for REST data source dialog:

• Specify the maximum number of permitted connections between form data model (FDM) and RESTful web services in the Connection limit in total field. The default value is 20 connections.

• Specify the maximum number of permitted connections for each route in the Connection limit on per route basis field. The default value is two connections.

• Specify the duration, for which a persistent HTTP connection is kept alive, in the Keep alive field. The default value is 15 seconds.

• Specify the duration, for which the Experience Manager Forms server waits for a connection to establish, in the Connection timeout field. The default value is 10 seconds.

• Specify the maximum time period for inactivity between two data packets in the Socket timeout field. The default value is 30 seconds.

Go to Tools > Cloud Services > Data Sources. Select to select the folder where you want to create a cloud configuration.

See Configure folder for cloud service configurations for information about creating and configuring a folder for cloud service configurations.

Select Create to open the Create Data Source Configuration wizard. Specify a name and optionally a title for the configuration, select SOAP Web Service from the Service Type drop-down, optionally browse and select a thumbnail image for the configuration, and select Next.

Specify the following for the SOAP web service:

• WSDL URL for the web service.

• Service Endpoint. Specify a value in this field to override the service endpoint mentioned in WSDL.

• Select the authentication type — None, OAuth2.0(Authorization Code, Client Credentials), Basic Authentication, or Custom Authentication — to access the SOAP service, and accordingly provide the details for authentication.

Select Create to create the cloud configuration for the SOAP web service.

Go to Tools > Cloud Services > Data Sources. Select to select the folder where you want to create a cloud configuration.

See Configure folder for cloud service configurations for information about creating and configuring a folder for cloud service configurations.

Select Create to open the Create Data Source Configuration wizard. Specify a name and optionally a title for the configuration, select OData Service from the Service Type drop-down, optionally browse and select a thumbnail image for the configuration, and select Next.

Specify the following details for the OData service:

• Service Root URL for the OData service to be configured.
• Select the authentication type — None, OAuth2.0(Authorization Code, Client Credentials), Basic Authentication, API Key, or Custom Authentication — to access the OData service, and accordingly provide the details for authentication.

If you select API Key as the authentication type, specify the value for the API key. The API key can be sent as a request header or as a query parameter. Select one of these options from the Location drop-down list and specify the name of the header or the query parameter in the Parameter Name field accordingly.

Select Create to create the cloud configuration for the OData service.