Skip to main content

[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.