Skip to main content

[en] Blue icon showing an input into a database. Dynamic Input In-DB Tool

[en] Use Dynamic Input In-DB to take In-DB Connection Name and Query fields from a standard data stream and input them back into an In-DB data stream. The In-DB Connection Name and Query fields can be obtained from the Dynamic Output In-DB tool.

[en] In-Database enables blending and analysis against large sets of data without moving the data out of a database and can provide significant performance improvements over traditional analysis methods. For more about the In-Database tool category, visit In-Database Overview.

[en] Configure the Tool

  • [en] ConnectionNameField: The alias for the In-DB connection to the database.

  • [en] Query / Query Alias List Field: The In-DB query created at this point in the workflow.

[en] Possible Errors

[en] If the query fed into the Dynamic Input In-DB tool contains a WITH clause, this error is returned:

[en] The In-DB Dynamic Input tool cannot accept a query which uses a WITH clause. Consider using a Query Alias List instead.

[en] To resolve the error, modify the query to remove the common table expression (WITH clause).

: