AEM Underlying Database = MS SQL Server? | Community
Skip to main content
AEM_Forum
Level 10
March 20, 2018
Solved

AEM Underlying Database = MS SQL Server?

  • March 20, 2018
  • 4 replies
  • 6231 views

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.

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

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.

4 replies

smacdonald2008
Level 10
March 20, 2018

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.

smacdonald2008
smacdonald2008Accepted solution
Level 10
March 20, 2018

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.

AEM_Forum
AEM_ForumAuthor
Level 10
March 20, 2018

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.

AEM_Forum
AEM_ForumAuthor
Level 10
March 20, 2018

Hi Scott,

I went to Technical Requirements  from that URL to read Technical Requirements

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.