| | {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". |
