This tutorial will help you learn how to connect to a Microsoft SQL database in Apatar.
Configuration
Drag-and-drop the MS SQL connector icon onto Apatar's main panel.
Double-click the node to configure it.
In the Property window that appears, fill in the user name, password, host name, port number and the name of the database you want to read.
Click Next.
Now, select the tables to extract data from or write to. To select multiple items, hold the Control key when clicking them.
Click Next.
Select the mode in which the transformation should run. (Click here to read about the difference between the modes.)If you select Update mode, please also select the field(s) from the list that should be used as primary keys to define if a record already exists in the data target.
Make sure you map the fields selected as primary keys to input fields in an operation connecting your data source and data target.
Click Finish. Now you can map the SQL connector and use it as a data source, or target.
Note for Windows Authentication on Microsoft SQL Server
If you need Windows authentication (and it is usually required by system admins instead of the old-fashioned SQL Server authentication), then you will need the native driver ntlmauth.dll. Put it into \windows\system32.
