Input data

Limitations

To input data, you must have the required permissions for the corresponding dataset or data source:

• If the input type is a dataset, you must have permissions to use the dataset.

• If the input type is a data source table, you must have permissions to use the data source.

Procedure

1. Go to the data preparation page.

2. On the data preparation editor page, drag the Data Input node from the nodes panel on the left to the canvas.

   

3. In the Data Input panel, configure the following:

   • Input from a data source table

     1. Select Data source table as the input type.

     2. Select a data source.

        To find data sources that support ETL, see Data source feature list.

     3. Verify connectivity.

        If the Automatic connection failed. Please click to verify manually. message appears after you select a data source, click Verify Connectivity.

        Note

        To connect successfully to the data source, add 106.15.233.0/24 to your database whitelist.

     4. Select a data table.

        All fields from the data table now appear on the right side of the page.

     5. Select the fields to use for data input.

        Note

        You can select up to 200 fields.

     6. View data details.

        1. View data profiling results.

        2. View data details.

        3. View the field list.

   • Input from a dataset

     1. Select Dataset as the input type.

     2. Select a dataset.

        

        Note

        Using a dataset as input still requires a connection to the underlying data source, which must support data preparation.

     3. Verify connectivity.

     4. Select the fields to use for data input.

     5. View data details.

4. Repeat steps 2 to 3 to configure multiple data input nodes.

   Note

   • When you configure multiple data input nodes, you can select data sources from the same database or different databases.

   • You can add up to 5 data input nodes.