Hi, for this you need a small custom module for Odoo. In your module, you should create a wizard that lets the user to select/input the information needed for the import of the data from SQL Server. In the method linked to the submit button of the wizard, call the importing code (pyodbc). For the insertion into Odoo, you might want to re-write you XML-RPC code used in the current client with server specific code for creating the records. Surely, you could use for this last step SQL statements directly, but it is not advisable. If you need more details for the custom module or for the wizard, please let me know.

I hope this helps! If it does, please up-vote the answer. Best, BISS