Blue icon showing an output from a database.

Dynamic Output In-DB Tool

Version:
Current
Last modified: June 16, 2020

The Dynamic Output In-DB tool outputs information about the In-DB workflow to fields in a standard workflow stream. Data streamed from this tool can be manually modified to then be fed into the Dynamic Input In-DB Tool.

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, see In-Database Overview.

Configure the Tool

Output Fields: Select the type of data you want to output.

  • Query: The In-DB query created at this point in the workflow.
  • Connection Name: The alias for the In-DB connection to the database.
  • Connection Data Source: The database type.
  • Input Connection String: The information about the database that is needed to be able to establish a connection to it.
  • Output Connection String: The information about the database that is needed to be able to establish a connection to it.
  • In-DB XML: XML representation of the In-DB query.
  • Record Info XML: XML representation of the database fields.
  • Query Alias List: Displays each segment of the query in the form of a common table expression.
  • Last Query Alias: The last alias from the Query Alias List.

Possible Errors

If either the Input Connection String, or the Output Connection String fields are selected for output, the following error may display:
"To use this tool select an appropriate data source and select the "Allow Decryption of Password" Password Encryption option in Manage In-DB Connections."
To resolve the error, modify the original connection string by changing the Password Encryption option to "Allow Decryption of Password" so that the password is decrypted in the metadata.
 

Was This Helpful?

Running into problems or issues with your Alteryx product? Visit the Alteryx Community or contact support.