This guide will help you learn how to extract/load data from/to Oracle tables.

Oracle Configuration

To gain access to Oracle tables,

1. Drag-and-drop Oracle connector to Apatar's work panel.
2. Double-click on the Oracle connector.
3. Fill in the authorization details (database name, user name, password, and host name or address).
4. If necessary, change the port number.
   
   
   
   
5. Click Next.
6. The list of Oracle tables occurs. Make a selection and choose a table you would like to extract data from or write data to.

   For tables based on schemas other than default, please add the schema name before the table name in the custom SQL query window. Example: SELECT * FROM schema1.table1

7. Click Next. If all the previous actions were performed correctly, you will see the names of the data fields.
8. Click Finish.

If necessary, you can preview the data entries. To do so, right-click on the connector and choose "Preview Results".

Oracle DataMaps

Also, you can use precreated DataMaps containing Oracle connectors. Please, follow this link to download them at ApatarForge:

http://www.apatarforge.org/files/search-for-datamaps-12.html