Getting data via "XML Data" connectivity

Hi,

I need to retrieve data in Dashboard Design SP2 from one table stored on a SQL Server 2000. As I need to refresh the data I only have the option to use the "XML Data" connection (we are using BO4.0 Edge and can't use QaaWS).

However, I am completly new in this XML topic... In which way should data be delivered so that I can use it in Dashboard Design (in Data Manager -> "XML Data" I have to input a "XML Data URL"...)?

Thanks!