Connection Setup Considerations

Version:
2021.3
Last modified: August 11, 2021

When you establish database connections, take these considerations into account.

Guided Connection Setup

Guided connections do not require native syntax. The passwords are processed to match the standards of the database connection type that is being established. Enter passwords in normally.

SQL Server

SQL Server passwords do not support the use of 3 consecutive pipes.

Oracle

Oracle passwords do not support the use of double-quotes.

Manual Connection Setup

Manual connections require native syntax. Alteryx cannot manage the formatting of the string because these connections are entered without selecting a database type. Enter passwords with native syntax.

For more information on the syntax required by a specific database type, read the sections below.

In order to create a System connection, you must run Alteryx Designer as an Administrator.

Microsoft SQL Server

  • Enclose the string in curly brackets.
  • Escape any right curly bracket with 2 consecutive right curly brackets.

For additional requirements, visit SQL Server Database Password Requirements.

Oracle

  • Enclose the string in double-quotes.
  • Do not use a double-quote within the string.

For additional requirements, visit Oracle Database Password Requirements.

Was This Page Helpful?

Running into problems or issues with your Alteryx product? Visit the Alteryx Community or contact support. Can't submit this form? Email us.