Skip to main content

Connecting to the KWI connector

Overview​

KWI platform supports Point of Sale (POS), Merchandise/Inventory management, Order management, Customer Relationship Management (CRM), and eCommerce. You can use Skypoint's built-in connector for importing data from KWI.

Prerequisite​

  • You have a KWI account and required credentials such as username, password, and domain URL.

Import Data using KWI Connector​

Follow the below steps to create a new dataflow for the KWI import connector:

  1. In the left pane, go to Dataflow > Imports.

The Dataflow window appears.

Alt text

  1. Click New Dataflow to create dataflow.

Alt text

  1. Enter a Name to identify your Dataflow.

imageNote

Name starts with a letter. Use letters and numbers only. No spaces between letters.

  1. Click Next.

Add KWI connector​

  1. In the All or Sales tab, select the KWI connector to start the configuration.

Alt text

  1. Also, you can use the Search function to find the KWI connector.

Alt text

  1. In the Set dataflow name page, enter the Display Name to identify your dataflow.
  2. In the Description box, you can enter an explanation of the connector.
  3. Click Next.

Alt text

To configure KWI​

  1. Enter your credentials such as Username, Password, and Base URL to configure with the KWI connector. For details about each API, click KWI Commerce API Details. Also, if you want to know how to connect with API, click KWI Commerce API Try Out Functionality.
  2. Click Connect.

Alt text

  1. Enter the Table Details to process the data.
ItemDescription
PurposeOption to assign a purpose (Data or Metadata) for each table.
Data
Loads customer data
Metadata
Loads Metadata
NameDisplays the name of the file that you imported.
Table NameDisplays the imported table name. By default, it is an imported table name, but you can also change it.
  1. Click Save to apply the changes.

Run, edit, and delete the imported data​

  1. After saving the connection, the KWI connector appears on the Dataflow page. Also, you can see the list of created tables in the Databases section.

Alt text

ItemDescription
NameDisplays the name of the Dataflow.
TypeDisplays connector type symbol.
StatusIndicates whether the data is imported successfully.
Tables CountDisplays the number of tables.
Created DateDisplays date of creation.
Updated DateDisplays last modified date.
Last RefreshDisplays the latest refresh date. This date will get updated whenever you refresh the data.
Group byOption to view the items in a specific Group (For example, name, type, status).
  1. Select the horizontal ellipsis in the Actions column and do the following:
If you want toThen
Modify the DataflowSelect Edit and modify the Dataflow. Click Save to apply your changes.
Execute the DataflowSelect Run.
Bring the data to its previous stateSelect Rollback.
Delete the DataflowSelect Remove and then click the Delete button. All tables in the data source get deleted.
See the run history of the DataflowSelect Run History.

imageNote

You can see the error message corresponding to failure while importing data from a data source in the Dataflow under Run history > Description.

Next step​

After completing the data import, start the Master Data Management (MDM) - Stitch process to develop a unified view of your customers.