Map the query fields - Automate_Studio - 20.3

Automate Studio with Connect User Guide

Product type
Software
Portfolio
Integrate
Product family
Automate
Product
Automate > Automate Studio
Version
20.3
Language
English
Product name
Automate Studio
Title
Automate Studio with Connect User Guide
Topic type
Overview
Administration
Installation
How Do I
First publish date
2018

The way you map the fields from your script to your data file depends on the file type that you are using:

Note:

The account that you use to write to SQL Server must have db_owner or db_ddladmin membership on the database that contains the target table.

If you are using XML forms for the data file, you do not need to map the fields.

In the Mapper, you can use the keyboard shortcuts CTRL Z (undo a command) and CTRL F (find a word or words).

In Query, you can Shift Up and Shift Down multiple rows at a time within the Mapper.