Creating a Quick ETL Copy

How to:

The Quick ETL Copy option generates a simple Data Flow without using the Data Flow designer. For the selected table(s), all rows and columns are copied to new table(s).

Although no transformations or WHERE conditions are generated, the Data Flow can still be opened as such and additional criteria can be added.


Top of page

x
Procedure: How to Create a Quick ETL Copy for a Single Table
  1. Right-click a synonym name and select Quick ETL Copy.

    The Quick ETL Copy dialog box opens, as shown in the following image.

    Target Name

    The synonym name for the target table.

    Target Table Name

    The name of the target table in the database.

    Select DBMS

    Select a database configured as an adapter from the drop-down menu.

    Select Connection

    Select a connection for the selected adapter from the drop-down menu.

    Load Type

    Specifies the method DataMigrator uses to load data. Select Insert Records From Memory or Bulk Load Utility via Disk File if the database supports either of these options.

    Commit every row(s)

    Specifies the commit interval. This option is only available if the Load Type is set to Insert Records From Memory.

    Block size

    Specifies the number of rows to be inserted at a time. This option is only available if the Load Type is set to Insert Records From Memory.

    Application

    The application directory where the target tables and generated flow will be stored.

  2. Click Next. The Quick ETL Copy - Creating the Flow dialog box opens. From the Application field, select the application directory to which to save the flow.

    Quick ETL Copy Dialog Box

  3. Click Save or Save and Run. Two flows will be created, a process flow with the name you specified and a data flow with the name followed by the table name. For example, flow01_dmreps. The process flow calls the data flow to copy the table.

Top of page

x
Procedure: How to Create a Quick ETL Copy for Multiple Tables
  1. Right-click an application directory and select Quick ETL Copy.

    The Quick ETL Copy for Sources in dialog box opens, as shown in the following image.

  2. Select the tables you want to copy by selecting the check box in the first column. Doing so allows you to change the Target Name, which is the synonym, and the Target Table Name, which is the name of the table in the database,
  3. Click Next.

    The Quick ETL Copy - Creating the flow dialog box opens and lists all of the synonyms that you selected.

  4. Click Save or Save and Run. Two flows will be created, a process flow with the name you specified and a data flow with the name followed by the table name. For example, flow01_dmreps. The process flow calls all of the data flows.

WebFOCUS