Skip to main content

Symon.AI help center

Export to Varicent ICM

Abstract

Set up the connection with Symon.AI and Varicent ICM to export your results.

Before you can export results to Varicent ICM, you need to set up the connector for the model you want to send results to.

Tip

To speed up your export, use the Drop tool before the Export tool to remove columns you don't need.

  1. In the pipe builder, add the Export tool and change the connection type to your Varicent ICM model.

  2. Type a name for the table.

    If you type a name that matches an existing table in your model, that table will update on a successful run. If that table does not exist, a new table will be created.

  3. In the Key columns field, select the primary keys for that table. Primary keys are unique identifiers. Tables in Varicent ICM require at least one primary key.

    For a new table, you'll be defining the columns you want to use as primary keys.

    Tip

    If your data set in Symon.AI doesn't contain unique identifiers, use the Record ID tool to add some and then set that new column as the key column.

    For an existing table, you must select the same primary key columns as defined by the Varicent ICM table.

  4. Save your changes.

  5. In the Run tab, click New run.

    • If it's your first time creating a run, click Get started.

If your run is successful, you should see these changes in Varicent ICM:

  1. If the table doesn't already exist in your model, a new table is created. If the table does exist in your model, a check is performed against the table schema. Your export could fail against an existing table if the table schema does not match exactly.

  2. That table updates with the data from Symon.AI.