How to make graphics with data from diferent databases

Question

Summary

Content

Hi guys.

I'm trying to make a grafic of Revenue Vs Customer but the Revenue data is in a database1 and the customer data is in database2. I have charged the two databases into the dvd but i don't really know if this is possible.

Can you help me with this please?

Thank you in advance.

Gianni Ceresa · Answer

Good timing: have a look at this blog Philippe posted yesterday https://blogs.oracle.com/analyticscloud/data-blending-made-easy-with-oracle-data-visualization

Gianni Ceresa · Answer

Hi Julian,

You start by selecting one of the 2 sources and create your project.

Then you add the second one and define how these 2 are joined together.

If you go into the "Prepare" mode (top-center of your screen where you have "Prepare Visualize Narrate") and there you have the "Source Diagram" tab (first one bottom of the screen) where you define the join (if not already there).