Highlighted

Stored Data into AEM jcr node from Other RDBMS

Avatar

Avatar

shahrukha567143

Avatar

shahrukha567143

shahrukha567143

21-02-2019

Is there any way, We can stored the data into AEM jcr node from any RDBMS?

Replies

Highlighted

Avatar

Avatar

Gaurav-Behl

MVP

Total Posts

1.1K

Likes

226

Correct Answer

281

Avatar

Gaurav-Behl

MVP

Total Posts

1.1K

Likes

226

Correct Answer

281
Gaurav-Behl
MVP

22-02-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?

Highlighted

Avatar

Avatar

smacdonald2008

Total Posts

12.7K

Likes

1.4K

Correct Answer

2.3K

Avatar

smacdonald2008

Total Posts

12.7K

Likes

1.4K

Correct Answer

2.3K
smacdonald2008

22-02-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.

Highlighted

Avatar

Avatar

smacdonald2008

Total Posts

12.7K

Likes

1.4K

Correct Answer

2.3K

Avatar

smacdonald2008

Total Posts

12.7K

Likes

1.4K

Correct Answer

2.3K
smacdonald2008

22-02-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.

Highlighted

Avatar

Avatar

shahrukha567143

Avatar

shahrukha567143

shahrukha567143

24-02-2019

I want to move entire database into AEM jcr

Highlighted

Avatar

Avatar

Gaurav-Behl

MVP

Total Posts

1.1K

Likes

226

Correct Answer

281

Avatar

Gaurav-Behl

MVP

Total Posts

1.1K

Likes

226

Correct Answer

281
Gaurav-Behl
MVP

25-02-2019

I'm not sure why would you want to do that. In any case, you need to understand your requirements/use cases in depth and pros/cons (essentially relational database vs jcr features) of what you plan to do. There is no automated tool available to simply lift and land database into jcr.

You'd need to identify "detailed" requirements, create a design, data model, taxonomy, site structure and other aspects and follow the sample implementation as mentioned by Scott and create a full-fledged app for same.

Reference link -

DavidsModel - Jackrabbit Wiki