#Does dsn need username and password install

The Single Access Point data connections dialogue will open up.

Click the drop-down 'Connect to a File or Database.'.

Open Alteryx Designer and drag and drop the “Input Data” tool onto the canvas.

Please note that Alteryx Designer / Server do not support File DSNs. Only the user who created the DSN can use it.īoth types of DSNs can be configured via the ODBC Admin app.

The User DSN on the other hand is created for a specific user.

For a data connection to use a DSN on Server, it needs to be created as a System DSN. The typical use case would be sharing a data connection inside the organization. Often the customer's IT has to be involved in creating a System DSN.

To create it, administrative privileges are required on the Windows OS. The System DSN is available for all users on the system.There are various types of ODBC data source types. Please refer to this Microsoft article for further information. and is utilized when making a connection to an ODBC data source.

It stores connection details like database name, directory, User ID, password etc. A DSN is a symbolic name that represents the ODBC connection. For Designer 2021.3+, a supported 64-bit driver is required see also here.īefore proceeding, it is important to decide whether to use a System or a User DSN. If you are unsure of where to get the driver or which driver to use, please contact your IT or database admin for this information). The download links to many of the drivers can be found here.

#Does dsn need username and password install

ODBC driver for the database (if it is not currently present on your machine, you must download and install it prior to using this guide. T his guide will focus on setting up an ODBC connection to SQL server, however, the same general process can be followed to connect to any database via ODBC. Alteryx can connect to databases using different methods.