Associate a database to a relational table
- Select Data from the menu.
- Click the database name to choose your database from the list.
Your database must have a field that contains the same data as this field in the relational table.
- Click Associate Table.
- Select the relational table that you want to associate with the database.
- Click Select.
- On the Database Fields drop-down menu, select the database field for which you want to create a relationship.
- Click the Table Fields menu and select the matching database field you chose in the Database Fields drop-down (optional step, but verify the field is correct).
- When you finish mapping your field(s), click Map.
- To map additional fields, click the add an additional field mapping link and follow steps 6-8.
- Click Submit.
- Click Submit again to submit a relational table association data job that will run in the background. The Data Job Submitted box displays with the message "The relational table association data job has been submitted."
- Select the Reference link displayed on the Data Job Submitted box to view further information about the Data Job.
If you are trying to associate more than 100 relational tables to a database in the user interface, the browser request limit to check for existing relationships may be reached. Either reduce the number of existing associations or use the JoinTable API, as described below. You can find potential other "gotchas" here.
Associate a relational table to a database via API using the JoinTable API
You can associate a relational table to a database in the API using the JoinTable API. The Export Table API supports exporting relational table data from Acoustic Campaign into a CSV file, which Acoustic Campaign uploads to the FTP account or to the stored files directory associated with the session. This functionality is available only through the API, not through the Acoustic Campaign user interface. You can find more details for using the JoinTable API in our developer experience.
Find which database is associated with a relational table
- Select View Data.
- On the View Data page, click the Relational Tables tab and take the following steps.
- Click the relational table in the Table Name column.
- Click the Contact Source Associated tab to view the associated database.
- Select the database from the Database Name column.
The association is visible in the Associated Relational Tables section near the bottom of the page.
Remove a relational table association
You can remove relational table associations only by using the Join Table XML API.
In the following example, to remove a child relational table association, enter the parent table ID in the
LIST_ID area and child table ID in the
<Envelope><Body> <JoinTable> <TABLE_ID></TABLE_ID> <LIST_ID></LIST_ID> <REMOVE/> </JoinTable> </Body></Envelope>
Associate a child relational table to a parent relational table
After you import the child relational table, you can associate it to a parent relational table. This association is created from the Relational Table Summary screen for the parent table.
- Go to Data.
- Select the Relational Tables tab.
- Select the Parent Table from the list of associated relational tables.
- From the Parent Relational Table Summary screen, click Associate Child Table.
- Select the Child Relational Table from the selection box.
All relational tables are listed here, but any table ineligible to be a child table cannot be selected.
- Click Select.
- Map the parent table field(s) to the child table field(s).
- Click Submit
When you select the Parent Table Field, all Child Table Fields that do not match the Parent Table Field type are grayed out and cannot be selected. For example: Only the fields that are defined as a Numeric data type can be mapped to other Numeric data fields.
- (Optional) To view the relational table Summary screen for the child table, select the name of the child relational table. The Relational Table Summary screen for a child table differs slightly from the Relational Table Summary screen for a parent table:
- Create Table Query - button is disabled because table queries with child table criteria must be initiated from the parent table.
- Associate Child Table - button is disabled because child tables cannot have children.
- Queries - Tab is hidden because table queries with child table criteria must be initiated from the parent table.
- Contact Sources Associated - Tab is hidden if there is no direct association to a database.
You can use the Search tab to conduct a quick spot-check of the relational table data.
Associate a zip code relational table
You can associate the Acoustic Campaign standard or a custom zip code relational table to a database.
- Select the database that you want to associate the table to and click Associate Table.
- Select the standard zip code or custom zip code relational table that you want to associate with this database.
- Map the Zip Code column in your database to the To Zip Code column in the standard or custom zip code relational table.
If you do not map this correctly, queries do not return the correct results. Therefore, it is imperative to confirm that you mapped the Zip Code field in your database to the To Zip Code field in the Relational Table before you go any further.