Dynamic Output In-DB Tool

Use Dynamic Output In-DB to output 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, visit In-Database Overview.

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.

If either the Input Connection String or the Output Connection String fields are selected for output, this error might 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.