Import Data

Import Sets

Transform Map

Coalesce Fields

A tool used to import data from various data sources, and map into SN Tables

JDBC

HTTP / FTP

EXCEL

CSV

XML

Mechanism to pull data

Stores Data in Imports Sets Tables

admin OR import_admin

to manage ALL aspect

Import Set Tables

import set

Data Sources:

Import Set Table:

Transform Maps:

Target Table:

SN records that contains info of an import set data source.

LDAP

From Local Source

From Network Server

LDAP connection

JDBC connection

Act as a Staging Area

Provide a Guide for moving data from Import Sets

An existing table where data wil be placed

Drag and Drop

Set of field maps

relationship between Import Set & Existing SN Table

Can be reused for Mapping data from an Import sets to a SN Table

Best Practices:

Understand what data are bringing in

Understand where it should be placed

Staging Area for records imported from a data source

Those fields are auto generated based on the imported data

can be scheduled

Plan time before an import to verify your data

Remove obsolete & Fix inaccurate data

Data should NOT be imported in Extremely large chunks

Set of field Maps that defines the relationship between fields in Import Set Table & fields in a Target Table

Existing SN Table

Import Set Table (source)

Several config

Single Field Coalesce:

Coalescing a field (or multiple) means the field will be used as a Unique Key During The Import

Automatic Mapping Utility:

Mapping Assist Utility:

The Simplest

Click the Auto Map Matching fields related links

In the Table Transf Maps form & Confirm proper matching

A Visual Intuitive Mapping Assist Utility

MAP

A single source field (Import Set) TO multiple destination fields (1 Target Table)

Is Flexible

Can use Advanced Logic

Can leverage the full power of SN Scripting Env

If Match

the existing record will be updated with info being imported

If NO Match

A NEW Record will be inserted

If No Coalesce Fields

All imported rows are treated as new records

Configuring Coalesce field

Treat the field as Unique Key

Update

Create

Multiple-field Coalesce:

Conditional Coalesce:

A script to determine the import (staging) table row should coalesce to a target record

Coalesce on multiple fields to Update an existing record

Coalesce a single field to update an existing record