CJA Connection over multiple sandboxes

[alben]

Hi there,

I am working for a client that has different sandboxes for different geographic areas (2 sandboxes).

They would like to have a unique view in CJA, so that the reports/dashboards can offer a 360° view on all the countries, without the segregation of the 2 underlying sandboxes. Is there any (easy and out-of-the-box) way to do so?

We think connections can only be to single sandboxes.

We would like to understand if there is any smart way to achieve this, other than having to copy all the data from the 2 underlying sandboxes to a 3rd sandbox that would be connected to CJA. This would be a very cumbersome workaround, involving lots of manual work, many data flows, and would be very prone to errors and with an high data latency given all the data transfers - other than being a very expensive solution, given the additional sandbox and the duplication of the profiles from the underlying sandboxes to the new merged one.

Many thanks!

[KumarRishii]

You cannot create a single CJA connection across multiple AEP sandboxes — each connection is limited to one sandbox.

If you have a unified, merged view in CJA, your best option is to:

- Design a unified schema, including sandbox/geography identifiers.
- Automate data movement from each sandbox to a third reporting-specific dataset.
- Build a CJA connection from that dataset and maintain it solely for reporting.

I hope the above options helps clarify your queries.

[alben]

Hi Kumar,

thanks for your reply.

When you say "Automate data movement from each sandbox to a third reporting-specific dataset" you mean having a 3rd sandbox, as I wrote in my original message, right?

Would the datasets in the 3rd reporting sandbox have to be enabled for profile in order to work with CJA? I do not think that's necessary, right? The aim would be to at least avoid creating actual copies of all the profiles from the 2 sandboxes to the 3rd reporting sandbox, meaning that from a licensing point of view, the 3rd sandbox would not increase the profile count, because would have actually 0 records enabled for profile.
Does this make sense?


My fear is that in order to view all the engagements on emails/any other channel we would also have to copy over from the 2 sandboxes all the AJO tracking/engagement system datasets though.
And those are by default enabled for profile, isn't it?

Thus, I'm not sure about the point above on the actual possibility to not having to creare new profiles in the reporting sandbox.

Many thanks