Map query fields to SQL Server
To send extracted data to a SQL Server database, your environment must include Winshuttle Foundation, which must be connected to a defined SQL Server. For more information, see the Database Connection article in the Foundation Help Center.
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.
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. Note: you can use the keyboard shortcuts CTRL Z (undo a command) and CTRL F (find a word or words).
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.
- 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.
- Click Save.
- Select the SQL Server.
- Click Test Connection to make sure that you can connect to the server.
- Select the database that will store the downloaded data.
- Enter a name for the table. Or use the table name that Studio has provided.
- Click OK.
The next step is to submit the script.