CQ5 / AEM Integration with MySQL database system

[Former Community Member]

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

[smacdonald2008 · Accepted solution]

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

[Former Community Member]

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

Mike