Secure XML transmissions

protect and transmit xml

[danielro]

Hey guys,

The problem I am facing is securing a XML file.

I have one database server and one web server.
I want to export some query data from DB and read that data on the Web server.

I was thinking of using some programming language to export query data to a XML file. The XML file will be updated every 15 minutes.

What is the best / easiest way to securely communicate that information to the web server (platform independent)?

[httpwebwitch]

Use a web scripting language such as PHP to connect to the database. Request data (using SQL) and inject the data into XML nodes as you build XML as a string.

The database connection should require authentication, i.e. a name and password; these security measures usually suffice. In addition, the database can restrict access to a list of known hosts.

[danielro]

I need to build the XML file on the database server. I have this covered.
What I'm interested in is accessing the XML file securely and remotely from the web server.