Database Connection in AEM

Hi @prachishingade ,

Adobe Experience Manager (AEM) primarily uses Apache Jackrabbit Oak as its underlying repository, and it's designed to work with a variety of data stores, including both file-based and RDBMS-based repositories. By default, AEM uses a file-based repository for persistence (CRXde). However, for larger deployments or specific use cases, you might consider using an RDBMS (Relational Database Management System) as the persistence layer for AEM.

Here are the general steps to configure AEM to use an RDBMS:

1. Choose a Database: Select an RDBMS that is supported by Adobe Experience Manager. Common choices include Apache Derby, Oracle, Microsoft SQL Server, and PostgreSQL.

2. Configure the DataSource: Configure a DataSource in your application server that AEM will use to connect to the RDBMS. This is typically done in the application server's configuration. You may need to provide connection details such as the database URL, username, and password.

3. Install Database Drivers: Ensure that the necessary JDBC driver for your chosen database is available in the AEM environment. The JDBC driver is needed to establish a connection between AEM and the database.

4. Configure AEM for RDBMS: Modify the AEM configuration to use the configured DataSource. This involves updating the repository configuration to point to the DataSource, usually through the Apache Jackrabbit Oak configuration.

5. Recreate the Repository: Depending on your scenario, you might need to recreate the AEM repository to apply the new configuration. Be cautious with this step, especially in a production environment, as recreating the repository will result in data loss.

6. Testing: After configuring AEM for the RDBMS, thoroughly test the setup to ensure proper functionality and performance. Pay attention to potential issues during the transition.

It's important to note that using an RDBMS introduces additional complexity and considerations. The decision to switch to an RDBMS should be made based on specific requirements and considerations, such as scalability, performance, and maintenance.

Hi @prachishingade 

There are 2 common ways to create a data source (separate OSGI Configs that you can access from the system console (http://localhost:4502/system/console/configMgr) -

• Day Commons Connection pool 
• Apache Sling Connection Pooled data source 

The Apache Sling Connection Pooled data source is the recommended one because how it handles the idle connections.

Here is the documentation for connecting AEM to a database - https://experienceleague.adobe.com/docs/experience-manager-learn/forms/sign-multiple-documents/configure-data-source.html?lang=en

If you are on AEM as a Cloud Service, there would be some additional networking configurations involved as well which are documented here - https://experienceleague.adobe.com/docs/experience-manager-learn/cloud-service/networking/advanced-networking.html?lang=en#advanced-networking

As you can see there are multiple steps involved so you can try these and reach out to the community for any questions.

Thanks

Narendra

@prachishingade Did you find the suggestions from users helpful? Please let us know if more information is required. Otherwise, please mark the answer as correct for posterity. If you have found out solution yourself, please share it with the community.