Yes. I have used Erwin before and I was able to connect to
Oracle DB without any problems using a DNS (with Oracle Driver).