You can use the Microsoft SSIS packages to automatically create a client connection to the Fleettracker SOAP interface and store the information in a Microsoft SQL database. The following links give some insight how to set up such an interface without programming work.
External links:
- http://msdn.microsoft.com/en-us/library/cc952921%28v=sql.100%29.aspx - Creating a Basic Package (SQL Server Video). This video demonstrates how to create a basic package by using the SSIS Designer in Business Intelligence Development Studio.
- http://msdn.microsoft.com/en-us/library/cc952927%28SQL.100%29.aspx - How to: Call a Web Service by Using the Web Service Task (SQL Server Video). Learn how to call a Web service successfully from an Integration Services package by configuring an HTTP connection manager and the Web Service task. Then, set up an XML task to read the information that you have retrieved, and use that information in the package.