The K3 SQL Server Target Adaptor supports pushing data to an SQL Server database. The following instructions will walk you through how to set up the SQL Server adaptor.

1. Enter the connection information and click the Test button

If the connection information is correct, a success message will be shown. Once you have successfully tested the connection click OK.  

2. Click the Build Statement Button

Clicking Build Statement starts the process of building the SQL Insert Statement to push data into the Redshift database previously configured.

3. Select the table to insert into

The Statement Builder screen allows you to select a table to insert into without manually writing any SQL. Select the table to insert into from the list of tables in the drop-down list.

4. Select the columns K3 should insert data into

Selecting the columns will build an insert query using those columns and create the target field list in K3. You are able to see the query and modify it by clicking "Customize Query". Using "Customize Query" is only recommended for advanced users. Once you have selected the desired columns, click OK.

5. Review the Insert

Once you complete the field selection process and click save, the Insert statement will be displayed. At this point, the adaptor is configured. Please be aware that you must configure the source adaptor and name the route before moving on.   

If you ever need to adjust the Insert statement you can click Edit Statement. This will bring you back into the column selection process.

Note: The columns identified in the Column selection will be available to add to the Target Field list when you initially attempt to add fields.