Hi,
after making an introduction and presenting the scenario in the part 1, in this second post I show you how to create the table that has the goal of representing the external system.
In this case I used an Azure SQL database and created a table called Person.

The table have following fields:
- PersonId to store the Guid
- FirstName
- LastName
Here is the script SQL to create the table and insert two rows as example:
CREATE TABLE [dbo].[person] (
[PersonId] UNIQUEIDENTIFIER NOT NULL,
[FirstName] NVARCHAR (100) NOT NULL,
[LastName] NVARCHAR (100) NOT NULL,
[Email] NVARCHAR (100) NOT NULL
);
INSERT INTO [dbo].[person] ([PersonId],[FirstName],[LastName],[Email]) VALUES (newid(),'Danilo','Capuano','danilo@email.com')
INSERT INTO [dbo].[person] ([PersonId],[FirstName],[LastName],[Email]) VALUES (newid(),'John','Doe','john@email.com')
In this PoC, for query data I used the Query Editor available as a feature itself on the Azure SQL database:



Hope it helps, follow this serie and happy reading!