Cloud Software Group, Inc. EBX®

Data Exchange Add-on Documentation > Reference Guide > Export Options

Navigation modeData Exchange Add-on Documentation > Reference Guide > Export Options

SQL export options

Overview
- Simulation page
- Results page

Overview

The sections below describe the pages and options you will be presented with when importing from an external database:

Configuration page—The options here determine basic configuration information including selection of the table, or view to import from.
Column mapping—This page allows you to map the columns from tables to those in the database.
Results page—This page shows you the import results.

Simulation page

This screen allows you to select an external database location to export to and select a Java class used to map columns. The options include:

Options	Definition
Import mode	Update or insert: If a record with the same primary key already exists in the target table, it is updated. Otherwise, a new record is inserted. Replace all content: All existing data in the table will be deleted before importing the data.
SQL table or view	Allows you to choose from external database tables or views based on the data source names which are declared in the configuration.
Mapping Java class	Displays all pre-defined SQL java classes used to map columns.

Results page

This page provides an overview of results from an import. From this page you can exit, or start a new import.

TIBCO EBX® Version 6.1.3. Copyright © Cloud Software Group, Inc. 2001-2023. All rights reserved.

All third party product and company names and third party marks mentioned in this document are the property of their respective owners and are mentioned for identification.