Connecting MySQL to external data source using proprietary ODBC Driver

I have a cloud-based CRM system that provides a proprietary ODBC Driver. This has been fully configured, set up as a system DSN, and tested with no errors. The system DSN is called 'servicenowdev'.

I also have a local MySQL server, that I would like to connect to the CRM system and download periodic backups. I can connect to the 'servicenowdev' DSN using i-SQL and run queries fine, but I would like to link the server (MS SQL Server "Linked Server" style), but in MySQL.

• Where do I start with connecting my MySQL server to this dsn? I don't know the internal details of the CRM system to provide a database name, host, port or any other details for a FEDERATED SERVER connection.

• Can I create views straight to the dsn's tables, or would I have to import data locally?