TIBCO Scribe® Online Connector For Silverpop

The TIBCO Scribe® Online Connector for Silverpop allows you to integrate Watson Campaign Automation lead, contact, account, mailing statistics, task and relational table data in Dynamics CRM, Salesforce, or other systems.

Connector Specifications

  Supported

Agent Types

On Premise X
Cloud X

Replication Services

Source  
Target  

Integration Services

Source X
Target X

Migration Services

Source  
Target  

Maps

Integration X
Request-Reply  
Message  

Note:  This Connector is available from the TIBCO Scribe® Online Marketplace. See Marketplace TIBCO Scribe® Certified Connectors for more information.

Supported Entities

The Silverpop Connector supports the following entities. Select a linked entity name for additional information when using that entity in TIBCO Scribe® Online.

Batch Processing

For better performance, use Batch Processing when possible. For the Silverpop Connector the maximum batch sizes are listed in the following table.

Watson Campaign Automation Target

Block Type

Max Batch Size

Recipients DB (Lead, Contact, Other) — Flexible DB

 

 

 

Update Insert

1000

Delete

One at a time

Merge

1

Update (related Account data)

One at a time

Recipients DB (Lead, Contact, Other) — Restricted DB

 

Update/Insert

1

Delete

1

Relational Table

 

Update/Insert

500

Delete

500

Contact List

Create

1

Contact List Member

Create

500

SMS Consent

Update/Insert

One at a time

UB Event, UB Error

Create

One at a time

Standard Operations

Entity Query Create Update Delete Upsert Merge Convert

Lead

X

 

 

X

X

X

X

Contact

X

 

 

X

X

X

 

Other

X

 

 

X

 

X

 

Account

 

 

X

 

 

 

 

GetMailingReportId

X

 

 

 

 

 

 

GetAggregateDataByMailing

X

 

 

 

 

 

 

Task

X

 

 

 

 

 

 

Relational Table

 

 

 

X

X

 

 

UB Event

 

X

 

 

 

 

 

UB Error

X

 

 

 

 

 

 

Consent

X

 

 

 

X

 

 

Contact List

X

X

 

 

 

 

 

Contact List Member

 

X

 

X

 

 

 

Note: For more information about the Watson Campaign Automation services, operations, and messages, visit the Watson Campaign Automation Portal.

Setup Considerations

Silverpop Connector has several requirements.

Selecting An Agent Type For Silverpop Connector

Refer to TIBCO Scribe® Online Agents for information on available Agent types and how to select the best Agent for your Solution.

Connecting To Watson Campaign Automation

Note: Best practice is to create Connections with credentials that limit permissions in the target system, following the principle of least privilege. Using Administrator level credentials in a Connection provides Administrator level access to the target system for TIBCO Scribe® Online users. Depending on the entities supported, a TIBCO Scribe® Online user could alter user accounts in the target system.

  1. Select More > Connections from the menu.
  2. From the Connections page select Add to open the Add a New Connection dialog.
  3. Select the Connector from the drop-down list in the Connection Type field, and then enter the following information for this Connection:
    • Name — This can be any meaningful name, up to 25 characters. Best practice is to name it after the name of your Watson Campaign Automation ORG.
    • Alias — An alias for this Connection name. The alias is generated from the Connection name, and can be up to 25 characters. The Connection alias can include letters, numbers, and underscores. Spaces and special characters are not accepted. You can change the alias. For more information, see Connection Alias.
    • Watson Campaign Automation Pod # — The pod number.
    • Refresh Token — Token that allows the Connector to authenticate to the selected pod. For more information, visit the Watson Campaign Automation Portal.
    • Database Type — Type of Watson Campaign Automation database, either Flexible or Restricted. Must be Single Opt-In or Regular. .

      Important: 

      Database Type determines the API command used while creating or updating records in Watson Campaign Automation.

      To determine the Database Type for your Connection, consider following:

      • CRM type database uses a flexible database.
      • NON-CRM type database may use a restricted databse which has one or more fields designated as the composite key.
      • If you want to work with Relational Tables, you must select CRM database type.
  4. Select Test to ensure that the Agent can connect to your database. Be sure to test the Connection against all Agents that use this Connection. See Testing Connections.
  5. Select OK/Save to save the Connection.

Metadata Notes

Consider the following for Watson Campaign Automation data fields and entity types.

Matching Data Types

If the data type of a source field does not match the data type of the mapped target field in Watson Campaign Automation, you must convert the source data to the data type of the target.

Unique Values Required

Lead, Contact, And Other entities

Unique values, such as CRM_SYNC_ID and RECIPIENT_ID, are required when using CRUD, or Create, Read, Update, and Delete operations, in the Watson Campaign Automation system. The Connector uses the unique value to find the match in Watson Campaign Automation. If no match found, the Connector creates a new record with CRM_SYNC_ID as the mapped value. RECIPIENT_ID is ignored. In this case, it is automatically generated on the Watson Campaign Automation side. The CRM_SYNC_ID is the shared key between the systems and the RECIPIENT_ID key is the native key for Watson Campaign Automation.

Account Entity

CRM_ACCOUNT_ID is used to find all related records for a specified account/parent record. Note that all related records should already have their CRM_ACCOUNT_ID field populated on the lead, or contact entity prior to using the Account entity as the Target.

Silverpop Connector As IS Source

Consider the following when using the Silverpop Connector as an IS source.

Filters

Boolean

Previewing Records

Relationships

Silverpop Connector As IS Target

Consider the following when using Watson Campaign Automation as an IS Target.

Lead, Contact, And Other Entities

Account Entity

GetMailingReportId Entity

GetAggregateDataByMailing Entity

Task Entity

Relational Table

UB Event

UB Error

Consent

Contact List

Contact List Member

TIBCO Scribe® Online API Considerations

Note: Connectors using OAuth for authentication are not fully supported by the TIBCO Scribe® Online API at this time.

More Information

For the latest information about the Silverpop Connector, visit the Watson Campaign Automation Portal.