You are here:

Dynamic Output In-DB Tool

The Dynamic Output In-DB tool outputs information about the In-DB workflow to a standard workflow for Predictive In-DB.

Why you would use this tool

The Dynamic Output In-DB tool is used in conjunction with the Dynamic Input In-DB tool when creating an In-DB macro for predictive analysis. The Dynamic Output In-DB tool can take the metadata from the In-DB query and pass it into a standard workflow with predictive tools.

How to use this tool

Drag a Dynamic Output In-DB tool from the Tool Palette onto the workflow canvas.
With the Dynamic Output In-DB tool selected, configure the tool using the Configuration window on the left.
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 along with an error icon .

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.