Forum Discussion
Resolver IIPipeline - Copy Data - Amazon Redshift - No gateway option
Hi Nono,
Thank you for your response. I guess my question is why not offer/use a gateway for the connection. I know it's not required per your earlier reponse. However, it DOES work with a gateway with the DFG2s. Perhaps there's some technical reason that it wants to use a direct connection instead of a gateway.
However it's unexpected behavior that we would need to utilize a different authentication method than we have been using with PowerBI (semantic model and DFG2 refreshes) this entire time.
Hi coverturfLSH
"However, when I choose AWS Redshift as a source. There is no option for a gateway (exhibit 2)." First of all, in response to your question: The documentation states that it does not require a gateway.
This is the answer to your question.
Since your IT team is connected through service account management, you can ask them if they can create a specific role or user for you with the necessary permissions.
Regards,
Nono Chen
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Resolver IIHi Nono,
Thank you for your response. I guess my question is why not offer/use a gateway for the connection. I know it's not required per your earlier reponse. However, it DOES work with a gateway with the DFG2s. Perhaps there's some technical reason that it wants to use a direct connection instead of a gateway.
However it's unexpected behavior that we would need to utilize a different authentication method than we have been using with PowerBI (semantic model and DFG2 refreshes) this entire time.
Hi coverturfLSH
Have you solved the problem now?
Regards,
Nono Chen
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
- coverturfLSH
Technically yes, as there does not seem to be a solution for my problem.