Map Query fields to SQL Server - Automate_Studio - Latest

Automate Studio with Evolve User Guide

Product type
Software
Portfolio
Integrate
Product family
Automate
Product
Automate > Automate Studio
Version
Latest
Language
English
Product name
Automate Studio
Title
Automate Studio with Evolve User Guide
Topic type
How Do I
Administration
Installation
Overview
First publish date
2018
ft:lastEdition
2024-06-13
ft:lastPublication
2024-06-13T14:35:52.915393

To send extracted data to a SQL Server database, your environment must include Evolve or Studio Manager, and Evolve or Studio Manager must be connected to a defined SQL Server. For more information, see Database Connections in Evolve Online Help.

When you save the table, you connect to SQL Server and select a database. Your new table is then created in the database.

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.

To work on SQL-mapped scripts, you must have the sysadmin role.

Map the fields

In the Mapper, you can use the table that Studio creates, or you can use an existing table and map the fields to it. Keep in mind that you can use the keyboard shortcuts CTRL Z (undo a command) and CTRL F (find a word or words) as you work within the Mapper.

Note:

To open an existing table, click the folder icon in the Data Set panel, connect to SQL Server, and then choose the table or click Create to make a new table.

  1. Drag each field that you want to map and drop it in the output table. Or click Auto Map to map fields sequentially to table columns under a column header in the output file. The changes can be seen in the field form.

    If you want, click Add Log Column to add a column into which the SAP log data can be written.

  2. Click Save.
  3. Select the SQL Server.
  4. Click Test Connection to make sure that you can connect to the server.
  5. Select the database that will store the downloaded data.
  6. Enter a name for the table. Or use the table name that Studio has provided.
  7. Click OK.

The next step is to submit the script.