Its fairly simple. You just need to create a user dsn and choose the provider. Visio will help you to reverse engineer the database schema to Logical model.
please check the link below for more information.
http://www.dotnetjunkies.ddj.com/Article/74851895-C4D4-4F11-956D-A27D849E4A62.dcik
Thanks
Sachin