How to get external data from DB into AEM | Community
Skip to main content
J
jayan_acharya76
October 10, 2023
Solved

How to get external data from DB into AEM

  • October 10, 2023
  • 4 replies
  • 1337 views

Hi,

 

The requirement is that there is some data that is stored in traditional database, but they doesn't want to expose this data through APIs. Instead, they can give this data as a file or as a feed process. What are the different ways this can get into AEM. For example I have a component which displays vehicle information(as authored), but the price details has to come from the database. Please let me know in your experience how this can be handled.

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 Saravanan_Dharmaraj

@jayan_acharya76 You can connect to DB directly from AEM, please check out this documentation[1]. Once you connect to db, you can read and create necessary nodes in AEM and read it through sightly/model and by using services. 

In your case you have mentioned the dynamic part of content which is pricing, for that i would not use this approach since the pricing could be very dynamic. Please check SSI [2]. or API from DB side would be a better approach.

 

[1]https://docs.mktossl.com/docs/experience-manager-learn/cloud-service/networking/examples/sql-datasourcepool.html?lang=en

[2] https://medium.com/tech-learnings/sling-dynamic-include-deep-dive-dynamically-include-page-components-in-aem-5420a696cd02

 

 

4 replies

Saravanan_Dharmaraj
Community Advisor
Saravanan_DharmarajCommunity AdvisorAccepted solution
Community Advisor
October 10, 2023

@jayan_acharya76 You can connect to DB directly from AEM, please check out this documentation[1]. Once you connect to db, you can read and create necessary nodes in AEM and read it through sightly/model and by using services. 

In your case you have mentioned the dynamic part of content which is pricing, for that i would not use this approach since the pricing could be very dynamic. Please check SSI [2]. or API from DB side would be a better approach.

 

[1]https://docs.mktossl.com/docs/experience-manager-learn/cloud-service/networking/examples/sql-datasourcepool.html?lang=en

[2] https://medium.com/tech-learnings/sling-dynamic-include-deep-dive-dynamically-include-page-components-in-aem-5420a696cd02

 

 

    aanchal-sikka
    Community Advisor
    aanchal-sikkaCommunity Advisor
    Community Advisor
    October 11, 2023

    Hello @jayan_acharya76 

     

    One approach is to connect DB directly, as suggested by @saravanan_dharmaraj .

     

    Incase, that isn't allowed you can use the file. Sharing link of a discussion where an excel is processed to stores information in /var nodes. 

    Solved: Re: Is there a technical solution to import an Exc... - Adobe Experience League Community - 624943

    Aanchal Sikka
      kautuk_sahni
      Community Manager
      kautuk_sahniCommunity Manager
      Community Manager
      October 11, 2023

      @jayan_acharya76 Did you find the suggestions from users helpful? Please let us know if more information is required. Otherwise, please mark the answer as correct for posterity. If you have found out solution yourself, please share it with the community.

      Kautuk Sahni
      EstebanBustamante
      Community Advisor and Adobe Champion
      EstebanBustamanteCommunity Advisor and Adobe Champion
      Community Advisor and Adobe Champion
      October 11, 2023

      Another alternative could be to periodically synchronize the file containing the necessary information with AEM to a fixed location. You (or someone else) will manage the process of generating a file with the required information from the DB in AEM, which will be made available to be imported into AEM. There are multiple ways to import the file into AEM, so the choice depends on various factors, such as network capabilities, infrastructure, security policies, and more. Once you have that file in AEM, you can easily process it as needed and when needed. Again, there's a wide variety of options available, including creating a node structure, converting it into a different format, consuming it directly, and more.

      Esteban Bustamante
        Terms & ConditionsAccessibility statement

        Loading footer...