This guide will help you learn how to work with Sybase databases in Apatar.

Configuration

To start working with Sybase DB,

1. Drag-and-drop the Sybase connector to Apatar's work panel.
   
   
   
   
2. Double-click on the connector. The Property window will pop up.
3. Fill in the configuration details (database name, host name, user name, and password). If necessary, change the port number.
   
   
   
   
4. Click Next.
5. Choose the tables that you want to operate. To select multiple tables, click on their names holding the Control key.
   
   
   
   
6. Now, holding the Control key, select the fields that you want to operate. In the Insert mode, new data will be put after the existing. In the Update mode, the data previously contained in the field will be erased before writing new data. If you want to overwrite existing files in the Update mode, choose Yes; otherwise, choose No. You can remove all files switching the Clear all files checkbox on.
   
   
   
   
7. Click Finish.

Finally, you can preview the output data. To do so, right-click on the connector and choose Preview Results.