Data Modeling

Hello, I'm looking for a good data modeling software that can either connect to an ODBC source and read in the DB or will look directly at vision files to allow for creation of a data diagram. Anyone have any experience with these types of products, or recommendations?