 | 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.
- Now, holding the Control key, select the fields that you want to operate. In the Insert mode, the data previously contained in the field will be erased before writing new data. In the Update mode, new data will be put after the existing.
- 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.
See also
- Microsoft SQL to PostgreSQL Migration (guide).
- GoldMine to SalesForce.com Integration (guide with screenshots).