How do I connect single CQ5 with multiple database like cert, dev databases? | Community
Skip to main content
DEBAL_DAS
October 16, 2015
Solved

How do I connect single CQ5 with multiple database like cert, dev databases?

  • October 16, 2015
  • 3 replies
  • 757 views

Hi,

Please explain the procedure to connect single CQ5 author instance with multiple databases.

Thanks & Regards,

Debal

This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.
Best answer by smacdonald2008

Configure Multiple DataSourcePool objects - each one pointing to a different database. You can use app logic to use each one:

if (A)

 USE DataSourcePoolA

else if (B)

 USE DataSourcePoolB

else if (C)

  USE DataSourcePoolC

To learn how to use a DataSourcePool and configure it with AEM -- see:

http://helpx.adobe.com/experience-manager/using/datasourcepool.html

3 replies

smacdonald2008
October 16, 2015
Configure each one to reference a different database. Configure multiple entries.      
smacdonald2008
smacdonald2008Accepted solution
October 16, 2015

Configure Multiple DataSourcePool objects - each one pointing to a different database. You can use app logic to use each one:

if (A)

 USE DataSourcePoolA

else if (B)

 USE DataSourcePoolB

else if (C)

  USE DataSourcePoolC

To learn how to use a DataSourcePool and configure it with AEM -- see:

http://helpx.adobe.com/experience-manager/using/datasourcepool.html

DEBAL_DAS
DEBAL_DASAuthor
October 16, 2015

While configuring the DataSourcePool connection , we are using JDBC Connections Pool service,and we are providing the datasource name in 'DataSourceName' field.

If we try make connection with multiple datasources, how can we manage it. 

 

Thanks & Regards,

Debal