Expand my Community achievements bar.

Join us on September 25th for a must-attend webinar featuring Adobe Experience Maker winner Anish Raul. Discover how leading enterprises are adopting AI into their workflows securely, responsibly, and at scale.
SOLVED

Adobe Analytics historical data to AEP

Avatar

Level 6

Hello everyone, 
This is in follow up with https://experienceleaguecommunities.adobe.com/t5/adobe-analytics-questions/adobe-analytics-historica...
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.

Topics

Topics help categorize Community content and increase your ability to discover relevant content.

1 Accepted Solution

Avatar

Correct answer by
Community Advisor

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!

View solution in original post

2 Replies

Avatar

Correct answer by
Community Advisor

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!

Avatar

Level 6

Thanks Harveer, 

If you can tell me where exactly I would be able to find this. Is this an API approach or in UI?