Connect to Amazon DynamoDB to access and integrate DynamoDB data into Salesforce applications. With this adapter, take advantage of the flexible data storage capabilities of Amazon DynamoDB that provides fast and predictable performance combined with customer 360-degree view captured in Salesforce.
Required Editions
| Available in: both Salesforce Classic and Lightning Experience (not for high-data-volume external objects) |
|
Available in: Developer Edition Available for an extra cost in: Enterprise, Performance, and Unlimited Editions |
Amazon DynamoDB achieves its goals of consistent fast performance at very high scale through a series of trade-offs different from those of an RDBMS. A sophisticated partitioning scheme manages the storage of very large tables, though at that size JOINs become impractical and aren’t supported. Querying is limited in other ways as well. To understand more, see Amazon DynamoDB Developer Guide: Modeling Relational Data in DynamoDB.
Salesforce Connect Adapter for Amazon DynamoDB maps single table and multiple table designs of DynamoDB as external objects on the Salesforce Platform. You can define external object relationships to integrate DynamoDB data into your Salesforce org, based on your business requirements.
Salesforce Connect adapter for Amazon DynamoDB uses PartiQL to perform data manipulation operations, such as SELECT or UPDATE on the external objects. To know about how the Amazon DynamoDB source tables are manipulated, see Amazon DynamoDB Developer Guide: PartiQL - A SQL-Compatible Query Language for Amazon DynamoDB.
- Map Salesforce External Object Field to DynamoDB Attributes
External object fields of Salesforce Connect Adapter for Amazon DynamoDB can be mapped to attributes of string, number, and boolean scalar types. If an attribute of string type that represents a date or a timestamp is mapped to an external object field, then date, dateTime, or time must be stored in ISO 8601 format.