K3 Documents

SQL Server Target Adaptor

Updated Sep 14, 2021

SQL Server is an enterprise relational database product that forms part of the larger Microsoft enterprise application infrastructure. This adaptor will also work with Azure SQL Server instances. 

Below you will find details on how to configure the K3 SQL Server Adaptor to connect a SQL Server instance. 

SQL Server Target Adaptor

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

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

Configuration Parameter Description
DB Subname
Enter the Database Server and database useing the following format:

//<ServerName>:<Port>/<DB Name>
DB User
Enter a user that has permissions to ready from the SQL Server database which you will be connecting to.
DB Password
Enter a password for the user provided in the DB User field.

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 that query 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. 

Previous Article SQL Server Source Adaptor