◄Show Table of Contents

Macro Input In-DB Tool

The Macro Input In-DB tool creates an In-DB input connection on a macro and populates it with placeholder values.

This is an In-Database 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.

Why you would use this tool

The Macro Input In-DB tool is used to display In-DB input anchors on a macro tool that can be used with In-DB workflows.

An input anchor will appear on the macro tool for each Macro Input In-DB tool used in the macro workflow in the order they are brought onto the canvas (left to right, or up to down). The input anchors can be re-ordered in the Interface Designer Window from the Tree view.

How to use this tool

1. Drag a Macro Input In-DB tool from the Tool Palette onto the workflow canvas.
2. With the Macro Input In-DB tool selected, configure the tool using the Configuration window on the left.
3. Specify the Template Input. The Template Input allows the macro workflow to be a functioning workflow and determines the field requirements for end users of the macro tool.
• Connection Name: Specify the database to connect to. Click to select the type of connection to create. You can choose to set up a new connection or manage an existing one. Existing connections appear at the bottom of the list.
  • New User Connection: Click to set up the database connection at the user level.
  • New System Connection: Click to set up the database connection at the machine level.
  • Manage Existing Connections: Click to make edits to a connection that has already been set up.
  • Existing Connections: Click the name of a connection from the list of connections that have already been set up.
• Table or Query: Displays the name of the selected table in the database once the connection has been configured. Click Query Builder to easily select tables and construct queries in the Choose Table or Specify Query Window.

You must be an admin to create In-DB system connections.

4. Input Name: The Input Name will be visible to the end user when they configure the macro tool.
5. Anchor Abbreviation: This optional parameter will display an abbreviation on the input anchor of the macro tool.
6. Show Field Map: When this option is checked, and the macro tool is added to a workflow, the end user will be asked to select the fields that match up with those in the Template Input specified in step 4.

Alteryx.com | Community | Customer Support | Documentation Feedback

©2018 Alteryx, Inc., all rights reserved. Allocate®, Alteryx®, Guzzler®, and Solocast® are registered trademarks of Alteryx, Inc.