AWS DynamoDB as Virtual Table in Dataverse sounds initially impossible, but it isn’t. The key is to set up an OData service with CRUD functionality. Today I show you how I apply full read and write access from Dataverse to my AWS Data.
To shorten a long story, firstly I setup a DynamoDB table as database in AWS. Secondly, I attach this database to my serverless AWS Lambda function, which host my OData API service. Afterwards, I implement create, read, update, and delete (CRUD) operations in my OData API. And finally, I use my Virtual Table based on my OData API per example in a canvas app in Dataverse.
AWS DynamoDB is a cloud-based NoSQL database solution that provides scalability and performance for applications. It can be used as a virtual table with CRUD operations in Dataverse, the data management platform from Microsoft. In Part 2 of this series, we will discuss how to create an AWS DynamoDB table within Dataverse and perform basic CRUD operations on it.
An AWS DynamoDB is a fast, flexible NoSQL database service for single-digit millisecond performance at any scale similar to an Azure Cosmos DB to store my data.
This code example assumes that you have already loaded data into DynamoDB for your account by following the instructions in the Creating tables and loading data ...
Apr 2, 2022 — This sample shows how to implement a custom data provider to create a virtual table that supports create, retrieve, update, ...
Jul 25, 2021 — Dataverse Virtual Tables CRUD operations is an article to will show you this impressive feature that use former Virtual Entities engine to ...
Dec 29, 2022 — A virtual table is a custom table in Microsoft Dataverse that has ... Tables in Dataverse With the Virtual connector Provider – Part-#2.