使用“数据流传出”工具,将数据从数据库内工作流传输到 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.
名称 :选择要排序的字段。
排序方式 :选择“升序”或“降序”。
使用向上和向下箭头更改顺序,也可使用“-”按钮删除字段。
将一个标准工具连接到“数据流传出”工具的输出。