Dynamic Output In-DB Tool
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.
Configure the Tool
OutputFields: Select the type of data you want to output.
Query: The In-DB query created at this point in the workflow.
ConnectionName: 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, 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.