Skip to main content

Blue icon with a stream-like object flowing out of a database. 数据流传出工具

使用“数据流传出”工具,将数据从数据库内工作流传输到 Alteryx Designer。

“数据库内”工具无需将数据移出数据库即可对大型数据集进行融合与分析,与传统分析方法相比,它们可以显著提高性能。有关“数据库内”工具类别的详细信息,请参阅“数据库内概述”。

配置工具

Use the Configuration window to customize the Data Stream Out tool.

  • Advanced Query Options: Use this section to define Pre and Post SQL statements to execute. Use the 3-dot menu associated with either the Pre or Post Statement fields to launch the Configure Pre/Post SQL Statements window which includes the SQL Editor. Note that Stored Procedures are not currently supported.

    Pre- and post-SQL statements are compatible with the following technologies: Bulk Loaders, OCI, ODBC, and OleDB.

    • Pre-SQL Statement: Define a SQL statement to execute before the in-database execution.

    • Post-SQL Statement: Define a SQL statement to execute after the in-database execution.

    注意

    When the workflow runs, the Results window displays messages to show that the tool is executing SQL statements, along with a label (PreSQL, PostSQL).

    All SQL statements are sent directly to the database. Pre- and Post-SQL statements do not return data. While SQL can return data, Designer doesn't do anything with that data.

    If there are multiple streams of In-DB tools, there is no guaranteed order of execution between different streams. The Results window displays the order.

  • Sort records before streaming out: This is an optional setting. When checked, the incoming data is sorted by the field specification below.

    • 名称 :选择要排序的字段。

    • 排序方式 :选择“升序”或“降序”。

    • 使用向上和向下箭头更改顺序,也可使用“-”按钮删除字段。

将一个标准工具连接到“数据流传出”工具的输出。