Hi!
If you used the standard On-Chip Memory (under the "Memory" component category in SOPC Builder), there is no easy way to connect the memory to an VHDL module OUTSIDE the Avalon System Module (SOPC Builder System). This dual-port memory is designed to have two masters connected to both ports INSIDE the Avalon System Module.
It is probably easier to make the dual-port memory module yourself (or with the help of the Quartus MegaWizard) and then use the Create New Component Wizard in SOPC Builder to make it part of your Avalon System Module. There, you can specify that the second port is "extern" so that the VHDL module which creates the data can connect to the dual-port memory inside the System Module.
Hope this helps...