Dashboard > APATAR CONNECTOR GUIDES > Apatar Connector Guides > Connector for Sybase
  APATAR CONNECTOR GUIDES Log In | Sign Up   View a printable version of the current page.  
  Connector for Sybase
Added by Alex Khizhnyak, last edited by Michael Fedotov on Nov 05, 2008  (view change)
Labels: 
(None)

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.

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