CQ5 / AEM Integration with MySQL database system | Community
Skip to main content
October 16, 2015
Solved

CQ5 / AEM Integration with MySQL database system

  • October 16, 2015
  • 2 replies
  • 1331 views

Hi,

I wondered if there is a plug-in type technology (similar to InDesign Plug-Ins) available with AEM / CQ5 that enables another database to have a dynamic link developed that integrates the CQ5 dynamic web page editor with that other database?

Or, do these dev tools provide what's required: Adobe Experience Manager 5.6.1 version of Development Tools (for: AEM 5.6  CQ 5.5  CQ 5.4  CQ 5.3)

Thanks,

Mike

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

When using a relational database and AEM, you have a few choices. 

Out of the box - you use a DataSourcePool to connect AEM with a relational database such as MySQL. See:

Connecting to SQL Databases (this is the AEM doc topic)

Injecting a DataSourcePool Service into an Adobe Experience Manager OSGi bundle (this is an end to end article that walks you through how to inject a DataSourcePool into an OSGi bundle and get MySQL data into a CQ web page). 

If you do not want to use a DataSourcePool - you can write you own Java connection class using Java JDBC APIs. See the community article for more information:

http://helpx.adobe.com/adobe-cq/using/querying-persisting-cq-data-mysql.html

Hope this helps

2 replies

smacdonald2008
smacdonald2008Accepted solution
New Participant
October 16, 2015

When using a relational database and AEM, you have a few choices. 

Out of the box - you use a DataSourcePool to connect AEM with a relational database such as MySQL. See:

Connecting to SQL Databases (this is the AEM doc topic)

Injecting a DataSourcePool Service into an Adobe Experience Manager OSGi bundle (this is an end to end article that walks you through how to inject a DataSourcePool into an OSGi bundle and get MySQL data into a CQ web page). 

If you do not want to use a DataSourcePool - you can write you own Java connection class using Java JDBC APIs. See the community article for more information:

http://helpx.adobe.com/adobe-cq/using/querying-persisting-cq-data-mysql.html

Hope this helps

October 16, 2015

Many thanks for the help. Off to check all that out :-)

Mike