ApatarForge
  Dashboard > APATAR CONNECTOR GUIDES > Apatar Connector Guides > Connector for EnterpriseDB > Information > Page Comparison
  APATAR CONNECTOR GUIDES Log In   View a printable version of the current page.  
  Connector for EnterpriseDB
compared with
Current by Alex Khizhnyak
on Nov 18, 2009 07:40.

(show comment)
 
Key
These lines were removed. This word was removed.
These lines were added. This word was added.

View page history


There are 2 changes. View first change.

 {info}This guide will help you learn how to read/write data from/to EnterpriseDB using Apatar.
 {info}
  
 h4. Description
  
 Connector allows working with Numeric Types, Character Types, Binary Data, Date/Time Types, Boolean Type, XML Document data types.
 {note}Please note that operations with the Array types are not supported.
 {note}
  
 h4. Configuration
  
 To gain access to EnterpriseDB tables, please do the following:
 # Drag-and-drop EnterpriseDB connector to Apatar's work panel.
  # Drag-and-drop the connector for EnterpriseDB to Apatar's work panel.
 \\
 \\ !enterpr1.PNG!\\
 \\
 # Double-click on the connector.
 # Fill in the authorization details (database name, user name, password, and host name or address).
 # If necessary, change the port number.
 \\
 \\ !enterpr2.PNG!\\
 \\
 # Click Next.
 # The list of EnterpriseDB tables occurs. Make a selection and choose the table you would like to extract data from or write data to.
 # Click Next.
 # Select the mode in which the transformation should run. ([Click here|INT:Table Update] 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. {note}Make sure you map the fields selected as primary keys to input fields in an operation connecting your data source and data target.{note}
  # Select the mode in which the transformation should run. ([Click here|INT:Table Update] to read about the difference between the modes.) If you select the 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. {note}Make sure you map the fields selected as primary keys to input fields in an operation connecting your data source and data target.{note}
 # Click Finish.
  
 If necessary, you can preview the data entries. 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