Expand my Community achievements bar.

Don’t miss the AEM Skill Exchange in SF on Nov 14—hear from industry leaders, learn best practices, and enhance your AEM strategy with practical tips.
SOLVED

AEM Underlying Database = MS SQL Server?

Avatar

Level 10

Hi all,

I am aware that AEM does not function on any RDBMS, as an underlying backend and it has to be a Java Content Repository (JCR) based one.

Could you please suggest whether the following is possible with AEM, at least on the latest versions?

AEM  Database = MS SQL Server.

Appreciate a quick reply.

Thanks,

Rama.

1 Accepted Solution

Avatar

Correct answer by
Level 10

We checked with internal AEM ppl - they replied:

Here is the list of Supported Platforms for AEM 6.3: https://helpx.adobe.com/experience-manager/6-3/sites/deploying/using/technical-requirements.html.

Unless this customer is an AEM Forms user, MS SQL Server is not supported.

However, if they are looking to access an external SQL database so that your CQ applications can interact with data. See https://helpx.adobe.com/experience-manager/6-3/sites/developing/using/jdbc.html.

View solution in original post

4 Replies

Avatar

Level 10

AEM works on top of the JCR - as you know. You can develop components/services/workflows to interact with a relational database. But for replacing the nodes for a relational database - I have never seen that.

Why would you even want to attempt replacing the JCR with MS SQL. If you have MS SQL data you want to use in a web page - write custom components/services.

Avatar

Correct answer by
Level 10

We checked with internal AEM ppl - they replied:

Here is the list of Supported Platforms for AEM 6.3: https://helpx.adobe.com/experience-manager/6-3/sites/deploying/using/technical-requirements.html.

Unless this customer is an AEM Forms user, MS SQL Server is not supported.

However, if they are looking to access an external SQL database so that your CQ applications can interact with data. See https://helpx.adobe.com/experience-manager/6-3/sites/developing/using/jdbc.html.

Avatar

Level 10

Thanks Scott for this update.

But, on searching, I got the following link on this subject: RDBMS Support in AEM 6.3

I am still not sure that this link is the one I should follow.

Any ideas?

Thanks,

Rama.

Avatar

Level 10

Hi Scott,

I went to Technical Requirements  from that URL to read Technical Requirements1446874_pastedImage_1.png1446911_pastedImage_2.png

Since Microsoft SQL Server 2016 is classified under 4, it is Supported for AEM Forms only.

Now I got a better understanding of this subject.

Appreciate your support.

Thanks,

Rama.