Main Content

Magnolia Community Forums: Get help with Magnolia: Connecting with database


  • tumpasingharay2
    tumpasingharay2
    Full name: Tumpa SINGHA RAY
    Posts: 5
    Last post: Nov 7, 2017 2:27:54 PM
    Registered on: Jun 1, 2017
    Connecting with database
    #1 by tumpasingharay2 on Jun 22, 2017 7:38:16 AM

    Hi

    I have created pages using light module instead of maven module. Is it possible in Magnolia to store data into database and retrieve it in tables.

  • tumpasingharay2
    tumpasingharay2
    Full name: Tumpa SINGHA RAY
    Posts: 5
    Last post: Nov 7, 2017 2:27:54 PM
    Registered on: Jun 1, 2017
    Re: Connecting with database
    #2 by tumpasingharay2 on Jun 22, 2017 8:15:22 AM

    Hello All,

    Can we achieve this functionality using REST API?

    Regards,
    Tumpa

  • cmeier
    cmeier
    Full name: Christoph Meier
    Posts: 212
    Last post: Oct 19, 2017 6:08:59 PM
    Re: Connecting with database
    #3 by cmeier on Jun 27, 2017 4:08:00 PM

    Hello Tumpa SINGHA RAY

    Magnolia is using JCR to store most if not all of the data - this is especially true for website content.
    Typically JCR is not restricting what data store is used "under the hood" to persist the JCR data - its persistence layer can and often is a RDBMS (especially in productive environments).
    However, from the Magnolia perspective, the data is stored in JCR nodes and properties - independent from the persistence layer.

    Doesn't make sense to operate directly on the DB layer in the context of Magnolia website content (imho).

    Why would you do that?
    What is your use case?
    What is your goal?

    However - there is always a lot of space to customize Magnolia :-)


    Resources:
    - https://en.wikipedia.org/wiki/Content_repository_API_for_Java
    - https://documentation.magnolia-cms.com/display/DOCS/JCR+API
    - https://documentation.magnolia-cms.com/display/DOCS/Content+app+with+non-JCR+content

    I hope this helps,
    kind regards,
    Christoph

  • tumpasingharay2
    tumpasingharay2
    Full name: Tumpa SINGHA RAY
    Posts: 5
    Last post: Nov 7, 2017 2:27:54 PM
    Registered on: Jun 1, 2017
    Re: Connecting with database
    #4 by tumpasingharay2 on Nov 2, 2017 2:47:10 PM

    Hello Christoph,

    Thanks for the reply!
    Our goal is to get data from Form of our website to be stored in Author instance. We will collect the information and can use in respective ways.

    Kind Regards,
    Tumpa

  • marvink2
    marvink2
    Full name: Marvin Kerkhoff
    Posts: 45
    Last post: Nov 22, 2017 9:14:20 AM
    Re: Connecting with database
    #5 by marvink2 on Nov 6, 2017 11:59:00 AM

    Hi Tumpa,

    probably the easiest way is to use the module i developed for such cases. Is has also an excel export feature

    https://wiki.magnolia-cms.com/display/WIKI/Form2DB+App

    If you don't use a Maven Setup, you need to download the packages by hand. It's a bit tricky to get all dependencies, but not impossible. By the way. It is recommended to use a clustered form2db workspace so that author and public write on the same data and you can view them on author if someone used the form on the public instances.

You don't have the permission to post on this thread

Sign in

To login on this forum, you can use your Magnolia Forge, Support or Partner account, or, below, your Google, Yahoo! or OpenID account. If you have trouble logging in, or any other sort of issue, please let us know in the Meta forum, on the user-list, or simply by email at forum-admin at magnolia-cms dot com.

* Required

... or sign in with:

  • icon http://{your-openid-url}
  • icon
  • icon https://me.yahoo.com/