Also is it possible to use username, pwd and security token instead of oauth

Hey Sarabjot if you can be more specific with the source/destination it helps us to streamline our response. Ex: for some sources you can generate oauth token from username and password.

My source will be salesforce and target redshift.

Hey do you think this helps https://help.salesforce.com/s/articleView?id=sf.remoteaccess_oauth_tokens_scopes.htm&type=5 ?