Add SQL Node to the Customer List | Vantage Customer Experience - Adding the Generated SQL - Vantage Customer Experience

Vantage Customer Experience Path Analysis Tutorial

Product
Vantage Customer Experience
Release Number
1.5
Published
June 2022
Language
English (United States)
Last Update
2022-07-07
dita:mapPath
vkt1594411615815.ditamap
dita:ditavalPath
oyf1565965838286.ditaval
dita:id
vkt1594411615815
Product Category
Teradata Applications

This section provides instructions on adding a segment to the customer list using a SQL node. You can add the generated SQL that you copied from Analytical segment to the SQL node.

To use the nPath node instead of SQL node, see Adding the Analytical Segment.
  1. Select and drag "" to the canvas.
    vaTutorial_dragSQL_pathSegment
  2. In the properties panel, do the following:
    Name Type Find Customers on Bill Dispute->Review Contract Path.
    Connection Select the Teradata-Vantage database connection that you created earlier.
  3. Double-click the SQL node and paste the code that you copied when you created the path segment.
    vaTutorial_workflowSQLnode_path
  4. Select Save SQL.
  5. Connect the SQL node to the customer list by selecting and dragging the following:
    From To
    The connector dot in the Start node To the SQL node
    The green connector dot in the SQL node To the End (success) node
  6. Select Save Customer List.
Your customer list should look similar to this:
vaTutorial_workflowSQLnode_path_complete