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.
Copyright © Cloud Software Group, Inc. All rights reserved.