Forum Discussion

skoalit's avatar
skoalit
Regular Visitor
9 years ago

Connect data from Amazon AWS Services

Hi I am new at this, but I would like to know how I can:    1. Connect live data from Amazon AWS Services (right now the crawler dumps the data on Amazon S3 as zip files), or even to an SQL server ...
Need Help
skaranth10's avatar
skaranth10
Helper I
5 years ago

Hi skypurplecloud ,

I am currently facing issues trying to connect Power BI to the AWS database as well. Been trying to read various articles on how this is being done, but I am not able to connect to the database. Any help would be appreciated! 

 

 

PhilipTreacy's avatar
PhilipTreacy
Super User
5 years ago

Hi skaranth10 

It's best to start a new topic and explain in detail your issue there.

What exactly is the problem?  What exactly are you trying to connect to?  AWS API?  SQL on AWS?  Amaxon S3?  Are you receiving error messages?

Phil

If I answered your question please mark my post as the solution.
If my answer helped solve your problem, give it a kudos by clicking on the Thumbs Up.

  • skaranth10's avatar
    skaranth10
    Helper I
    5 years ago

    Hi PhilipTreacy ,

    I am trying to connect to the SQL on AWS. I have tried the Redshift Connector, but couldn't successfully connect. I get the error message as 

    "Details: "ODBC: ERROR [08S01] [Microsoft][Amazon Redshift] (10) Error occurred while trying to connect: [SQLState 08S01] could not connect to server: Connection refused (0x0000274D/10061)
    Is the server running on host "ec2-34-215-220-108.us-west-2.compute.amazonaws.com" (34.215.220.108) and accepting
    TCP/IP connections on port 5439?"

     

    Is Redshift the best way to connect? Do you recommend any other means? 

     

    Regards

  • skaranth10's avatar
    skaranth10
    Helper I
    5 years ago

    Hi,

    I am still getting this following error message when I try to connect Power BI to AWS with the Redshift connector- Error occurred while trying to connect: [SQLState 08S01] could not connect to server: Connection refused (0x0000274D/10061)
    Is the server running on host "ec2-34-215-220-108.us-west-2.compute.amazonaws.com" (34.215.220.108) and accepting
    TCP/IP connections on port 5439?
    "

     

    I have added an inbound rule to the AWS EC2 server for port 5439 with the source as 0.0.0.0/0 

     

    What changes do I have to do? Any suggestions?

     

    Thank you in advance!

    PhilipTreacy Greg_Deckler 

    • Greg_Deckler's avatar
      Greg_Deckler
      Community Champion
      5 years ago

      skaranth10 Is this just a SQL Server running in AWS or something else? Generally when I put in firewall rules for Azure I have to specify the exact IP address of the host that is connecting. There is a button I believe to add client ID. Would think there would be something similar for AWS. Network firewall rules aren't my forte though quite honestly.