This guide will help you learn how to configure the PostgreSQL connector in Apatar.

Configuration

1. Drag-and-drop the PostgreSQL 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. 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.
8. Click Finish. Now you can map the SQL connector and use it as a data source, or target.

See also

1. Microsoft SQL to PostgreSQL Migration (guide).