Adobe Analytics historical data to AEP

Question

Hello everyone,
This is in follow up with https://experienceleaguecommunities.adobe.com/t5/adobe-analytics-questions/adobe-analytics-historical-data-to-cja-through-aep/m-p/722136/highlight/true#M54747
I agree to Harveer's solution. However I have a problem;
I have 10 report suits and I cannot be doing custom mapping since I have almost 1k components per report suite. That would just eat up all my time.
Is there a better way to approach this via Query service.
Problem is, auto_json in query is not working. so it would be hard to mention every column in query service to achieve what I need.
Looking forward to hear If anyone know any hack that would help and have successfully completed migrating Adobe Analytics historical data to AEP on a custom schema.

Harveer_SinghGi1 · Accepted Answer

Hi @gautham_madala ,You have the option to import the data prep mapping from another data flow. So if the data transformations among your report suites are mostly common, then you can do a one time activity of adding custom mapping for one report suite and in other dataflows just import those mapping. Any variations can be added/updated.Cheers!

Sign up

Login with SSO

Login to the community

Login with SSO

Scanning file for viruses.

This file cannot be downloaded