AEM 6 work with Oracle DB ? | Community
Skip to main content
S
srinivasan_m
New Participant
October 16, 2015
Solved

AEM 6 work with Oracle DB ?

  • October 16, 2015
  • 12 replies
  • 7633 views

In AEM 6 upgrade document, I could able to see the information related to migeating to mongodb. Kindly confirm me that AEM 6 need mongo db only or will it work with Oracle DB also? As AEM 5.x is working with Oracle DB.

    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

    Out of the box - no - AEM does not work with Oracle. However - you can write a custom service (within an OSGi) that persists and queries data to and from an Oracle database.

    To do so - you have 2 choices:

    1 - you can use Java JDBC APIs to write an OSGi bundle to work with Oracle and write your own connection application logic. See these community articles (they use MySQL - but you can replace that with Oracle):

    http://helpx.adobe.com/experience-manager/using/persisting-cq-data-relational-database.html

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

    2 - you can inject a DataSourcePool into an OSGi. Configure the DataSourcePool to work with Oracle. See this community article:

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

    Good luck!

    12 replies

    Show previous replies
    M
    Mshaji
    New Participant
    October 16, 2015

    AEM 6 has options to store the data in backend for MongoMK. You need to have mongo db instance running to have this option.

    However you can use oracle persistence manager to store the data 

    More information can be found on

    http://docs.adobe.com/docs/en/cq/current/core/administering/persistence_managers.html

    smacdonald2008
    smacdonald2008Accepted solution
    New Participant
    October 16, 2015

    Out of the box - no - AEM does not work with Oracle. However - you can write a custom service (within an OSGi) that persists and queries data to and from an Oracle database.

    To do so - you have 2 choices:

    1 - you can use Java JDBC APIs to write an OSGi bundle to work with Oracle and write your own connection application logic. See these community articles (they use MySQL - but you can replace that with Oracle):

    http://helpx.adobe.com/experience-manager/using/persisting-cq-data-relational-database.html

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

    2 - you can inject a DataSourcePool into an OSGi. Configure the DataSourcePool to work with Oracle. See this community article:

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

    Good luck!

      Terms & ConditionsAccessibility statement

      Loading footer...