I am looking to create a connection from Salesforce to a SQL 2000 database. I need to be able to transfer data from salesforce to SQL 2000 and from SQL 2000 back to Salesforce. An example of what I want to do is if a user creates a new calendar event in salesforce I want to be able to send that event to my SQL 2000 database so that I can create a meeting record. Then I want to pass back the unique id from SQL to Salesforce so that the records in both systems will be connected.
How do I create that connection?