If you want to do migration of databases, the first and foremost thing is you must be able to connect to them from various tools. And for open connectivity, it is best to work with jdbc drivers. I am going to list the locations from which you can download jdbc drivers for both Oracle and Amazon Redshift
1. Oracle Database JDBC Driver
https://www.oracle.com/technetwork/database/application-development/jdbc/downloads/jdbc-ucp-183-5013470.html
2. Amazon Redshift JDBC Driver
https://docs.aws.amazon.com/redshift/latest/mgmt/configure-jdbc-connection.html
RedshiftJDBC42-no-awssdk-1.2.20.1043 copy.jar
