Problem:
My client is currently using Alteryx, but they are missing the ability to connect to databases directly, which they had with SAS EG. Alteryx requires a separate database engine to be installed on the server, while SAS EG includes its own embedded database engine. My client does not allow Alteryx Designer to directly connect to databases due to security policy. Therefore, I am looking for a workaround that will allow my client to host the database connection on one server and share it with Alteryx Designer users.
What I have tried:
I have reviewed the Alteryx documentation and online community, but I have not been able to find a satisfactory solution. I have also tried using a database proxy, but this has resulted in performance issues.
What I am asking for:
I am hoping that the Alteryx community can provide me with some guidance on how to share a database connection with Alteryx Designer users without sacrificing performance. I am also interested in learning if there are any third-party tools that can help me to achieve this goal.
Thank you in advance for your help!
