Your achievements

Level 1

0% to

Level 2

Tip /
Sign in

Sign in to Community

to gain points, level up, and earn exciting badges like the new
BedrockMission!

Learn More

View all

Sign in to view all badges

Stored Data into AEM jcr node from Other RDBMS

Avatar

Avatar
Validate 1
Level 1
shahrukha567143
Level 1

Likes

0 likes

Total Posts

14 posts

Correct Reply

0 solutions
Top badges earned
Validate 1
Give Back 3
Give Back
Ignite 1
View profile

Avatar
Validate 1
Level 1
shahrukha567143
Level 1

Likes

0 likes

Total Posts

14 posts

Correct Reply

0 solutions
Top badges earned
Validate 1
Give Back 3
Give Back
Ignite 1
View profile
shahrukha567143
Level 1

21-02-2019

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

Replies

Avatar

Avatar
Give back 300
MVP
Gaurav-Behl
MVP

Likes

243 likes

Total Posts

1,145 posts

Correct Reply

281 solutions
Top badges earned
Give back 300
Give Back 50
Give Back 5
Give Back 3
Give Back 25
View profile

Avatar
Give back 300
MVP
Gaurav-Behl
MVP

Likes

243 likes

Total Posts

1,145 posts

Correct Reply

281 solutions
Top badges earned
Give back 300
Give Back 50
Give Back 5
Give Back 3
Give Back 25
View profile
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?

Avatar

Avatar
Validate 25
Level 10
smacdonald2008
Level 10

Likes

1,406 likes

Total Posts

12,671 posts

Correct Reply

2,278 solutions
Top badges earned
Validate 25
Validate 10
Validate 1
Give back 900
Give back 600
View profile

Avatar
Validate 25
Level 10
smacdonald2008
Level 10

Likes

1,406 likes

Total Posts

12,671 posts

Correct Reply

2,278 solutions
Top badges earned
Validate 25
Validate 10
Validate 1
Give back 900
Give back 600
View profile
smacdonald2008
Level 10

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.

Avatar

Avatar
Validate 25
Level 10
smacdonald2008
Level 10

Likes

1,406 likes

Total Posts

12,671 posts

Correct Reply

2,278 solutions
Top badges earned
Validate 25
Validate 10
Validate 1
Give back 900
Give back 600
View profile

Avatar
Validate 25
Level 10
smacdonald2008
Level 10

Likes

1,406 likes

Total Posts

12,671 posts

Correct Reply

2,278 solutions
Top badges earned
Validate 25
Validate 10
Validate 1
Give back 900
Give back 600
View profile
smacdonald2008
Level 10

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.

Avatar

Avatar
Validate 1
Level 1
shahrukha567143
Level 1

Likes

0 likes

Total Posts

14 posts

Correct Reply

0 solutions
Top badges earned
Validate 1
Give Back 3
Give Back
Ignite 1
View profile

Avatar
Validate 1
Level 1
shahrukha567143
Level 1

Likes

0 likes

Total Posts

14 posts

Correct Reply

0 solutions
Top badges earned
Validate 1
Give Back 3
Give Back
Ignite 1
View profile
shahrukha567143
Level 1

24-02-2019

I want to move entire database into AEM jcr

Avatar

Avatar
Give back 300
MVP
Gaurav-Behl
MVP

Likes

243 likes

Total Posts

1,145 posts

Correct Reply

281 solutions
Top badges earned
Give back 300
Give Back 50
Give Back 5
Give Back 3
Give Back 25
View profile

Avatar
Give back 300
MVP
Gaurav-Behl
MVP

Likes

243 likes

Total Posts

1,145 posts

Correct Reply

281 solutions
Top badges earned
Give back 300
Give Back 50
Give Back 5
Give Back 3
Give Back 25
View profile
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