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
Bedrock Mission!

Learn more

View all

Sign in to view all badges

SOLVED

Content Migration from RDBMS

bhavanij6146933
Level 2
Level 2

Hi,

we are planning to move an existing app from Java stack to AEM. This application has a RDBMS behind it which has some structured and some unstructured(blob's etc).

What would be the best (Adobe) approach to move this data. Should i just leave it in Oracle and use it as an external Data Provider or should i move both of the data into AEM or just move the Blob's into AEM and leave the structured data in AEM.

WHich will be the fastest approach in terms of execution.

Thanks,

Prasad

1 Accepted Solution
Lokesh_Shivalingaiah
Correct answer by
Community Advisor
Community Advisor

Hi Prasad,

Where the data resides should be based on what is the source of truth.

Keeping the data within AEM is always better considering the performance, network latency etc..

However, if this is the common content which needs to be accessed by multiple systems, then its better to keep it in RDBMS itself.

Migration:

Irrespective of whether the data is structured or unstructured, once you have the information architecture defined in AEM, you should be able to create a one time script and migrate the data from DB to AEM.

Thanks,

Lokesh

View solution in original post

3 Replies
Aem-user1
Level 2
Level 2

AEM supports pulling/inserting data from a relational database.

For this use case -- you need to use DataSourcePool and write the service to perform database operations. See this AEM article as an example:

Scott's Digital Community: Injecting a DataSourcePool Service into an Adobe Experience Manager OSGi ...

Or you can port all the data to the AEM JCR. This is your decision. Some people use a relational database and others use the Java Content Repository to store data for AEM sites.

bhavanij6146933
Level 2
Level 2

Do we essentially need to discriminate between structured and unstructured data? The site is quite dynamic and will require a lot of querying. Which approach would work faster, Using the Data source pool for all the data or moving the blobs to AEM and then using the Datsourcepool for structured data?

which should be more faster.

Lokesh_Shivalingaiah
Correct answer by
Community Advisor
Community Advisor

Hi Prasad,

Where the data resides should be based on what is the source of truth.

Keeping the data within AEM is always better considering the performance, network latency etc..

However, if this is the common content which needs to be accessed by multiple systems, then its better to keep it in RDBMS itself.

Migration:

Irrespective of whether the data is structured or unstructured, once you have the information architecture defined in AEM, you should be able to create a one time script and migrate the data from DB to AEM.

Thanks,

Lokesh

View solution in original post