Connect Redshift Database Sever using DBeaver: This is an example of the Mac OS, but it will works on Windows also. the input value and filed name are same for the Mac OS and Windows for DBeaver. In the following connection configuration you don't require to configure Putty tunnel and tunnel configuration as we are opening tunnel using SSH configuration.
Main Tab:
Host/Instance: global-consumer-np-rs.subdomain.domain.com. This is the host name of the database server in AWS cloud. Pay attention to the global, consumer as it is going to consume the data and data is getting ingested using software such as HVR, Talend etc. , np for non production, domain and subdomain can be analytics.exapmple.com
Port:5439. This is default port for the Amazon Redshift.
Authentication: Database Native
Username: SSO_ID
Password Database Password: _______ Check the check box to save password locally.
Following is an example of the Main Tab:
Select Connection details (name, type button which will enable - Edit Driver Setting button.
Edit Driver Setting screen:
Leave all values on the tab Settings, it is select by default.
Select Driver properties:
If you have downloaded the driver locally on your laptop or desktop in a user defined location, please select it here, by choosing Add File, and then select OK.
Following is an example of Redshift Tab:
Check the check box for - Show all databases as follows.
Select SSH tab:
Here we are going to configure SSH tunnel.
Host/ IP: global-consumer-np-bastion.subdomain.domain.com
Port - 22
User Name : Your Linux ID / LDAP ID you got it form the organization.
Authentication Method : Password
Password : ___________________
Select Test tunnel configuration. This test has to be successful, if it fail, check all the values you have provided.
Select tab SSL:
Check the box - Use SSL. Select Finish.
Comments
Post a Comment