Skip to main content

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

用户角色要求

用户角色*

工具/功能访问

完整用户

✓

基本用户

X

*适用于 Designer 版本 2025.1+ 上的 Alteryx One专业版和企业版客户。

使用“数据流传出”工具，将数据从数据库内工作流传输到 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. Pre- and post-SQL statements are compatible with the Bulk Loaders, OCI, ODBC, and OLE DB technologies.

    To configure your SQL statements...

    1. 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 and Stored Procedures tabs.

    2. Next, define SQL statements as needed:

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

    3. To configure Pre-SQL and Post-SQL statements...

      • Use the SQL Editor tab to define a SQL statement to execute before/after the In-DB 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-SQL statements do not return data. While SQL can return data, Designer doesn't do anything with it.

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

      • Use the Stored Procedures tab to select and configure a stored procedure call for your database. You can select a Parameter and set a Value for your stored procedures if needed. All stored procedures are sent directly to the database.

        • If a stored procedure is executed successfully, it returns any necessary status messages or warnings in the Results window.

        • If a stored procedure returns data, Designer does not return it anywhere. The data is not displayed in the Results window.

        重要

        Stored procedures are supported for these connections:

        • SQL Server for ODBC and Bulk Writer

        • Oracle for ODBC Only

    4. Select OK when you're finished or Cancel to return to the tool configuration window.

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

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

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

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

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

本节内容如下: