topic Re: How to connect to a database with server name and protocol? in Alteryx Designer Desktop Discussions

How to connect to a database with server name and protocol?

td7 — Thu, 25 Aug 2022 21:29:46 GMT

I'd like to connect to a database that I normally access through a vendor tool. I don't know the kind of database, e.g., SQL server, Oracle, etc. What I know is the server name and protocol and log in as follows:

Server Name: site url for the database, e.g, abc.vendorsite.com\db

Protocol: WebSockets

User Name:xxxx

Password:xxxx

Is it possible to connect to it in Alteryx? Appreciate any advice. Thanks.

Re: How to connect to a database with server name and protocol?

Ladarthure — Fri, 26 Aug 2022 05:40:48 GMT

Hi @td7,

I found this post which seems to relate to something like this : https://community.alteryx.com/t5/Alteryx-Designer-Discussions/How-to-connect-to-WEB-SERVICE/td-p/193707

On the over hand, you could contact the vendor and ask them if there are any other way to connect to this base. It's often using apis, it may need a little bit of work to setup but it should work.

Arthur

Re: How to connect to a database with server name and protocol?

td7 — Fri, 26 Aug 2022 13:30:02 GMT

Arthur, thanks for your help.