Skip to main content

Posts

Showing posts with the label Connect Amazon Redshift using DBeaver

Connect Amazon Redshift using DBeaver

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, t...