Configure data sources configure-data-sources

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

Look for Apache Sling Connection Pooled DataSource 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:

• Name of the data source
• Data source service property that stores the data source name
• Java class name for the JDBC driver
• JDBC connection URI
• Username and password to establish connection with the JDBC driver

Enable Test on Borrow or Test on Return to specify that the objects are validated before being borrowed or returned from and to the pool, respectively.

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)

Select Save to save the configuration.

Go to AEM web console at https://'[server]:[port]'system/console/configMgr.

Look for AEM Forms Data Integrations - User Profile Connector Configuration and select to open the configuration in edit mode.

In the User Profile Connector Configuration dialog, you can add, remove, or update user profile properties. The specified properties are available for use in form data model. Use the following format to specify user profile properties:

name=[property_name_with_location_in_user_profile],type=[property_type]

Examples:

• name=profile/phoneNumber,type=string
• name=profile/empLocation/*/city,type=string

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 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, Custom Authentication, or Mutual 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.

If you select Mutual Authentication as the authentication type, see Certificate-based mutual authentication for RESTful and SOAP web services.

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

Log in to Experience Manager Forms Author Instance as an administrator and go to Experience Manager web console bundles. The default URL is https://localhost:4502/system/console/configMgr.

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 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 2 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, Custom Authentication, X509 Token, or Mutual Authentication — to access the SOAP service, and accordingly provide the details for authentication.

  If you select X509 Token as the Authentication type, configure the X509 certificate. For more information, see Set up certificates.
  Specify the KeyStore alias for the X509 certificate in the Key Alias field. Specify the time, in seconds, until the authentication request remains valid, in the Time To Live field. Optionally, select to sign the message body or timestamp header or both.

  If you select Mutual Authentication as the authentication type, see Certificate-based mutual authentication for RESTful and SOAP web services.

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, or Custom Authentication — to access the OData service, and accordingly provide the details for authentication.

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

Upload the private key (certificate) to AEM Forms server. To upload the private key:

1. Login to your AEM Forms server as an administrator.
2. Navigate to Tools > Security > Users. Select the fd-cloudservice user and select Properties.
3. Open the Keystore tab, expand the Add Private Key from KeyStore file option, upload the KeyStore File, specify the aliases, passwords, and select Submit. The Certificate is uploaded. The private key alias is mentioned in the certificate and set while creating the certificate.

Upload trust certificate to Global Trust Store. To upload the certificate:

1. Navigate to Tools > Security > Trust Store.
2. Expand the Add Certificate from CER file option, select Select Certificate File, upload the certificate, and select Submit.

Configure SOAP or RESTful web services as the data source and select Mutual authentication as the authentication type. If you configure multiple self-signed certificates for fd-cloudservice user, specify the Key Alias name for the certificate.