Azure Table Storage Data Adapter

The Azure Table Storage Data Adapter provides integration between Azure Table storage and MXO , providing MXO with access to customer insights and information held within Azure Table Storage for use in decisioning.

Use the Azure Table Storage Data Adapter where customer data is held in system of record that is not directly integrated with MXO .

For more information about Azure Table storage, see the Azure Table storage documentation, on the Microsoft Azure website.

Examples

A football club have a Customer Membership system storing data about whether a customer is a member of their fan club or not. The company want to use that data in MXO to target customers with a fan club membership promotion. That data can be uploaded into Azure Table storage manually and read by MXO for decisioning.

An insurance company have used their campaign system to track customer sign up during a recent campaign. That data can also be uploaded to Azure Table Storage for use by MXO in decisioning.

Table Names

When creating your Azure Table Storage Data Adapter, you must provide a name for the table from which you want to pull data into MXO . A table name must conform to the following rules:

  • Table names must be unique within an account.
  • Table names may contain only alphanumeric characters.
  • Table names cannot begin with a numeric character.
  • Table names are case-insensitive.
  • Table names must be from 3 to 63 characters long.
  • Some table names are reserved, including "tables". Attempting to create a table with a reserved table name returns error code 404 (Bad Request).

Data Adapter Timeout Period

Requests from the Azure Table Storage Data Adapter are configured to timeout after one second. If MXO does not receive a response to a request within one second, the request will fail.

To create an Azure Table Storage Data Adapter

  1. In MXO, choose Collect.

  2. Select External Data, click Create.

  3. Choose Azure Table Storage as the type of Data Adapter you want to add.

  4. Enter a name for the Data Adapter you are adding. Using a descriptive name makes it easier for you and your team members to know when to use the Data Adapter.

  5. Enter a brief description of the Data Adapter you are adding and when it should be used.

  6. Enter the configuration details that define the adapter's behavior: | Field | Description | |---|---| | Select the attribute to use as a key | Select the captured data attribute you want to use as the key for looking up data in Azure Table storage. | | Storage account name | Name of your Windows Azure storage account. This is the DNS prefix you used when creating your storage account. For example, for the account mycostorage.table.core.windows.net, the account name is mycostorage. | | Storage account access key | The storage account access key associated with your storage account. | | Table name | Name of the table from which you want to pull data into MXO . | | Key value to use | The key value to use to pull data from Azure. A key value must be provided to pull data from Azure. |

  7. Click Test configuration. This tests and verifies that the new configuration details are valid.

  8. Click Apply.

  9. Click Save.