Stored Data into AEM jcr node from Other RDBMS | Community
Skip to main content
This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.

1 reply

Gaurav-Behl
Gaurav-Behl
Level 10
February 22, 2019

Could you share more details about the use case?

Do you mean that you want to move data from RDBMS into jcr? Are you talking about a single row/blob file or entire database?

smacdonald2008
smacdonald2008
Level 10
February 22, 2019

You need to create a custom service that uses SQL to pull data from the relational database and updates the JCR. As Gaurav suggests - the details of how you do this depend on how much data. For example - if you want to move data from a single table to the JCR, you would need to read the data from the table and then decide where in the JCR you want to place the data. You could for example, create a new node at a specific location for each database record.

smacdonald2008
smacdonald2008
Level 10
February 22, 2019

ALso - assume you want to pull data from MySQL. You can use a DataSourcePool to help you setup a connection. See this article for information about creating a custom AEM service that uses a DataSourcePool to set a connection to MySQL:

Scott's Digital Community: Querying MySQL data using an Adobe Experience Manager 6.4 DataSourcePool

As you can see here - the custom service queries data from MySQL and then displays the data in a component view. Likewise, you could store in the data in the AEM JCR using the JCR NODE API.

Terms & ConditionsAccessibility statement

Loading footer...