• All Files

    Import Step

    This section describes how to add and set up the connection for the Import step applicable to the tasks in the interface. For more information about steps, see Defining Steps

     

    Import step is used to import data into the IConduct Schema for transfer or further manipulation. To create the Import step, navigate to Interfaces> {Specific Interface}> Tasks> {Specific Task} > Steps >New >New Import Step.

     

    To import your data from ODBC, follow the steps below:

     

    1. Select your connection from the Connection drop-down list. Click Open for your reference, or if modifications or any changes are required in the pre-defined connection.

    Warning: If you can't find the necessary Connection in the list, go to the connection page and make sure the Is Active checkbox is enabled.

    1. Select the required action from the Action drop-down list:
    • Insert: Import new data into an empty Schema’s table.
    • Update: Add the latest data to the existing schema fields.
    • Delete: Delete data from the Schema’s table.
    • Upsert: Select to either update or insert rows of data depending upon whether a specific set of conditions are met (or not).

    Note: On selecting Update, Delete, Upsert from drop-down list, the Schema Column and Source Column appear. These fields associate a specific field in the source system to a specific field in the Schema. The rows from the source system will Update/Delete or Upsert rows in the Schema based on this association. Select required columns to enable automatic updates.

    1. Fill in the Query box using the SQL syntax.

    Note: Query syntax depends on the ODBC data type provider mentioned in the Connection String for your connection, e.g. SQL Server, SQL Azure, etc.

    The SQL QueryExample

    1. Press Create to keep the new Import Step. Proceed with Schema mapping.

    Warning: The Source Columns field in Schema mappings will contain only the fields mentioned in your import query.