[en] Connection Setup Considerations
[en] When you establish database connections, take these considerations into account.
[en] Guided Connection Setup
[en] 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 normally.
[en] SQL Server
[en] SQL Server passwords do not support the use of 3 consecutive pipes.
[en] Oracle
[en] Oracle passwords do not support the use of double-quotes.
[en] Manual Connection Setup
[en] 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.
[en] For more information on the syntax required by a specific database type, read the sections below.
重要
[en] In order to create a System connection, you must run Alteryx Designer as an Administrator.
[en] Microsoft SQL Server
[en] Enclose the string in curly brackets.
[en] Escape any right curly bracket with 2 consecutive right curly brackets.
[en] For additional requirements, go to SQL Server Database Password Requirements.
[en] Oracle
[en] Enclose the string in double quotes.
[en] Do not use double-quotes within the string.
[en] For additional requirements, go to Oracle Database Password Requirements.