Relational tables are a standard Acoustic Campaign feature. These tables offer a place to store additional data that is "related" directly to a contact database. Often this creates a one-to-many relationship between the master contact and their records being stored in the relational table. Having access to this extra data can greatly extend query building and personalization within Acoustic Campaign.
Populating a relational table can be achieved in four ways:
- Manual file import via the Acoustic Campaign user interface.
- Recurring file import from an Acoustic Campaign hosted FTP/SFTP folder.
- Acoustic Campaign API.
- Scribe Online Relational Table Connector.
The Scribe Relational Table Connector's role is simply the 'vehicle' to import data into a relational table. When you purchase the Acoustic Campaign Relational table Connector, here is what you can expect:
- An Acoustic Campaign support case will be created on your behalf and assigned to a team dedicated to assisting in the setup, configuration, and support of the connector.
- Acoustic Campaign will set up a Scribe Online Account for your organization.
- The client will be invited to the Scribe Online Account so they can create/manage connections to your Salesforce.com and Acoustic Campaign orgs. Detailed instructions are provided by Acoustic.
- Acoustic Campaign provides you with a relational table planning worksheet so you can plan out the source (Salesforce.com object) and target Acoustic Campaign structure.
- Using the relational table planning worksheet, you will then log into Acoustic Campaign and create the relational table structure.
- Once the relational table is created, Acoustic Campaign will reference the relational table planning worksheet and build a Scribe Online "Solution". This becomes an automated insert or update and possible delete synchronization to the relational table.