Data Operators

Data Extraction (Load Data) operators connect to a data source.

Load operators, also known as Data Extraction operators, create connections to data sources to bring data into the workflow. Load operators also provide options to convert the source data formats between database and Hadoop.

  • Copy Between Databases
    Provides a mechanism for copying data from a table on one database server to another database server.
  • Copy To Database
    Provides a mechanism for copying data from Hadoop into a relational database.
  • Copy To Hadoop
    Provides a mechanism for copying relational data into a Hadoop cluster.
  • Dataset
    Connects a database table or view, allowing the data to be incorporated into the workflow. Dataset is a source operator.
  • Hadoop File
    Specifies a file or files stored on your Hadoop data source, allowing the data to be incorporated into the workflow.
  • Hive Table
    Connects a Hive Hadoop table, allowing the data to be incorporated into the workflow. Hive Table is a source operator.
  • Import Excel (DB)
    Imports an Excel workbook sheet (or a portion of the sheet) as a database table.
  • Import Excel (HD)
    Imports an Excel workbook sheet (or a portion of the sheet) as an HDFS input.
  • Load To Hive
    Provides a mechanism for saving a table directly to a Hive database. You can use any tabular Hadoop file as the input, as long as the data source is configured for the chosen Hive Hadoop source.
Related concepts