• 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 Priority over SQL Server, follow the steps below:

 

  1. Select the target 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 and Is Source checkboxes are enabled.

  1. Select the required action from the Action drop-down list:
    • Insert: Import data into the schema.
    • Update: Add the latest data to the existing schema fields.
    • Delete: Delete data from the schema.
    • Upsert: Depending on the key, either update or insert data to the schema.

Note: On selecting Update, Delete or Upsert from the Actions drop-down list, the Schema Column and Source Column appear. These fields associate a specific field in the target system to a specific field in the Schema. The rows from the Schema will Update/Delete or Upsert rows in the target system based on this association. Click Refresh to update the list of source columns.

  1. Fill in the Query following the SQL syntax taking into account that all database objects should be written in uppercase letters.

 

Query examples:

  1. Get all data from the Customers table:
  1. Get all data from the Customers table and add the database name column. This query is useful if you need to see the query result source by the database mentioned in the Database List field at the connection page.
  1. Get all data from the Customers table where the customer name begins with ‘T’. Add the database name column in the query result.

Note: The ‘like ‘T%’ will return the names ending with ‘T’ due to RTL script.

  1. Get the CUSTNAME, CUSTDES, ADDRESS, COUNTRY, STATE, STATEA fields from the Customers table:
  1. Get the CUSTNAME, COUNTRY, STATE fields from the Customers table and arrange in ascending order by state:

 

Once done, click Save and proceed with mappings.