Intellipaat Back

Explore Courses Blog Tutorials Interview Questions
0 votes
2 views
in BI by (17.6k points)

I'm trying to login to my EC2 instance from Tableau. I have the postGresql driver installed on my Windows machine(w/ Tableau installed) and want to login to my EC2 instance.

From Tableau, it asks me for... Server Port Database Username Password

What is my username/password that I have to log in with? I can ssh into my EC2 instance no problem but that is using my .pem file. I'm a total newbie so can someone help with my schoolboy question?

1 Answer

0 votes
by (47.2k points)
edited by
  • You need to give Tableau the location of the database on your EC2 instance. The username and password that it is asking for are the credentials for your database not your EC2 instance.

  • You will also need to make sure that your Security Groups settings allow Tableau Desktop to directly connect to the database you have running in EC2. The default EC2 Security Group is as follows:

  • A default security group is named by default, and it has an ID assigned by AWS. These are the following initial settings for each default security group:

  • Allow inbound traffic only from other instances associated with the default security group.

  • Allow all outbound traffic from the instance.

  • So if you are running Tableau Desktop outside of AWS then you will have to specifically allow that traffic through.

Want to be an expert in Tableau? Check out the Tableau Training to get the right assistance.

Related questions

0 votes
1 answer
asked Jul 10, 2019 in AWS by Amyra (12.9k points)
0 votes
1 answer
asked Jul 5, 2019 in AWS by Amyra (12.9k points)
0 votes
1 answer
0 votes
1 answer

31k questions

32.8k answers

501 comments

693 users

Browse Categories

...