Excellent answer Ratna.
I would like to add very small note that i fould out:-
There may be couple of options to go about it -
A) leveraging OpenDeploy to transform xml into AEM JCR structure
B) there was an old interwoven connector on crx2.3, not sure if it works against Oak?
https://docs.adobe.com/docs/en/crx/connectors/interwoven/current.html#Installing%20the%20Interwoven%...
DCRs are xml files and it could be simple work to parse them and extract content to create pages. If you also need to extract extended attributes you can probably leverage on TeamSite APIs to also extract this data. Otherwise you can set up a script to get them via TeamSite command line tools. This script could also post data to CQ read from DCRs and Ext Attributes, but not sure if this is best approach to use.
TeamSite is also shipped with OpenDeploy: this is tool used by TeamSite to move contents from Authoring to Publish environment. If I remember correctly one of the options available with OpenDeploy, is to perform deployment of XML files. You could eventually use this tool to extract data and extended attributes and then deploy in CQ supported XML that can be packaged and deployed into CQ.
For your extended question on:-
Do you have any idea to implement custom login
1. check credentials in My SQL database.
2. if success, login to AEM server.
Please create a new question and marked this one as solved.
~kautuk
