ApatarForge
  Dashboard > APATAR CONNECTOR GUIDES > Apatar Connector Guides > Connector for MS SQL (Microsoft SQL)
  APATAR CONNECTOR GUIDES Log In   View a printable version of the current page.  
  Connector for MS SQL (Microsoft SQL)
Added by Alex Khizhnyak, last edited by olga belokurskaya on Oct 23, 2009  (view change)
Labels: 
(None)

This tutorial will help you learn how to connect to a Microsoft SQL database in Apatar.

Configuration

  1. Drag-and-drop the MS SQL connector icon onto Apatar's main panel.



  2. Double-click the node to configure it.
  3. 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.



  4. Click Next.
  5. Now, select the tables to extract data from or write to. To select multiple items, hold the Control key when clicking them.



  6. Click Next.
  7. 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.




  8. 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

  1. Microsoft SQL to PostgreSQL Migration (guide).
  2. GoldMine to SalesForce.com Integration (guide with screenshots).


Site running on a free Atlassian Confluence Open Source Project License granted to Apatar Data Integration (ETL). Evaluate Confluence today.
Contact Administrators