When you establish database connections, the following considerations should be taken 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. Type passwords in normally.
SQL Server passwords do not support the use of three consecutive pipes.
Oracle passwords do not support the use of double quotes.
Manual connection setup
Manual connections require native syntax. Because these connections are entered without selecting a database type, Alteryx cannot manage the formatting of the string. Type passwords in with native syntax. For more information on the syntax required by a specific database type, see the sections below.
For additional requirements, see SQL Server Database Password Requirements.
For additional requirements, see Oracle Database Password Requirements.
©2018 Alteryx, Inc., all rights reserved. Allocate®, Alteryx®, Guzzler®, and Solocast® are registered trademarks of Alteryx, Inc.